Hi @nara_shikamaru
Azure Databricks is a native service similar to Synapse in Azure unlike others. Databricks generally never sees the final aligned price and hence its unavailable in system tables.
You can follow below
- Azure Daily Export - You can export costs directly from Azure Portal -> Cost Management -> Exports to an ADLS Gen2 bucket and run SDP pipelines to store in required format. You can use this table along with billing table to get the required info. You can use it to get accurate info.
- Fixed Multipliers - You can use a flat rate discount percentage if you have the info and use it directly in the sql cost query. You can discount multiplier is 0.7 for a 30% discount like below.
(usage_quantity * pricing.effective_list.default) * 0.70 discounted_cost
More details here