Databricks

Unity Catalog Commands

Manage data governance with Unity Catalog. Create catalogs, schemas, and control access to data assets across your Databricks workspace with fine-grained permissions.

5 commands

Pro Tips

Use three-level namespace (catalog.schema.table) for clear data organization and access control.

Grant permissions at the catalog or schema level to simplify access management.

Use external locations for managing data in cloud storage with centralized governance.

Common Mistakes

Unity Catalog permissions are additive. Users inherit permissions from all groups they belong to.

Metastore assignment is workspace-scoped. Changing metastore affects all users in the workspace.

Commands

List catalogs

$ databricks unity-catalog catalogs list

List all catalogs in the metastore.

List schemas

$ databricks unity-catalog schemas list --catalog-name <catalog>

List schemas in a catalog.

List tables

$ databricks unity-catalog tables list --catalog-name <cat> --schema-name <schema>

List tables in a schema.

Get table info

$ databricks unity-catalog tables get --full-name <catalog.schema.table>

Get detailed information about a table.

Grant permissions

$ databricks unity-catalog permissions update --securable-type TABLE --securable-full-name <name> --json-file grants.json

Grant permissions on a securable object.