How to get permissions of data content in hive in databricks catalog?

Question

Hello!

I have a cluster on Databricks and I created my tables with parquet files and I can see them on hive_metastore and with SQL commands I can select tables and see data inside. However in catalog permissions I have this error. I have all the admin roles in Databricks. How can I get this permission on the cluster?

summary: Error in SQL statement: SparkException: Trying to perform permission action on Hive Metastore /CATALOG/hive_metastore/DATABASE/database1but Table Access Control is not enabled on this cluster. , data: com.databricks.backend.common.rpc.SparkDriverExceptions$SQLExecutionException: org.apache.spark.SparkException: Trying to perform permission action on Hive Metastore /CATALOG/hive_metastore/DATABASE/database1 but Table Access Control is not enabled on this cluster.

Answer 1

Hi Doga,

Please see the following:

Enable table access control for a cluster

https://learn.microsoft.com/en-us/azure/databricks/data-governance/table-acls/table-acl#--enable-table-access-control-for-a-cluster

Then set permissions:

Manage privileges on objects in the Hive metastore

https://learn.microsoft.com/en-us/azure/databricks/data-governance/table-acls/object-privileges#manage-privileges-on-objects-in-the-hive-metastore

---

If this is helpful please accept answer.