> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Ingest Owner from dbt

> Configure dbt workflows to ingest owner metadata from dbt models into your governance platform.

# 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](https://docs.getdbt.com/reference/resource-configs/meta).

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

  ```json theme={null}
  "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`:

  ```json theme={null}
  "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

1. Click the **Profile** icon and navigate to **Settings** > **Team & User Management** > **Users**.

   <img src="https://mintcdn.com/collatedocs/iES0mLmZlv3DDI8N/public/images/ai-2.0/connectors/dbt/access-users-setting.png?fit=max&auto=format&n=iES0mLmZlv3DDI8N&q=85&s=11e50d399f8e23ff869bc9b0d4132f1f" alt="Navigate to Users" width="2966" height="1576" data-path="public/images/ai-2.0/connectors/dbt/access-users-setting.png" />

   <img src="https://mintcdn.com/collatedocs/VsJxWKWlvReeFtlo/public/images/ai-2.0/connectors/dbt/users-page.png?fit=max&auto=format&n=VsJxWKWlvReeFtlo&q=85&s=9b693864e78a4b092ca270887673757c" alt="Users Selection Page" width="2414" height="1006" data-path="public/images/ai-2.0/connectors/dbt/users-page.png" />

2. Click **Add User**.

   <img src="https://mintcdn.com/collatedocs/iES0mLmZlv3DDI8N/public/images/ai-2.0/connectors/dbt/add-users.png?fit=max&auto=format&n=iES0mLmZlv3DDI8N&q=85&s=f48eca464d75f501d9fe39259390102b" alt="Add User button" width="2420" height="538" data-path="public/images/ai-2.0/connectors/dbt/add-users.png" />

3. Fill the user details and click **Create**.

   <Tip>
     **Tip**: If the owner value in `manifest.json` or `catalog.json` is `openmetadata`, enter `openmetadata@youremail.com` in the email field.
   </Tip>

   <img src="https://mintcdn.com/collatedocs/VsJxWKWlvReeFtlo/public/images/ai-2.0/connectors/dbt/user%20details.png?fit=max&auto=format&n=VsJxWKWlvReeFtlo&q=85&s=d178f6cbdd69dd63e40bd284e0ca905e" alt="Add user form" width="1632" height="1566" data-path="public/images/ai-2.0/connectors/dbt/user details.png" />

#### Add a Team in Collate

1. Click the **Profile** icon and navigate to **Settings** > **Team & User Management** > **Teams**.

   <img src="https://mintcdn.com/collatedocs/iES0mLmZlv3DDI8N/public/images/ai-2.0/connectors/dbt/access-users-setting.png?fit=max&auto=format&n=iES0mLmZlv3DDI8N&q=85&s=11e50d399f8e23ff869bc9b0d4132f1f" alt="Navigate to Teams" width="2966" height="1576" data-path="public/images/ai-2.0/connectors/dbt/access-users-setting.png" />

   <img src="https://mintcdn.com/collatedocs/VsJxWKWlvReeFtlo/public/images/ai-2.0/connectors/dbt/users-page.png?fit=max&auto=format&n=VsJxWKWlvReeFtlo&q=85&s=9b693864e78a4b092ca270887673757c" alt="Teams Selection Page" width="2414" height="1006" data-path="public/images/ai-2.0/connectors/dbt/users-page.png" />

2. Click **Add Team**.

   <img src="https://mintcdn.com/collatedocs/iES0mLmZlv3DDI8N/public/images/ai-2.0/connectors/dbt/add-team.png?fit=max&auto=format&n=iES0mLmZlv3DDI8N&q=85&s=b3121ad969bc9d57d8d87deee4ddc616" alt="Add Team button" width="2388" height="1288" data-path="public/images/ai-2.0/connectors/dbt/add-team.png" />

3. Fill the team details and click **Save**.

   <Tip>
     **Tip**: If the owner value in `manifest.json` or `catalog.json` is `openmetadata`, enter `openmetadata` in the name field.
   </Tip>

   <img src="https://mintcdn.com/collatedocs/VsJxWKWlvReeFtlo/public/images/ai-2.0/connectors/dbt/team-details.png?fit=max&auto=format&n=VsJxWKWlvReeFtlo&q=85&s=2e2f4638bd19c52ca4dd5ab764cef36c" alt="Add team form" width="1492" height="1710" data-path="public/images/ai-2.0/connectors/dbt/team-details.png" />

## Multiple Owners

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

```yaml theme={null}
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](#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.

<img src="https://mintcdn.com/collatedocs/VsJxWKWlvReeFtlo/public/images/ai-2.0/connectors/dbt/update-owners.png?fit=max&auto=format&n=VsJxWKWlvReeFtlo&q=85&s=55d99447a085585de44a4e8e1f09795e" alt="Update Owners toggle" width="1568" height="930" data-path="public/images/ai-2.0/connectors/dbt/update-owners.png" />

## Verify

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

<img src="https://mintcdn.com/collatedocs/X_lfH8k8w6u5uqTN/public/images/features/ingestion/workflows/dbt/ingest_dbt_owner/linked-user.png?fit=max&auto=format&n=X_lfH8k8w6u5uqTN&q=85&s=b636c2f4b09aba9d4dd63bb572784e19" alt="Owner linked to table" width="1972" height="816" data-path="public/images/features/ingestion/workflows/dbt/ingest_dbt_owner/linked-user.png" />
