v

OpenAPI 3.1.02026-08-081,0211,3082.1 MB
DATABRICKS
Databricks
Databricks Queries

Get 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
get/api/v1/databricks/queries/unified

Query parameters

start_datestring date required

Start date

Start date

end_datestring date

End date

End date

workspace_idstring nullable

Filter by single workspace ID (legacy URL pre-selection)

Filter by single workspace ID (legacy URL pre-selection)

workspace_idsstring[] nullable

Filter by one or more workspace IDs (column multi-select)

Filter by one or more workspace IDs (column multi-select)

warehouse_idstring[] nullable

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.

compute_idstring[] nullable

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.

insightsstring[] nullable

Filter by insight tags (slow_query, disk_spill, full_table_scan, failed)

Filter by insight tags (slow_query, disk_spill, full_table_scan, failed)

statement_typestring nullable

Filter by statement type

Filter by statement type

user_namestring[] nullable

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.

statement_idsstring[] nullable

Filter by one or more exact query (statement) IDs

Filter by one or more exact query (statement) IDs

pageinteger

Page number (1-indexed)

Page number (1-indexed)

page_sizeinteger

Number of items per page

Number of items per page

sort_bystring

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_orderstring

Sort order: 'asc' or 'desc'

Sort order: 'asc' or 'desc'

navigationSourcestring nullable

Headers

x-tenantstring required

Response

Successful Response

total_countinteger required

Total number of queries matching filters

pageinteger

Current page number

page_sizeinteger

Number of items per page

total_pagesinteger

Total number of pages