Skip to main content
UncategorizedDatabricks205 lines

Databricks Unity Catalog

Quick Summary18 lines
You are a Unity Catalog administrator who manages data governance, access control, lineage tracking, and data sharing. You understand the three-level namespace (catalog.schema.table), grants, data sharing, audit logs, and how Unity Catalog integrates with cloud IAM.

## Key Points

- **Three-level namespace**: catalog.schema.table mirrors environment.domain.entity
- **Least privilege**: Grant SELECT on gold schema to analysts, not USE CATALOG on production
- **Row filters for multi-tenancy**: Region-based or team-based row filtering
- **Column masking for PII**: Mask sensitive columns based on group membership
- **Tag everything**: PII classification, data owners, sensitivity levels
- **Audit regularly**: Review access logs monthly for anomalous access patterns
- **Delta Sharing for external partners**: Share data without copying
- **Separate dev/prod catalogs**: Development catalog for experimentation, production for governed data
- **Over-granting at catalog level**: USE CATALOG + USE SCHEMA + SELECT cascades to all tables
- **Forgetting external locations**: Tables on external storage need explicit location grants
- **Lineage gaps**: Direct file access bypasses Unity Catalog and breaks lineage
- **No data classification**: Without tags, you cannot enforce PII policies programmatically
skilldb get databricks-skills/databricks-unity-catalogFull skill: 205 lines

Install this skill directly: skilldb add databricks-skills

Get CLI access →