Issue in getting system.compute.warehouses table in some workspaces

[Abishrp]

In some workspaces, I can get system.compute.warehouses table 

But in some other workspaces, it is not available how can i enable it?

Both are in same account but assigned to different metastore.

[Alberto_Umana]

Hi @Abishrp,

Please see this document who walks you through how to enable it: https://docs.databricks.com/en/admin/system-tables/warehouses.html

[Alberto_Umana]

Here are the APIs required for that as well as requirements:

https://docs.databricks.com/en/admin/system-tables/index.html#enable

Let me know if you have questions.

[aranjan99]

Seeing the same issue. Considering we can see other tables from compute system schema it is already enabled. How do we get the system.copmute.warehouses table?

[CashyMcSmashy]

Hello, did you ever manage to resolve this?

[aranjan99]

I disabled the compute schema and then enabled it again

[CashyMcSmashy]

Thanks for replying, I tried to disable it but I got an error stating it could only be completed by Databricks