---
title: "Get all Databricks warehouses"
method: GET
path: "/api/v1/databricks/warehouses"
tags: ["DATABRICKS", "Databricks", "Databricks Warehouses"]
---

# Get all Databricks warehouses

`GET /api/v1/databricks/warehouses`

Get list of all warehouses.

## Query parameters

- `workspace_id` string, nullable — Filter by workspace ID
- `start_date` string, date, nullable — Start date (inclusive) for cost / utilization metrics. Defaults to 30 days before `end_date`.
- `end_date` string, date, nullable — End date (inclusive). Defaults to today.
- `page` integer — Page number (1-indexed)
- `page_size` integer — Items per page
- `sortAttribute` string, nullable — Sort column name. Valid columns: warehouse_name, workspace_name, warehouse_type, warehouse_size, min_num_clusters, max_num_clusters, auto_stop_mins, last_state_change, estimated_cost, auto_tune_savings (both sorted with nulls last).
- `sortOrder` string, nullable — Sort direction: 'asc' or 'desc'
- `warehouse_names` string[], nullable — Filter by warehouse names
- `warehouse_ids` string[], nullable — Exact-match filter by one or more warehouse IDs
- `warehouse_types` string[], nullable — Filter by warehouse types (CLASSIC, PRO, SERVERLESS)
- `warehouse_sizes` string[], nullable — Filter by warehouse sizes
- `workspace_ids` string[], nullable — Filter by one or more workspace IDs
- `auto_tune_status` string, nullable — Filter by auto-tune status: 'enabled' or 'disabled'.
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- WarehousesResponse — Response for listing warehouses.
  - `warehouses` WarehouseSummary[], required
    - `warehouse_id` string, required
    - `warehouse_name` string, required
    - `workspace_id` string, required
    - `workspace_name` string, nullable
    - `instance_id` integer, nullable
    - `warehouse_type` string, nullable
    - `warehouse_size` string, nullable
    - `dbus_per_hour` number, nullable
    - `min_num_clusters` integer, nullable
    - `max_num_clusters` integer, nullable
    - `auto_stop_mins` integer, nullable
    - `state` string, nullable
    - `num_clusters` integer, nullable
    - `num_active_sessions` integer, nullable
    - `last_state_change` string, date-time, nullable
    - `total_dbus` number, nullable
    - `estimated_cost` number, nullable
    - `tags` object, nullable
    - `median_queueing_time_ms` number, nullable
    - `median_execution_time_ms` number, nullable
    - `median_total_time_ms` number, nullable
    - `active_seconds` integer, nullable
    - `idle_seconds` integer, nullable
    - `query_count` integer, nullable
    - `realized_savings` number, nullable
    - `estimated_annualized_savings` number, nullable
    - `is_auto_tune_enabled` string, nullable
  - `total_count` integer, required — Total number of warehouses
  - `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/50769cbf05d5/schema)