Skip to main content

​
Ingest Tags from dbt

Ingest the table-level tags and column-level tags from manifest.json file Follow the link here to add the tags to your dbt project.

​
Requirements

For dbt tags, if the tag is not already present it will be created under tag category DBTTags in OpenMetadata

​
1. Table-Level Tags information in manifest.json file

Openmetadata fetches the table-level tags information from the manifest.json file. Below is a sample manifest.json file node containing tags information under node_name->tags. 
{
  "model.jaffle_shop.customers": {
    "raw_sql": "sample_raw_sql",
    "compiled": true,
    "resource_type": "model",
    "depends_on": {},
    "database": "dev",
    "schema": "dbt_jaffle",
    "tags": [
      "model_tag_one",
      "model_tag_two"
    ]
  }
}

​
2. Column-Level Tags information in manifest.json file

Openmetadata fetches the column-level tags information from the manifest.json file. Below is a sample manifest.json file node containing tags information under node_name->columns->column_name->tags. 
    "model.jaffle_shop.customers": {
      "database": "dev",
      "schema": "dbt_jaffle",
      "unique_id": "model.jaffle_shop.customers",
      "name": "customers",
      "alias": "customers",
      "columns": {
        "first_order": {
          "name": "first_order",
          "description": "Date (UTC) of a customer's first order",
          "meta": {},
          "data_type": null,
          "quote": null,
          "tags": [
            "tags_column_one"
          ]
        },
      },
    },

​
3. Viewing the tags on tables and columns

Table and Column level tags ingested from dbt can be viewed on the node in OpenMetadata dbt_tags