Thursday, March 13, 2025

Unity Catalog Securables

Unity Catalog securables are objects defined in the Unity Catalog metastore on which privileges can be granted to a principal (user, service principal, or group). These securable objects are hierarchical and include:

Metastore: The top-level container for metadata.

Catalog: The first layer of the object hierarchy, used to organize data assets.

Schema: Also known as databases, schemas contain tables and views.

Table: The lowest level in the object hierarchy, tables can be external or managed.

View: A read-only object created from a query on one or more tables.

Materialized View: An object created from a query on one or more tables, reflecting the state of data when last refreshed.

Volume: Can be external or managed, used for storing data.

Function: A user-defined function or an MLflow registered model.

Model: An MLflow registered model, listed separately from other functions in Catalog Explorer.

These securable objects allow for granular control over data access and management within the Unity Catalog

No comments:

Post a Comment

Data synchronization in Lakehouse

Data synchronization in Lakebase ensures that transactional data and analytical data remain up-to-date across the lakehouse and Postgres d...