delta table access

arkiboys 9,006 Reputation points


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

    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:

    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