delta table access

arkiboys 9,006 Reputation points
2023-09-05T06:41:34.11+00:00

hello,

How is it possible to give to group1 access to table1, table2 and give group 2 access to table3 and table4?
Thank you

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

Accepted answer
  1. BhargavaGunnam-MSFT 19,316 Reputation points Microsoft Employee
    2023-09-05T20:19:59.9933333+00:00

    Hello arkiboys,

    Please follow the below steps to give access to groups on the delta tables.

    • Create Databricks groups that you want to give access. You can create groups from the admin settings
    • Assign the users to each group. Edit the group and add members.
    • Create delta tables
    • Grant appropriate group access using the below syntax:
    GRANT SELECT ON table1 TO group1;
    GRANT SELECT ON table2 TO group1;
    
    GRANT SELECT ON table3 TO group2;
    GRANT SELECT ON table4 TO group2;
    

    Please note:
    As a pre-requisite, you need to enable table access control on the cluster.

    SQL only table access control:
    To enable SQL-only table access control on a cluster and restrict that cluster to use only SQL commands, set the following flag in the cluster’s Spark conf:

    spark.databricks.acl.sqlOnly true
    

    Reference documents:

    How to enable table access control for your workspace:
    https://learn.microsoft.com/en-us/azure/databricks/data-governance/table-acls/table-acl#--enable-table-access-control-for-your-workspace

    https://learn.microsoft.com/en-us/azure/databricks/data-governance/table-acls/table-acl#--sql-only-table-access-control
    https://learn.microsoft.com/en-us/azure/databricks/administration-guide/users-groups/users

    User's image

    User's image

    User's image

    I hope this helps.

    If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.


0 additional answers

Sort by: Most helpful