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;
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:
How to enable table access control for your workspace:
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.