> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Active SQL Warehouses, Databricks

> Active SQL Warehouses for Databricks workspaces. Tracked live in Vortex IQ Nerve Centre. How to read it, why it matters, and how to act on it.

**Card class:** [Non-Hero](/nerve-centre/overview#card-classes-explained)  •  **Category:** [Executive Overview](/nerve-centre/connectors#connectors-by-type)

## At a glance

> The count of Databricks SQL warehouses currently in a `RUNNING` (or `STARTING`) state in the connected workspace. SQL warehouses are the compute behind dashboards, BI tools, and ad-hoc SQL, and they bill on the SQL DBU SKU, separate from clusters. This is the fast answer to "how much query compute is live and billing right now?"

## What it tracks

The value is a live count of SQL warehouses returned by the SQL Warehouses API where the `state` is `RUNNING` or `STARTING`, polled in real time (`RT`) every 60 seconds. It deliberately excludes `STOPPED`, `STOPPING`, and `DELETED` warehouses, so the number reflects compute that is actually available to serve queries and consuming SQL DBUs.

Each warehouse counts as 1 regardless of its size (2X-Small through 4X-Large) or whether multi-cluster scaling has spun up extra clusters underneath it. That makes this a "how many query endpoints are alive" pulse rather than a cost figure. To weight it by spend, read it alongside [DBU Burned (24h)](/nerve-centre/kpi-cards/databricks/dbu-burned-24h), and to see whether the live warehouses are actually busy, pair it with [SQL Warehouse Saturation %](/nerve-centre/kpi-cards/databricks/sql-warehouse-saturation) and [Active SQL Sessions](/nerve-centre/kpi-cards/databricks/active-sql-sessions). The classic signal here is a warehouse left running out of hours with auto-stop misconfigured, which is pure wasted DBU. Compute clusters are counted separately on [Active Clusters](/nerve-centre/kpi-cards/databricks/active-clusters).

## Reconciling against the source

Confirm the live count in the workspace under **SQL → SQL Warehouses** (filter to Running), via `databricks warehouses list` on the Databricks CLI, or against the `system.compute.warehouse_events` system table for the historical record. A brief difference versus the UI is expected because Vortex IQ polls every 60 seconds.

***

### Tracked live in Vortex IQ Nerve Centre

*Active SQL Warehouses* is one of hundreds of KPI pulses Vortex IQ tracks across Databricks and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English.

[Start for free](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.