How do I calculate my Databricks spend from system tables to compare against SELECT?

SELECT reports Databricks platform spend, priced using Databricks' own system.billing.usage and system.billing.list_prices system tables. You can run the query below directly against your own Databricks workspace to independently verify SELECT's numbers.

This only covers Databricks platform spend. It does not include underlying cloud infrastructure spend (e.g. Azure, AWS, or GCP compute/storage billed directly by the cloud provider), which is a separate cost outside of what SELECT currently reports.

Fill in your workspace_id and account_id in the params CTE, and any negotiated discounts in the discounts CTE, then run the query in a Databricks SQL editor connected to your workspace. The total should line up with SELECT's Cost Explorer for the same date range.

1with
2-- === fill in below ===
3params as (
4    select
5        '2026-06-01'::date as start_date,
6        '2026-06-30'::date as end_date,
7        '<your-workspace-id>' as workspace_id,
8        '<your-account-id>' as account_id
9),
10-- add negotiated discounts here; more specific rows win (sku over product over global)
11discounts (sku_name, billing_origin_product, discount_pct) as (
12    values
13        ('<sku-name>', null, 0.00)
14    -- (null, '<billing-origin-product>', 0.00)  -- product-level discount
15    -- (null, null, 0.00)  -- global discount
16),
17-- === end fill in ===