---
title: "Get all users with query statistics"
method: GET
path: "/api/v1/databricks/users"
tags: ["DATABRICKS", "Databricks", "Databricks Users"]
---

# Get all users with query statistics

`GET /api/v1/databricks/users`

Get all users with query statistics.

## Query parameters

- `start_date` string, date, nullable — Start date (inclusive) for query / cost statistics. Defaults to 30 days before `end_date`.
- `end_date` string, date, nullable — End date (inclusive). Defaults to today.
- `workspace_id` string, nullable — Filter by workspace ID
- `page` integer — Page number (1-indexed)
- `page_size` integer — Items per page
- `sortAttribute` string, nullable — Sort column name. Valid columns: user_name, total_queries, successful_queries, failed_queries, avg_duration_ms, max_duration_ms, total_duration_ms, total_read_bytes, total_spilled_bytes, last_query_time, total_dbus, total_cost (cost columns sorted with zeros/nulls last).
- `sortOrder` string, nullable — Sort direction: 'asc' or 'desc'
- `user_names` string[], nullable — Filter by user names
- `user_types` DatabricksUserType[], nullable — Filter by identity type(s). Repeat to combine: 'USER', 'SERVICE_PRINCIPAL'
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- AppSchemasDatabricksUserUsersResponse — Response for listing users.
  - `users` DatabricksUser[], required
    - `user_name` string, required
    - `user_type` 'USER' | 'SERVICE_PRINCIPAL' — Type of Databricks user identity.
    - `total_queries` integer
    - `successful_queries` integer
    - `failed_queries` integer
    - `avg_duration_ms` number
    - `max_duration_ms` integer, nullable
    - `total_duration_ms` integer
    - `total_read_bytes` integer
    - `total_spilled_bytes` integer
    - `last_query_time` string, date-time, nullable
    - `unique_statement_types` integer
    - `total_dbus` number
    - `total_cost` number
  - `total_count` integer, required — Total number of users
  - `page` integer — Current page number
  - `page_size` integer — Items per page
  - `total_pages` integer — Total number of pages

## 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/103580dad816/schema)