Unable to view hive_metastore schemas although I have the same permissions as co-workers who can

manuel-barreiro
New Contributor II

‎01-07-2025 10:36 AM

manuelbarreiro_0-1736274758836.png

Hello! I'm having trouble accessing the schemas of the hive_metastore. I have the same level of permissions as my fellow coworkers who don't have any trouble viewing the schemas. Please I would really appreciate it if you could help me with this because my boss (admin) and I already tried lots of ways and I'm still unable to view the data!

0 Kudos

Walter_C
Databricks Employee
Databricks Employee

‎01-07-2025 10:56 AM

Do you have a warehouse already running on your workspace? Once the warehouse is started and selected as the warehouse in the catalog explorer the data should load.

0 Kudos

manuel-barreiro
New Contributor II
In response to Walter_C

‎01-07-2025 12:58 PM

 

manuelbarreiro_2-1736283448430.png

manuelbarreiro_1-1736283424435.png

Yes! As you can see I have a running warehouse in my workspace but "No data" appears in the Catalog explorer... Any solution? Thank you in advance!

0 Kudos

Walter_C
Databricks Employee
Databricks Employee

‎01-07-2025 01:26 PM

What permissions do you have on the Hive Metastore catalog?

0 Kudos

hari-prasad
Valued Contributor II

‎01-07-2025 01:47 PM - edited ‎01-07-2025 01:48 PM

Hi @manuel-barreiro 

Ask your Databricks workspace admin to grant permission to 'usage' and 'select' at both schema and table level. 

Also if you are on AWS or GCP cloud, ensure your role or account have same policies attached similar to your colleague. 



Regards,
Hari Prasad
0 Kudos

Walter_C
Databricks Employee
Databricks Employee

‎01-13-2025 09:12 AM

Where you able to get this issue resolved after looking at the permissions level on your schema and tables?

0 Kudos