---
title: "Get realised savings range and estimated annual savings for a SQL warehouse"
method: GET
path: "/api/v1/databricks/warehouses/{warehouse_id}/auto-tune/savings-summary"
tags: ["DATABRICKS", "Databricks", "Databricks Warehouses"]
---

# Get realised savings range and estimated annual savings for a SQL warehouse

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

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

Get the "Realised Savings" range and "Estimated Annual Savings"
figure shown above a SQL warehouse's detail tabs. Realised savings are
summed over ``[start_date, end_date]``; the annual estimate annualizes a
trailing 29-day actual+potential run-rate independent of that range.

## 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
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- WarehouseAutoTuneSavingsSummaryResponse: Realised savings range + a derived annualized estimate for the two stat blocks shown above the SQL warehouse detail tabs. ``realized_savings`` sums ``actual`` savings over the caller's ``start_date``/``end_date`` window. ``estimated_annual_savings`` is independent of that window: it annualizes a trailing 29-day actual+potential run-rate (capped at today), mirroring ``DatabricksSavingsService.get_overall_savings_estimate``'s methodology, scoped to this one warehouse. Sourced entirely from ClickHouse ``dbx_auto_tune_cost_savings`` — no Postgres insights table.
  - `warehouse_id` string, required
  - `realized_savings` WarehouseRealizedSavings, required: Realised (``actual``) auto-tune savings for a SQL warehouse over a date range: a total plus the min/max range across the underlying per-period estimates.
    - `total` number
    - `min` number
    - `max` number
  - `estimated_annual_savings` number
  - `currency` string

## Other responses

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

---

[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)