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

# Paginated auto-tune audit history for a SQL warehouse

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

## Request

- Base URL: `https://api.myaltimate.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.myaltimate.com/api/v1/databricks/warehouses/{warehouse_id}/auto-tune/history`
- Auth: one of:
  - HTTP bearer
  - HTTP bearer

Read-only audit history for the SQL-warehouse Auto Tune tab.

Most-recent first. Each row carries a server-composed ``event_message``
(+ optional ``reason`` accordion detail) built from the audit
``attributes`` via ``compose_warehouse_event_message`` so the FE renders
one string verbatim, mirroring the jobs history + Snowflake designs.

## 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 the audit query to the correct workspace (defends against cross-workspace warehouse_id collisions).
- `event_types` string, nullable: Comma-separated filter-group keys to include: toggle, apply, backoff, config, monitor. Empty/omitted = all events (including the high-volume MONITOR_TICK rows).
- `period` integer, nullable: Look-back window in days; excludes rows older than now - period.
- `page` integer: Page number (1-indexed)
- `page_size` integer: Items per page

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- AutoTuneHistoryResponse: Paginated response wrapper for the Auto Tune history endpoint. Matches the existing Databricks response convention (``total_count`` / ``page`` / ``page_size`` / ``total_pages``) rather than ``fastapi_pagination.Page[T]`` — none of the other Databricks endpoints in this router use the latter. Shared by the job-cluster history endpoint and the all-purpose-cluster history endpoint (``cluster_auto_tune_api.py``). Both populate ``reason_detail`` from stored audit evidence; a row with nothing to explain carries ``reason_detail=None`` and the FE falls back to ``actionable_message`` / ``reason``.
  - `items` AutoTuneHistoryEvent[], required
    - `event_id` integer, required
    - `event_type` string, required
    - `mode` string, nullable
    - `change_timestamp` string, date-time, required
    - `task_key` string, nullable
    - `recommendation_from` string, nullable
    - `recommendation_to` string, nullable
    - `change_summary` string, nullable
    - `recommendation_from_workers` string, nullable
    - `recommendation_to_workers` string, nullable
    - `recommendation_from_worker_instance` string, nullable
    - `recommendation_to_worker_instance` string, nullable
    - `recommendation_from_driver_instance` string, nullable
    - `recommendation_to_driver_instance` string, nullable
    - `changed_by` integer, nullable
    - `changed_by_name` string, nullable
    - `actionable_message` string, nullable
    - `reason` string, nullable
    - `event_message` string
    - `reason_detail` string, nullable
    - `rec_type` string, nullable
  - `total_count` integer
  - `page` integer
  - `page_size` integer
  - `total_pages` integer

## Other responses

- `403`: Not authorized
- `422`: Validation Error

## Changes

- **2026-09-02** `fcb62c79da95`: 2 info
  - added the optional property `items/items/change_summary` to the response with the `200` status
  - added the optional property `items/items/rec_type` to the response with the `200` status

[Operation history](https://skmtc.dev/myaltimate/apis/fastapi/changes/api/v1/databricks/warehouses/:warehouse_id/auto-tune/history/get.md)

---

[API](https://skmtc.dev/myaltimate/apis/fastapi.md) - [All operations](https://skmtc.dev/myaltimate/apis/fastapi/llms.txt) - [OpenAPI document](https://skmtc.dev/myaltimate/apis/fastapi/revisions/e0c123b49501?raw)