anshu_roy
Databricks Employee
Databricks Employee

Hello,

You can use Workspace System tables to get an overview of each workspace in your Databricks account for both Azure and AWS and combine them to build a global view.

These tables let you query key metadata such as workspace ID, name, URL, cloud, and lifecycle status from the system.access.workspaces_latest table.
You can then join this with other system tables like system.billing.usage or compute/system tables to enrich your overview with usage, cost, and compute details per workspace.
By running these queries in a central account-level warehouse, you can regularly export the results (for example,  to a dashboard) and use them as a single inventory of all workspaces across clouds.