query_dataset
Query a Superset dataset using metrics and dimensions, aggregating over columns without raw SQL. Supports time-series, filters, and sorting.
Instructions
Query a dataset using Superset's metric/dimension abstraction.
This executes the same query path that charts use — aggregating metrics over dimension columns — without needing raw SQL. Use get_dataset to discover available metrics and columns first.
For time-series queries, set time_column plus start/end (ISO-8601) and optionally granularity (e.g. "P1D", "P1W").
Args: dataset_id: ID of the dataset to query metrics: Metric names to aggregate (e.g. ["count", "revenue"]) columns: Dimension columns to group by time_column: Time column for time-filtered or time-series queries start: Start date/time in ISO-8601 format (e.g. "2025-01-01") end: End date/time in ISO-8601 format (e.g. "2025-06-01") granularity: Time grain (e.g. "P1D", "P1W", "P1M") where: SQL WHERE clause fragment for filtering having: SQL HAVING clause fragment for post-aggregation filtering order_by: Columns or metrics to order by order_desc: If True, sort descending (default: True) row_limit: Max rows to return (default: 10000) force: If True, bypass query cache response_mode: 'compact' (columns only), 'standard' (sample rows), or 'full' (all rows). Default: standard.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataset_id | Yes | ||
| metrics | Yes | ||
| columns | No | ||
| time_column | No | ||
| start | No | ||
| end | No | ||
| granularity | No | ||
| where | No | ||
| having | No | ||
| order_by | No | ||
| order_desc | No | ||
| row_limit | No | ||
| force | No | ||
| response_mode | No | standard |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |