---
title: "Get per-day auto-tune savings (realized + potential) for a SQL warehouse"
method: GET
path: "/api/v1/databricks/warehouses/{warehouse_id}/auto-tune/savings-trends"
tags: ["DATABRICKS", "Databricks", "Databricks Warehouses"]
---

# Get per-day auto-tune savings (realized + potential) for a SQL warehouse

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

## 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/savings-trends`
- Auth: one of:
  - HTTP bearer
  - HTTP bearer

Get realized and potential auto-tune savings per day for a SQL
warehouse, scoped to the warehouse's auto-stop tuning.

## Path parameters

- `warehouse_id` string, required

## Query parameters

- `instance_id` integer, required: Databricks instance id
- `start_date` string, date, required: Start date
- `end_date` string, date: End date
- `granularity` string: Time granularity: 'day', 'week', or 'month'
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- WarehouseAutoTuneSavingsTrendsResponse: Per-period auto-tune savings for a SQL warehouse, split into realized and potential. ``actual`` holds savings while an applied auto-tune recommendation (e.g. a lowered auto-stop) was in effect; ``potential`` holds the savings an active, not-yet-applied recommendation would have earned over the same window. Sourced from ClickHouse ``dbx_auto_tune_cost_savings``.
  - `warehouse_id` string, required
  - `actual` WarehouseAutoTuneSavingsTrendPoint[]
    - `period` string, required
    - `cost_saved` number
    - `dbus_saved` number
    - `min_cost_saved` number
    - `max_cost_saved` number
    - `rec_type` string, nullable
  - `potential` WarehouseAutoTuneSavingsTrendPoint[]
    - `period` string, required
    - `cost_saved` number
    - `dbus_saved` number
    - `min_cost_saved` number
    - `max_cost_saved` number
    - `rec_type` string, nullable
  - `granularity` string, required

## Other responses

- `403`: Not authorized
- `404`: No ClickHouse database configured
- `422`: Validation Error

## Changes

- **2026-09-11** `70e0a3e5cb0d`: 2 info
  - added the optional property `actual/items/rec_type` to the response with the `200` status
  - added the optional property `potential/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/savings-trends/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)