dbt Core Metadata Extracted

List of all the metadata that Secoda pulls from dbt Core

What does Secoda extract from dbt Core?

dbt is a secondary integration that adds additional metadata on to your data warehouse or relational database tables. Before connecting dbt make sure to connect a data warehouse or relational database first. These include Snowflake, BigQuery, Postgres, Redshift, etc.

  • Models:

    • Description

    • URL

    • Compiled SQL

  • Columns:

    • Description

    • Tags

    • Updated Time

  • Tests:

    • Name

    • Description

    • URL

    • Tags

    • Status

    • Error

    • Compiled code

  • Metrics (Referred to as Dictionary terms in Secoda) on dbt v1.5 or less:

    • Name

    • Type

    • Dimensions

    • Time Grains

  • Lineage:

    • dbt Jobs <-> external Tables

    • dbt Exposures <-> external Tables

  • Groups (Groups are referred to as USER_GROUPS in Secoda)

  • Contracts (dbt Contracts are referred to as TEST in Secoda)

  • Exposures (dbt Exposures are referred to as DASHBOARD in Secoda)

    1. The exposures can be a dashboard, notebook, analysis, ml, or application, but we currently only support dashboards.

  • Semantic layer metrics (Referred to as Dictionary terms in Secoda) on dbt v1.6+:

    • Name

    • Type (Simple, Ration, Derived)

Last updated