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.
