GitHub user rsaleev added a comment to the discussion: Warm up charts cache via
API
@dosu
I have created manually query_context and chart updated
`{"datasource":{"id":344,"type":"table"},"force":false,"queries":[{"filters":[{"col":"Variable","op":"IN","val":"speed"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[{"columnType":"BASE_AXIS","sqlExpression":"x","label":"x","expressionType":"SQL","isColumnReference":true},"Group"],"metrics":[{"aggregate":"COUNT_DISTINCT","column":{"advanced_data_type":null,"changed_on":"2026-03-22T11:07:28.809501","column_name":"data_fact","create_on":null,"description":null,"expression":"","filterable":true,"groupby":true,"id":1727,"is_active":true,"is_dttm":false,"python_date_format":null,"type":"DOUBLE
PRECISION","type_generic":0,"uuid":"36cd406c-391c-4049-845c-bd913e5b0677","verbose_name":null},"datasourceWarning":false,"expressionType":"SIMPLE","hasCustomLabel":true,"label":"COUNT_DISTINCT(COUNT
DISTINCT(speed))","optionName":"metric_7d720999-8114-4494-a05a-b3d6f836a68a","sqlExpression":null}],"orderby":[[{"aggregate":"COUNT_DISTINCT","column":{"advanced_data_type":null
,"changed_on":"2026-03-22T11:07:28.809501","column_name":"data_fact","create_on":null,"description":null,"expression":"","filterable":true,"groupby":true,"id":1727,"is_active":true,"is_dttm":false,"python_date_format":null,"type":"DOUBLE
PRECISION","type_generic":0,"uuid":"36cd406c-391c-4049-845c-bd913e5b0677","verbose_name":null},"datasourceWarning":false,"expressionType":"SIMPLE","hasCustomLabel":true,"label":"COUNT_DISTINCT(COUNT
DISTINCT(speed))","optionName":"metric_7d720999-8114-4494-a05a-b3d6f836a68a","sqlExpression":null},false]],"annotation_layers":[],"series_columns":["Group"],"series_limit":0,"group_others_when_limit_reached":false,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"time_offsets":[],"post_processing":[{"operation":"pivot","options":{"index":["x"],"columns":["Group"],"aggregates":{"COUNT_DISTINCT(COUNT
DISTINCT(speed))":{"operator":"mean"}},"drop_missing_columns":false}},{"operation":"rename","options":{"columns":{"COUNT_DISTINCT(CO
UNT
DISTINCT(speed))":null},"level":0,"inplace":true}},{"operation":"contribution","options":{"orientation":"row","time_shifts":[]}},{"operation":"flatten"}]}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":"speed","expressionType":"SIMPLE","operator":"IN","subject":"Variable"}],"contributionMode":"row","dashboards":[275],"datasource":"344__table","groupby":["Group"],"legendOrientation":"bottom","legendType":"plain","metrics":[{"aggregate":"COUNT_DISTINCT","column":{"advanced_data_type":null,"changed_on":"2026-03-22T11:07:28.809501","column_name":"data_fact","create_on":null,"description":null,"expression":"","filterable":true,"groupby":true,"id":1727,"is_active":true,"is_dttm":false,"python_date_format":null,"type":"DOUBLE
PRECISION","type_generic":0,"uuid":"36cd406c-391c-4049-845c-bd913e5b0677","verbose_name":null},"datasourceWarning":false,"expressionType":"SIMPLE","hasCustomLabel":true,"label":"COUNT_DISTINCT(COUNT
DISTINCT(speed))","optionName":"metric_7d720999-81
14-4494-a05a-b3d6f836a68a","sqlExpression":null}],"minorSplitLine":true,"only_total":true,"orientation":"horizontal","rich_tooltip":false,"seriesType":"bar","show_empty_columns":true,"show_legend":true,"show_value":true,"slice_id":803,"sort_series_type":"COUNT_DISTINCT","stack":"Stack","tooltipTimeFormat":"%d/%m/%Y","truncateXAxis":false,"truncate_metric":true,"viz_type":"echarts_timeseries","xAxisLabelRotation":"0","x_axis":"x","x_axis_sort_series":"name","x_axis_sort_series_ascending":true,"x_axis_time_format":"%d/%m/%Y","x_axis_title":"status_tab","x_axis_title_margin":30,"y_axis_bounds":[null,null],"y_axis_format":",d","y_axis_title":"COUNT
DISTINCT(speed)","y_axis_title_margin":30,"y_axis_title_position":"Left","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}`
when I try warm_up_cache error raised, but I don't see traceback in superset
web logs
charts.WarmUpError: unhashable type: 'list'
GitHub link:
https://github.com/apache/superset/discussions/38718#discussioncomment-16257677
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
