How to get the Usage/DBU Consumption report without using system tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2024 11:25 PM
Is there a way to get the usage/DBU consumption report without using system tables?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 01:29 AM
To @Cloud_Architect ,
The Databricks Account Console offers a "Usage" page that provides an overview of your DBU consumption across workspaces. You can access it by navigating to Account Settings -> Usage. This page allows you to view usage data in DBU or estimated cost (USD), filter by workspace and timeframe, and see breakdowns by SKU group (e.g., standard, premium).
MaximTimeClock
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 05:21 AM
Let me try that, and thanks for your reply.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2024 09:10 AM
I tried but was not able to see anything.
Attached screenshot.
Can you please help if I am missing anything?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-20-2024 02:21 AM
You can get DBU consumption reports using the Azure Portal (for Azure SQL), through Metrics under your database's "Usage" section, or via Dynamic Management Views (DMVs) like sys.dm_db_resource_stats in SSMS. Third-party tools like SQL Sentry also offer usage insights without querying system tables directly.

