---
title: "Get auto-tune status for a SQL warehouse"
method: GET
path: "/api/v1/databricks/warehouses/{warehouse_id}/auto-tune/status"
tags: ["DATABRICKS", "Databricks", "Databricks Warehouses"]
---

# Get auto-tune status for a SQL warehouse

`GET /api/v1/databricks/warehouses/{warehouse_id}/auto-tune/status`

Get the current auto-tune mode, backoff thresholds, active
recommendation, in-progress monitoring window, and most recent audit
event for a SQL warehouse — the FE detail page's Auto Tune panel.

## Path parameters

- `warehouse_id` string, required

## Query parameters

- `instance_id` integer, required — Tenant instance ID (workspace) the warehouse runs in
- `workspace_id` string, required — Required Databricks workspace_id. Scopes credential resolution to the correct workspace on multi-workspace tenants (defends against cross-workspace warehouse_id collisions) AND is the join key the ingestion cost-savings mart uses to attribute realized savings on (workspace_id, entity_id); an empty or mismatched value silently drops all actual savings for this warehouse.

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- WarehouseAutoTuneStatusResponse — Response for ``GET /databricks/warehouses/{id}/auto-tune/status``. This is the FE's contract for the warehouse detail page's Auto Tune panel — every field is intentionally optional/nullable so a never-touched warehouse (no config row, no recommendation, no history) still returns a well-formed 200 rather than a 404.
  - `auto_tune_mode` 'enabled' | 'disabled', required
  - `backoff_configuration` WarehouseAutoTuneBackoffConfiguration — User-configured backoff thresholds for the 7-day post-apply monitor. Mirrors Snowflake's ``BackoffConfiguration`` shape (percentages, not raw ratios) but adds bounds validation Snowflake's never had — a threshold below 110% would trigger backoff on ordinary noise, and an absurdly high one (past 1000%) defeats the monitor's purpose entirely. Both default to 150 (allow up to 1.5x the baseline before treating it as a regression).
    - `max_latency_percentage` number — Backoff triggers when live p95 latency exceeds this percentage of the pre-apply baseline for the sustained-breach window.
    - `max_queue_time_percentage` number — Backoff triggers when live p95 queue time (cold-start + at-capacity) exceeds this percentage of the pre-apply baseline.
  - `current_auto_stop_mins` integer, nullable — Live-read from Databricks; None on a read failure (never guessed).
  - `active_recommendation` WarehouseAutoTuneActiveRecommendation — The current actionable recommendation, if any.
    - `rk` string, required
    - `recommended_auto_stop_mins` integer, nullable
    - `created_on` string, date-time, required
  - `monitoring` WarehouseAutoTuneMonitoring — The 7-day post-apply monitoring window, if one is in progress or has produced a stabilized/backed-off value.
    - `applied_at` string, date-time, required
    - `window_ends_at` string, date-time, required
    - `stable_auto_stop_mins` integer, nullable
    - `last_bad_auto_stop_mins` integer, nullable
  - `last_event` WarehouseAutoTuneLastEvent — The most recent audit event for this warehouse, for a lightweight "last changed" display without a full audit-history fetch.
    - `event_type` string, required
    - `change_timestamp` string, date-time, required
  - `preflight` WarehouseAutoTuneEnablePreflight — Whether the SP can currently enable auto-tune on this warehouse. Surfaced on the status response so the FE can render the Auto Tune Switch disabled with a persistent reason (instead of a momentary toast on a failed enable) when the service principal lacks CAN_MANAGE. Fail-open: any credential/read/timeout error leaves ``blocked=False`` (the hard enable-gate in the toggle path still protects the mutation).
    - `blocked` boolean
    - `reason` string, nullable
    - `actionable_message` string, nullable
  - `pending_apply` boolean

## Other responses

- `403` — Not authorized
- `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)