dbt Integration Discovered Resources

Overview

The dbt integration discovers the following resources:

• dbt project

• dbt Transformation Layer:

  • dbt sources, seeds, models, exposures and snapshots

  • databases, schemas, tables and columns

• dbt Semantic Layer:

  • dbt metrics

  • dbt measures

  • dbt dimensions

  • dbt semantic models

• warehouse resources

  • columns

  • tables

  • schemas

  • databases

dbt resources properties observed

property	Value	Applicable to
name	The property stores the name of the dbt resource. In case there is an alias, Euno uses the alias for the "name" property	All dbt resources
description	This property stores description of the resource.	All dbt resources
first_observed	This property stores when Euno first observed the resource.	All dbt resources
last_observed	This property stores when Euno last observed the resource.	All dbt resources
type	dbt_source, dbt_seed, dbt_model, dbt_metric, dbt_exposure, dbt_snapshot, dbt_dimension, dbt_measure, dbt_semantic_model, dbt_project	All dbt resources
is_external_package	The property stores whether the resource is from an external dbt package.	dbt sources, dbt seeds, dbt models, dbt semantic models
package_name	The property stores the name of the package the resource belongs to.	dbt sources, dbt seeds, dbt models, dbt semantic models
dbt_materialization_strategy	The property stores how the model will be materialization data warehouse.	dbt models
source_path	Stores the relative path in the source code that defines this resource	All dbt resources
source_directory	Stores the relative directory in the source code that defines this resource	All dbt resources
dbt_project	The dbt project the resource is found within.	All dbt resources
tags	The property stores the tags of the resource.	dbt sources, dbt seeds, dbt models, dbt exposures, dbt snapshots, dbt metrics
meta	The property stores the meta of the resource.	dbt sources, dbt seeds, dbt models, dbt exposures, dbt snapshots, dbt metrics
database	The property stores the database the resource is located in.	dbt sources, dbt seeds, dbt models
schema	The property stores the schema the resource is located in.	dbt sources, dbt seeds, dbt models
unique_id	The dbt unique_id of the resource	dbt sources, dbt seeds, dbt models, dbt semantic models, dbt metrics
defines	A list of resources within the database that the dbt resource defines (e.g., tables in the database).	dbt sources, dbt seeds, dbt models
total_builds_14d	The total number of times the dbt model was built in the last 14 days.	dbt models, dbt seeds, dbt snapshots
total_builds_30d	The total number of times the dbt model was built in the last 30 days.	dbt models, dbt seeds, dbt snapshots
total_builds_60d	The total number of times the dbt model was built in the last 60 days.	dbt models, dbt seeds, dbt snapshots
average_build_time_14d	Average duration of a single build over the last 14 days.	dbt models, dbt_seeds, dbt snapshots
average_build_time_30d	Average duration of a single build over the last 30 days.	dbt models, dbt_seeds, dbt snapshots
average_build_time_60d	Average duration of a single build over the last 60 days.	dbt models, dbt_seeds, dbt snapshots

data warehouse resources properties observed

Property	Value	Applicable to
name	Table name. In the case of using alias or identifier, use those as the table name	database, schema, table, column
description	Columns inherit the description from dbt, if one is provided in the dbt model/source yaml	column
sql_dialect	Based on the adapter used for the dbt build	table, column

Relationships

Lineage (upstream/downstream)

We observe lineage between dbt models, snapshots and exposures and other dbt resources like seed, models, sources, based on dbt's native dependency identification.

We observe lineage between tables based on the compiled dbt SQL code

We observe column level lineage between table columns based on the compiled dbt SQL code generating each table

We observe lineage between dbt metrics and other dbt metrics, and column level lineage (upstream_fields) dbt semantic models, measures and dimensions.

We observe lineage between dbt semantic models and their underlying dbt models.

Parent / Child

All dbt models, snapshots, exposures, sources, seeds, metrics and semantic models are child of the dbt project resource.

Columns are observed twice: once as children of the dbt resource and once as children of the table containing them.

All dbt dimensions and measures are children of the dbt model on which they are defined.

Defines

dbt models, snapshots, sources and seed have a defines relationship with the data warehouse tables they refer to.

Columns that are children of dbt models and sources are considered definers of the columns under the warehouse table.