thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Three-Level Namespace

Addressing tables as catalog.schema.table in Unity Catalog, or database.schema.object in Snowflake.

Definition

The top level (catalog in Databricks, database in Snowflake) usually separates environments or business units, such as dev and prod catalogs.

Example

SELECT * FROM prod.finance.invoices;

Exam tip

Unity Catalog adds the catalog level above the Hive metastore's two-level schema.table.

Related terms