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

Doga BAHAR 20 Reputation points
2023-11-07T08:57:14.4766667+00:00

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.

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,031 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dillon Silzer 54,931 Reputation points
    2023-11-07T16:06:58.9333333+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful