topic Re: How to get the Usage/DBU Consumption report without using system tables in Get Started Discussions

How to get the Usage/DBU Consumption report without using system tables

Cloud_Architect — Tue, 28 May 2024 06:25:08 GMT

Is there a way to get the usage/DBU consumption report without using system tables?

Re: How to get the Usage/DBU Consumption report without using system tables

jeannette9728mi — Tue, 28 May 2024 08:29:17 GMT

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).

Re: How to get the Usage/DBU Consumption report without using system tables

Cloud_Architect — Tue, 28 May 2024 12:21:23 GMT

Let me try that, and thanks for your reply.

Re: How to get the Usage/DBU Consumption report without using system tables

Cloud_Architect — Tue, 28 May 2024 16:10:26 GMT

I tried but was not able to see anything.

Attached screenshot.

Can you please help if I am missing anything?

Re: How to get the Usage/DBU Consumption report without using system tables

TracyJackson — Fri, 20 Dec 2024 10:21:23 GMT

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.