cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

manuel-barreiro
Visitor

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!

4 REPLIES 4

Walter_C
Databricks Employee
Databricks Employee

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.

 

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!

Walter_C
Databricks Employee
Databricks Employee

What permissions do you have on the Hive Metastore catalog?

hari-prasad
Contributor II

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group