Databricks doesn’t expose a “DBU/hour per node type” lookup in system tables, but you can derive it empirically by dividing total DBUs recorded in the billable usage system table by total node runtime from the compute node timeline for each instance type. This gives you the effective DBU/hour per node type for your environment and SKU.
WITH node_minutes AS (
SELECT
node_type,
COUNT(*) AS minutes -- node_timeline is per-minute records
FROM system.compute.node_timeline
GROUP BY node_type
),
dbu_by_node AS (
SELECT
u.usage_metadata.node_type AS node_type,
u.sku_name,
SUM(u.usage_quantity) AS dbus
FROM system.billing.usage AS u
WHERE u.usage_unit = 'DBU'
AND u.usage_metadata.node_type IS NOT NULL
GROUP BY ALL
)
SELECT
d.node_type,
d.sku_name,
d.dbus,
m.minutes,
d.dbus / (m.minutes / 60.0) AS dbu_per_node_hour
FROM dbu_by_node d
JOIN node_minutes m USING (node_type)
ORDER BY dbu_per_node_hour DESC;
