Skip to main content

Additional dashboards

You'll install the community system-tables demo so optional AI/BI dashboards run against your real billing data in ~15 min.

What you'll build​

Multiple dashboards plus notebooks: consumption tracking, DBU forecast, model-endpoint cost attribution, warehouse attribution, and UC/volume analysis. Intermediate tables land in a Unity Catalog catalog and schema you choose (not necessarily main).

Official source (Demo Center): System Tables: Billing Forecast, Usage Analytics, and Access Auditing with Unity Catalog

tip

Confirm the demo slug is still system-tables on PyPI or GitHub before you standardize this in enablement.

Steps​

1. Install the dashboard from dbdemos library.​

Run the following cells on a new Python notebook.

%pip install dbdemos
dbutils.library.restartPython()
import dbdemos

catalog = "mycatalog"
schema = "myschema"

dbdemos.install("uc-04-system-tables", catalog=catalog, schema=schema)

Set catalog and schema to your existing UC assets, example:

Wait until the notebook finishes and prints status for notebooks and dashboards.

dbdemos install notebook showing the system tables demo setup with catalog and schema configuration

dbdemos install output listing the installed Databricks AI/BI dashboards and Genie Space for system tables

Verify​

Open Dashboards and Genie Spaces sections to verify the new assets.

Dashboards list showing the installed dbdemos System Tables dashboards in a Databricks workspace

Genie Spaces page showing the installed Databricks System Table Genie Space

Troubleshoot​

ModuleNotFoundError: dbdemos

Run %pip install dbdemos, then dbutils.library.restartPython() before importing.

Permission denied writing catalog or schema

Pick a catalog and schema where your user may create tables, or ask a metastore admin to grant CREATE.

Permission denied on system tables

An admin must grant SELECT on system.billing (and system.access for audit-backed tiles).

Empty charts

New accounts need accumulated usage. Forecast tiles may stay thin until enough daily history exists.

Install hangs

Confirm the cluster has internet egress to PyPI and enough resources.

Next​