superset_chart_data
Run custom queries against Apache Superset datasets to extract raw data directly, avoiding chart creation.
Instructions
Execute an arbitrary query against a dataset and retrieve data.
Allows fetching data directly from a dataset without creating a chart. To get data from an existing chart, use chart_get_data instead.
Args: query_context: JSON string with the query context. Format: { "datasource": {"id": , "type": "table"}, "queries": [{ "columns": ["col1", "col2"], "metrics": [{"label": "count", "expressionType": "SIMPLE", "aggregate": "COUNT", "column": {"column_name": "id"}}], "filters": [{"col": "status", "op": "==", "val": "active"}], "orderby": [["col1", true]], "row_limit": 100, "time_range": "Last 7 days" }], "result_format": "json", "result_type": "full" } IMPORTANT: time_range is specified at the QUERY level, NOT inside extras. Allowed time_range values: "Last day", "Last week", "Last month", "Last year", "No filter", or "2024-01-01 : 2024-12-31".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query_context | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |