Costs from cost managem azure portal are not allligned with costs calculated from usage system table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2025 09:02 AM
Hello,
the costs regarding the databricks service from cost management in azure portal (45,869...) are not allligned with costs calculated from usage system table (75,34).
The costs from the portal are filtered based on the desired period (usage_date >='2025-04-11') and the resource group where the workspace resides:
Azure Databricks Azure Databricks Premium All-purpose Compute DBU 45,8694226916667
this is the query i am using which gives 75,34:
%sql
SELECT u.workspace_id
,u.sku_name
,p.pricing.default
,u.usage_date
,usage_start_time
,usage_end_time
,usage_quantity
,((unix_timestamp(usage_end_time) - unix_timestamp(usage_start_time))/3600) * usage_quantity*p.pricing.default as costs
,usage_quantity*p.pricing.default as costs2
FROM system.billing.usage u
left join system.billing.list_prices p on u.sku_name=p.sku_name
WHERE
u.workspace_id='xxxxxxxxxxxxx'
and p.price_end_time is null
and u.usage_date >='2025-04-11'
and p.sku_name='PREMIUM_ALL_PURPOSE_COMPUTE'
