Table ACL & Row and Column Level Security With Unity Catalog

Unity Catalog is a unified governance solution for all data and AI assets including files, tables, machine learning models and dashboards in your lakehouse on any cloud.

In this demo, we’ll show how Unity Catalog can be used to secure your table and grant ACL on tables. We’ll also see how Unity Catalog can provide dynamic data masking on columns leveraging SQL functions, and filter rows based on the current user.

This will allow you to hide or anonymize data based on each user’s permissions, from a simple condition based on GROUP to more advanced control.

To install the demo, get a free Databricks workspace and execute the following two commands in a Python notebook

%pip install dbdemos

import dbdemos
dbdemos.install('uc-01-acl')

Dbdemos is a Python library that installs complete Databricks demos in your workspaces. Dbdemos will load and start notebooks, Delta Live Tables pipelines, clusters, Databricks SQL dashboards, warehouse models … See how to use dbdemos

Dbdemos is distributed as a GitHub project.

For more details, please view the GitHub README.md file and follow the documentation.
Dbdemos is provided as is. See the License and Notice for more information.
Databricks does not offer official support for dbdemos and the associated assets.
For any issue, please open a ticket and the demo team will have a look on a best-effort basis.