Skip to main content

GOLD namespace

The GOLD namespace for the Lakehouse provides a simplified, curated layer for human users and AI tools. It contains pre-joined tables that make it easier to navigate and analyze data in the Lakehouse.

The GOLD namespace is built natively into the Lakehouse catalog. Tables are kept in sync with the underlying metadata in real time -- no setup, refresh schedules, or customer-managed compute required.

Design​

The GOLD namespace follows a star schema design. The ASSETS table is the central hub that contains every asset in the catalog along with common attributes like name, type, status, owners, and certification. The surrounding detail tables (RELATIONAL_ASSET_DETAILS, GLOSSARY_DETAILS, BI_ASSET_DETAILS, etc.) contain domain-specific columns for particular asset categories.

All detail tables share guid as their primary key, so joins to ASSETS are always a simple assets.guid = [detail_table].guid. Start every query from ASSETS, filter to the assets you need, then join to the relevant detail table for specialized columns.

Structure​

The GOLD namespace consists of the following tables:

Tags, custom metadata, readmes, and lineage

Tags, custom metadata, readmes, and lineage data are available in the raw entity_metadata namespace. Query the TagRelationship, CustomMetadata, Readme, and process tables (for example, Process, ColumnProcess) directly for these use cases.

Entity relationship diagram​