---
title: "Get query summary metrics"
method: GET
path: "/api/v1/databricks/queries/summary"
tags: ["DATABRICKS", "Databricks", "Databricks Queries"]
---

# Get query summary metrics

`GET /api/v1/databricks/queries/summary`

Get summary metrics for queries.

Accepts the same filter set as ``GET /queries/unified`` so the summary
cards reflect the exact rows the queries table renders for a given
filter selection.

## Query parameters

- `start_date` string, date, required — Start date
- `end_date` string, date — End date
- `workspace_id` string, nullable — Filter by single workspace ID (legacy URL pre-selection)
- `workspace_ids` string[], nullable — Filter by one or more workspace IDs (column multi-select)
- `warehouse_id` string[], 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.
- `compute_id` string[], 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.
- `insights` string[], nullable — Filter by insight tags (slow_query, disk_spill, full_table_scan, failed)
- `statement_type` string, nullable — Filter by statement type
- `user_name` string[], 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``.
- `statement_ids` string[], nullable — Filter by one or more exact query (statement) IDs
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- QuerySummaryResponse — Response for query summary.
  - `summary` QuerySummary, required — Summary metrics for queries.
    - `total_queries` integer
    - `unique_statement_types` integer
    - `successful_queries` integer
    - `failed_queries` integer
    - `avg_duration_ms` number
    - `total_read_bytes` integer
    - `total_spilled_bytes` integer
    - `total_cost` number

## Other responses

- `403` — Not authorized
- `404` — No ClickHouse database configured
- `422` — Validation Error

---

[API](https://skmtc.net/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.net/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/myaltimate/fastapi/versions/aab3fe5c9f05/schema)