dbt Workflow

dbt Integration

OpenMetadata integrates below metadata from dbt

1. dbt Queries

Queries used to create the dbt models can be viewed in the dbt tab

dbt Query

2. dbt Lineage

Lineage from dbt models can be viewed in the Lineage tab.

For more information on how lineage is extracted from dbt take a look here

dbt Lineage

3. dbt Tags

Table and column level tags can be imported from dbt

Please refer here for adding dbt tags

dbt Tags

4. dbt Owner

Owner from dbt models can be imported and assigned to respective tables

Please refer here for adding dbt owner

dbt Owner

5. dbt Descriptions

Descriptions from dbt models can be imported and assigned to respective tables and columns.

By default descriptions from manifest.json will be imported. Descriptions from catalog.json will only be updated if catalog file is passed.

dbt Descriptions

6. dbt Tests and Test Results

Tests from dbt will only be imported if the run_results.json file is passed.

dbt Tests

Troubleshooting

For any issues please refer to the troubleshooting documentation here