Creating and managing catalogs, schemas, volumes, and tables using Unity Catalog
Unity Catalog introduces a hierarchy of data objects that organize your data assets:
- Metastore: A metadata storage that has a three-level structure (
catalog.schema.table
orcatalog.schema.volume
) to arrange your data. - Catalog: An object that groups your data assets in the first level of the structure. A catalog can include schemas, tables, and volumes. A catalog can also specify a storage location that is used by default for its schemas, tables, and volumes.
- Schema: The second layer of the object hierarchy, used to group related tables and volumes. A schema can also have a managed storage location that serves as the default location for its tables and volumes.
- Table: The next layer of the object hierarchy is used to access tabular data stored in cloud object storage. A table can be either managed or external. A managed table is backed by a managed storage location and is automatically...