radothede
Valued Contributor II

Hi @jreh ,

You are right about calculating the single job execution using system.billing.usage and system.billing.list_prices.

The DBU consumption reported in shorter windows (e.g., 10 minutes) is already reflective of the time window, so You dont need to divide it by 6.

So in general, what You want to do is to sum the calculation for eac job run.

sum(usage_quantity * list_prices.pricing.default)

You can find more useful examples here:

https://docs.databricks.com/en/admin/system-tables/jobs-cost.html

Regarding system.billing.usage system table, You can find out more here:

https://docs.databricks.com/en/admin/system-tables/billing.html

A single row in the system.billing.usage table represents a snapshot of DBU usage for a specific job run within time window and for specific SKU.