Hello Everyone,

We are currently working on a cost analysis initiative to gain deeper insights into our Databricks usage. As part of this effort, we are trying to calculate the hourly cost of each Databricks compute instance by utilizing the Azure Retail Prices API and storing this data in a table for further analysis.

During this process, we encountered a challenge in accurately calculating the cost per compute type. After consulting with Azure Support, we understood that the total cost displayed on Azure Databricks Pricing Page is composed of two components: the VM (infrastructure) cost and the DBU (Databricks Unit) cost.

While we are able to determine the VM cost using the Azure API, we are unable to map the correct number of DBUs per compute type to complete the total cost calculation. We have not found a reliable way to determine the DBU count associated with each VM/compute type.

My questions to the community:

• Is there a documented way to retrieve the DBU count per VM or compute type?

• Is this information available through any Databricks APIs or system-level tables that we can query?

• Has anyone built a similar cost model and can share tips or best practices?

Any guidance or pointers would be really appreciated!

Thanks in advance,

Charan.