dbt Metadata Sync

​

Model-level

• description is synchronized into the description field of the table into Lineage.
• The owner of the table is set to the user identified by the user@company.com field. This user must exist in Datafold with that email.
• The foo meta-information is added to the description field with the value bar.
• The tags pii and bar are applied to the table as tags.

models:
  - name: users
    description: "Description of the table"
    meta:
      owner: user@company.com
      foo: bar
    tags:
      - pii
      - abc

​

Column-level

• The column user_id has two tags applied: pk and id.
• The metadata for user_id is ignored because it reflects the primary key tag.
• The email column has the description applied.
• The email column has the tag pii applied.
• The email column has extra metadata information in the description field: type with the value email.

models:
  - name: users
    ...
    columns:
      - name: user_id
        tags:
          - pk
          - id
        meta:
          pk: true
      - name: email
        description: "The user's email"
        tags:
          - pii
        meta:
          type: email