Ingest Owner from dbt

Collate reads owner information from your dbt manifest.json or catalog.json artifacts and links it to the corresponding table entities in Collate. The owner can be a user or a team. When ingestion runs, Collate looks for the owner field under node_name → metadata → owner. It first searches for a matching user; if none is found, it falls back to a matching team.

Prerequisites

dbt Side

The owner field must be present in your dbt artifact files before ingestion runs. To add or update the owner in your dbt project, see the dbt meta configuration reference.

Owner in manifest.json — under node_name → metadata → owner:

"model.jaffle_shop.orders": {
    "metadata": {
        "type": "BASE TABLE",
        "schema": "dbt_jaffle",
        "name": "orders",
        "database": "dev",
        "comment": null,
        "owner": "openmetadata_team"
    }
}

Owner in catalog.json — same location under node_name → metadata → owner:

"model.jaffle_shop.customers": {
    "metadata": {
        "type": "BASE TABLE",
        "schema": "dbt_jaffle",
        "name": "customers",
        "database": "dev",
        "comment": null,
        "owner": "openmetadata"
    }
}

Collate Side

The user or team named in the dbt artifact must already exist in Collate before ingestion runs. Collate will not create owners automatically.

Add a User in Collate

Click the Profile icon and navigate to Settings > Team & User Management > Users.
Click Add User.
Fill the user details and click Create.
Tip: If the owner value in manifest.json or catalog.json is openmetadata, enter openmetadata@youremail.com in the email field.

Add a Team in Collate

Click the Profile icon and navigate to Settings > Team & User Management > Teams.
Click Add Team.
Fill the team details and click Save.
Tip: If the owner value in manifest.json or catalog.json is openmetadata, enter openmetadata in the name field.

Multiple Owners

Collate supports multiple owners per dbt model through the owner field under meta.openmetadata in your schema.yml:

models:
  - name: customers
    meta:
      openmetadata:
        glossary: [
          'Test_Glossary.term_one',
          'Test_Glossary.term_two.nested_term.more_nested_term',
        ]
        tier: 'Tier.Tier2'
        owner: ['John Doe', 'jane@gmail.com']
    config:
      tags: ["model_tag_one", "model_tag_two"]

owner: A list of user names or email addresses. Each must exist in Collate as a valid user or team entity.
dbtUpdateOwners: Controls whether this list overwrites existing owners or applies only to unowned assets. See Override Existing Owners below.

Override Existing Owners

When the Update Owners toggle is enabled in the dbt ingestion configuration, Collate overwrites any existing table owners with the values from dbt. When disabled, dbt owners are only applied to tables that currently have no owner in Collate — existing owners are left unchanged.

Verify

After the ingestion workflow completes, the linked owner appears on the table entity page.

Connectors

Connectors

Ingest Owner from dbt

Ingest Owner from dbt

Prerequisites

dbt Side

Collate Side

Add a User in Collate

Add a Team in Collate

Multiple Owners

Override Existing Owners

Verify

​Ingest Owner from dbt

​Prerequisites

​dbt Side

​Collate Side

​Add a User in Collate

​Add a Team in Collate

​Multiple Owners

​Override Existing Owners

​Verify

Ingest Owner from dbt

Prerequisites

dbt Side

Collate Side

Add a User in Collate

Add a Team in Collate

Multiple Owners

Override Existing Owners

Verify