connectors

No menu items for this category

Ingest Owner from dbt

Ingest the model/table owner information from dbt manifest.json or catalog.json file into openmetadata tables.

The owner can be a user or a team in OpenMetadata.

Follow the link here to add the owner to the dbt project's schema.yml file

Openmetadata fetches the owner information from the manifest.json file. Below is a sample manifest.json file node containing owner information under node_name->metadata->owner.

Openmetadata fetches the owner information from the catalog.json file. Below is a sample catalog.json file node containing owner information under node_name->metadata->owner.

The user or team which will be set as the entity owner should be first created in OpenMetadata.

While linking the owner from manifest.json or catalog.json files to the entity, OpenMetadata first searches for the user if it is present. If the user is not present it searches for the team

1. Click on the Users section from homepage

click-users-page

Click Users page

click-users-page

Click Users page

2. Click on the Add User button

click-add-user

Click Add User

  1. Enter the details as shown for the user
add-user-dbt

Add User

1. Click on the Teams section from homepage

click-teams-page

Click Teams page

click-teams-page

Click Teams page

2. Click on the Add Team button

click-add-team

Click Add Team

3. Enter the details as shown for the team

add-team-dbt

Add Team

After running the ingestion workflow with dbt you can see the created user or team getting linked to the table as it's owner as it was specified in the manifest.json or catalog.json file.

linked-user

Linked User