Linking Workspace IDs to Names in Billing Schema
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2024 09:41 AM
Hi everyone,
We recently enabled UC and the Billing system table to monitor our usage and costs. We've successfully set up a dashboard to track these metrics for each workspace. The usage table includes the workspace_id, but I'm having trouble finding a way to map these IDs to their corresponding workspace names. compassmobiletree
Since the System Tables feature is still in preview and not all tables are available yet, I'm curious if there's any plan to include workspace names in the "usage" table in the near future. If not, what would be the best approach to create a table that links workspace_id with workspace_name, considering I don't have access to the Databricks account level?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2025 12:08 PM
I got this from their older version of the dashboard.
When everything is executed, go to your graph in the dashboard, click three dots in the top right, select in my case "View dataset:usage_overview" then paste/modify sql code as below. This will hardcode the workspace name into your dashboard.
