topic Re: Warehouse Name in System Tables in Data Engineering

Warehouse Name in System Tables

valjas — Wed, 06 Mar 2024 07:39:41 GMT

Hello.

I am creating a table to monitor the usage of All-purpose Compute and SQL Warehouses. From the tables in 'system' catalog, I can get cluster_name and cluster_id. However only warehouse_id is available and not warehouse name. Is there a way to get the name of the warehouse in the system tables?

I thought of creating a table and having all the warehouse ids and names updated here. But, it would mean, this table has to be updated everytime a new warehouse is created.

Is there a place where databricks stores warehouse names along with ids? If not, please suggest a work around to automatially log all the warehouses that are created.

Re: Warehouse Name in System Tables

wallco26 — Fri, 20 Sep 2024 21:13:05 GMT

That's not an optimal solution. Why can't the name be recorded?

Re: Warehouse Name in System Tables

MoJaMa — Thu, 19 Dec 2024 15:42:40 GMT

Have you seen this one?

https://docs.databricks.com/en/admin/system-tables/warehouses.html

Re: Warehouse Name in System Tables

aranjan99 — Thu, 27 Mar 2025 16:51:09 GMT

I have enabled the compute system schema, but i dont see this tabke. What am i missing?