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

# Get query breakdown by user

`GET /api/v1/databricks/queries/breakdown/user`

Get query counts and stats grouped by user.

## Query parameters

- `start_date` string, date, required — Start date
- `end_date` string, date — End date
- `workspace_id` string, nullable — Filter by workspace ID
- `limit` integer — Maximum number of users
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- UserQueryBreakdownResponse — Response for user query breakdown.
  - `breakdown` UserQueryStats[], required
    - `user_name` string, required
    - `query_count` integer, required
    - `avg_duration_ms` number, required
    - `total_read_bytes` integer, required

## 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)