NOT NULL
constraints).catalog.schema.table
).Feature | Hive Metastore | Unity Catalog |
---|---|---|
Scope | Workspace-local | Multi-workspace, multi-cloud |
Access Control | Basic (POSIX-like) | Fine-grained (RBAC) |
Lineage | Limited | Built-in |
sales_catalog
).sales_catalog.europe
).sales_catalog.europe.orders
).sales_catalog.utils.discount
).Setting | Value |
---|---|
Cluster Mode | No Isolation Shared |
Unity Catalog | Enabled |
Access Mode | Assigned to service principal |
sales.transactions
vs. hr.transactions
).SELECT
, MODIFY
, CREATE
, USAGE
, ALL PRIVILEGES
.marketing_catalog
finance_catalog
Topic | Key Takeaway |
---|---|
Four Governance Areas | Discovery, Quality, Security, Lineage. |
Unity Catalog Securables | Catalogs, schemas, tables, functions. |
Service Principals | Non-human identities for automation. |
Three-Layer Namespace | catalog.schema.table for unified queries. |
Best Practices | Colocate metastores, use service principals, segregate catalogs by team. |