v5
OpenAPI 3.1.02026-08-081,0211,3082.1 MBGet unified queries with insights
Get unified queries with computed insight tags.
Each query is automatically tagged with applicable insights:
- slow_query: Query duration >= 60 seconds
- disk_spill: Memory spill >= 1MB
- full_table_scan: Data read >= 1GB
- failed: Query failed to execute
Query parameters
Start date
Start date
End date
End date
Filter by single workspace ID (legacy URL pre-selection)
Filter by single workspace ID (legacy URL pre-selection)
Filter by one or more workspace IDs (column multi-select)
Filter by one or more workspace IDs (column multi-select)
Filter by one or more warehouse IDs (legacy column multi-select). Prefer compute_id for new FE bindings — it covers warehouse + cluster + pipeline in one parameter. Entries here are merged with any compute_id warehouse selections before the BE applies the filter.
Filter by one or more warehouse IDs (legacy column multi-select). Prefer compute_id for new FE bindings — it covers warehouse + cluster + pipeline in one parameter. Entries here are merged with any compute_id warehouse selections before the BE applies the filter.
Unified Compute filter: one or more {kind}:{id} selections from the dropdown, where kind is warehouse, cluster, or pipeline. A mixed selection is ORed (rows of any selected kind match). Entries with an unknown kind or empty id are silently skipped so this stays forward-compatible if the FE adopts a new kind ahead of the BE.
Unified Compute filter: one or more {kind}:{id} selections from the dropdown, where kind is warehouse, cluster, or pipeline. A mixed selection is ORed (rows of any selected kind match). Entries with an unknown kind or empty id are silently skipped so this stays forward-compatible if the FE adopts a new kind ahead of the BE.
Filter by insight tags (slow_query, disk_spill, full_table_scan, failed)
Filter by insight tags (slow_query, disk_spill, full_table_scan, failed)
Filter by statement type
Filter by statement type
Filter by one or more user names. Single-value calls (e.g. the User-list drilldown URL ?user_name=alice) continue to work — FastAPI parses the single value as a one-element list and the BE applies the matching IN-clause filter. Multi-select dropdowns send ?user_name=alice&user_name=bob.
Filter by one or more user names. Single-value calls (e.g. the User-list drilldown URL ?user_name=alice) continue to work — FastAPI parses the single value as a one-element list and the BE applies the matching IN-clause filter. Multi-select dropdowns send ?user_name=alice&user_name=bob.
Filter by one or more exact query (statement) IDs
Filter by one or more exact query (statement) IDs
Page number (1-indexed)
Page number (1-indexed)
Number of items per page
Number of items per page
Column to sort by. Allowed: estimated_cost_usd, start_time, total_duration_ms, read_bytes, spilled_local_bytes, statement_type, user_name, warehouse_name, workspace_name.
Column to sort by. Allowed: estimated_cost_usd, start_time, total_duration_ms, read_bytes, spilled_local_bytes, statement_type, user_name, warehouse_name, workspace_name.
Sort order: 'asc' or 'desc'
Sort order: 'asc' or 'desc'
Headers
Response
Successful Response