Ingest Domain from dbt

Ingest the table-level domain from manifest.json file to assign tables to organizational domains in OpenMetadata.

A Domain is a bounded context that is aligned with a Business Unit or a function within an organization. Using domains helps organize data assets and improves discoverability.

Requirements

Steps for ingesting dbt Domain

1. Create or Select a Domain in OpenMetadata

Before ingesting domains from dbt, you need to create the domain in OpenMetadata or use an existing one.

For details on creating domains, refer to the OpenMetadata Domains documentation.

OpenMetadata supports three domain types:

• Source-aligned: Domains closer to online services and transactional databases
• Aggregate: Domains that collect and curate data from multiple source-aligned domains
• Consumer-aligned: User-facing domains designed for business users

2. Add Table-Level Domain information in schema.yml file

To assign a domain to a table in your dbt model, add the domain name under model->name->meta->openmetadata->domain in your schema.yml file.

For more details on dbt meta field follow the link here.

After adding the domain information to your schema.yml file, run your dbt workflow. The generated manifest.json file will then reflect the domain assignment. You'll find it under node_name->config->meta->openmetadata->domain.

3. Viewing the Domain on tables

Table level Domain ingested from dbt can be viewed on the table details page in OpenMetadata. The domain will appear in the table header section.

Validation and Error Handling