I am facing an issue while generating the DBU consumption report and need help.

[Cloud_Architect]

I am trying to access the following system tables to generate a DBU consumption report, but I am not seeing this table in the system schema. Could you please help me how to access it?

system.billing.inventory, system.billing.workspaces, system.billing.job_usage, system.billing.workflow_usage, system.billing.notebook_usage, system.billing.sql_usage, system.billing.dlt_usage, system.billing.dashboard_usage

[Kaniz_Fatma]

Hi @Cloud_Architect, In Azure Databricks, system tables are an analytical store of your account’s operational data found ...¹. These tables can be used for historical observability across your account¹.

To access system tables, your workspace must be enabled for Unity Catalog¹. By default, no users have access to system tables. To grant access, a metastore admin or other privileged user must grant USE and SELECT permissions on...¹.

Here is the list of system tables currently hosted by Azure Databricks¹:

• Audit logs: system.access.audit
• Table lineage: system.access.table_lineage
• Column lineage: system.access.column_lineage
• Billable usage: system.billing.usage
• Pricing: system.billing.list_prices
• Clusters: system.compute.clusters
• Node types: system.compute.node_types
• SQL warehouse events: system.compute.warehouse_events
• Marketplace funnel events: system.marketplace.listing_funnel_events
• Marketplace listing access: system.marketplace.listing_access_events
• Predictive optimization: system.storage.predictive_optimization_operations_history

Please note that the tables you mentioned like system.billing.inventory, system.billing.workspaces, system.billing.job_usage, etc. are not listed as available system tables¹. You may want to check the system.billing.usage table for billable usage records².

Remember, system tables are read-only and cannot be modified¹. Hope this helps! 😊

[Cloud_Architect]

Thanks for the quick response. @Kaniz_Fatma 

[Cloud_Architect]

If these system tables I have mentioned above are not available, then why is Databricks Assistant suggesting these tables? @Kaniz_Fatma 

[Cloud_Architect]

If these system tables are not available, then why is Databricks Assistant suggesting these tables? @Kaniz_Fatma 

[Kaniz_Fatma]

Hi @Cloud_Architect, Could you share some relevant screenshots?