dbt Integration Discovered Resources

Overview

The dbt integration discovers the following resources:

• dbt project

• dbt Transformation Layer:

  • dbt_source, dbt_seed, dbt_model, dbt_snapshot, dbt_exposure

  • dbt_column — documented columns on those dbt resources (distinct from warehouse column)

• dbt Semantic Layer:

  • dbt_metric

  • dbt_measure

  • dbt_dimension

  • dbt_semantic_model

• warehouse resources (tables, schemas, and databases linked from dbt builds)

  • column

  • table

  • database_schema

  • database

<warehouse_uri_prefix> below is the warehouse URI prefix from the source Build target (for example a Snowflake or Databricks host mapped to Euno’s warehouse prefix). dbt transformation and semantic resources use the dbt.<project> prefix unless Override URI prefix is set.

dbt Project (dbt_project)

The top-level container for a dbt project.

name	type	Description
type	string	Always dbt_project
name	string	dbt project name
dbt_version	string	dbt version from the build
sql_dialect	string	SQL dialect of the warehouse adapter used for the build

URI pattern

<warehouse_uri_prefix>.dbt_project.<dbt_project_name>

Example: snowflake.xy12345.us-east-1.aws.dbt_project.jaffle_shop

dbt Model (dbt_model)

A dbt model — SQL that is compiled and materialized in the warehouse.

name	type	Description
type	string	Always dbt_model
name	string	Model name (uses alias when set)
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this model
unique_id	string	dbt unique id
package_name	string	dbt package name
is_external_package	boolean	Whether the model comes from an installed package
tags	list	Tags from the model definition
meta	object	Meta from the model definition
source_path	string	Relative path of the defining file in the project
source_directory	string	Directory of the defining file (from source_path)
database	string	Target database
schema	string	Target schema
sql_dialect	string	SQL dialect of the warehouse adapter
dbt_version	string	dbt version from the build
dbt_materialization_strategy	string	Materialization (for example table, view, incremental, ephemeral)
dbt_model_access	string	Model access level when set (public, protected, private)
dbt_model_group	string	Model group when set
git_repo_url	string	Source repository URL when configured on the Euno source
git_repo_branch	string	Source repository branch when configured
dbt_last_run_pass	boolean	Whether tests passed in the last observed build (when tests ran)
dbt_last_run_failing_tests	list	Failing tests from the last observed build (when present)
last_dbt_build_runtime	number	Duration of the last observed build
total_builds_14d / _30d / _60d	number	Build counts over the lookback window
average_build_time_14d / _30d / _60d	number	Average build duration over the lookback window
defines	list (relationship)	Warehouse table this model defines

URI pattern

dbt.<dbt_project_name>.<dbt_unique_id>

<dbt_unique_id> is dbt’s unique id (for example model.jaffle_shop.customers).

Example: dbt.jaffle_shop.model.jaffle_shop.customers

If Override URI prefix is set on the source, the pattern is <override_uri_prefix>.<dbt_unique_id> instead.

dbt Snapshot (dbt_snapshot)

A dbt snapshot — slowly changing dimension history materialized in the warehouse.

name	type	Description
type	string	Always dbt_snapshot
name	string	Snapshot name (uses alias when set)
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this snapshot
unique_id	string	dbt unique id
package_name	string	dbt package name
is_external_package	boolean	Whether the snapshot comes from an installed package
tags	list	Tags from the snapshot definition
meta	object	Meta from the snapshot definition
source_path	string	Relative path of the defining file in the project
source_directory	string	Directory of the defining file (from source_path)
database	string	Target database
schema	string	Target schema
sql_dialect	string	SQL dialect of the warehouse adapter
dbt_version	string	dbt version from the build
dbt_materialization_strategy	string	Typically snapshot
git_repo_url	string	Source repository URL when configured on the Euno source
git_repo_branch	string	Source repository branch when configured
defines	list (relationship)	Warehouse table this snapshot defines

URI pattern

dbt.<dbt_project_name>.<dbt_unique_id>

Example: dbt.jaffle_shop.snapshot.jaffle_shop.orders_snapshot

If Override URI prefix is set on the source, the pattern is <override_uri_prefix>.<dbt_unique_id> instead.

dbt Source (dbt_source)

A dbt source — a declared upstream warehouse table that models can reference.

name	type	Description
type	string	Always dbt_source
name	string	Source table name (uses identifier when set)
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this source
unique_id	string	dbt unique id
package_name	string	dbt package name
is_external_package	boolean	Whether the source comes from an installed package
tags	list	Tags from the source definition
meta	object	Meta from the source definition
source_path	string	Relative path of the defining file in the project
source_directory	string	Directory of the defining file (from source_path)
database	string	Database of the declared source
schema	string	Schema of the declared source
sql_dialect	string	SQL dialect of the warehouse adapter
dbt_version	string	dbt version from the build
git_repo_url	string	Source repository URL when configured on the Euno source
git_repo_branch	string	Source repository branch when configured
dbt_last_run_pass	boolean	Whether tests passed in the last observed build (when tests ran)
dbt_last_run_failing_tests	list	Failing tests from the last observed build (when present)
defines	list (relationship)	Warehouse table this source defines

URI pattern

dbt.<dbt_project_name>.<dbt_unique_id>

Example: dbt.jaffle_shop.source.jaffle_shop.raw.orders

If Override URI prefix is set on the source, the pattern is <override_uri_prefix>.<dbt_unique_id> instead.

dbt Seed (dbt_seed)

A dbt seed — a CSV (or similar) file in the project loaded into the warehouse.

name	type	Description
type	string	Always dbt_seed
name	string	Seed name
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this seed
unique_id	string	dbt unique id
package_name	string	dbt package name
is_external_package	boolean	Whether the seed comes from an installed package
tags	list	Tags from the seed definition
meta	object	Meta from the seed definition
source_path	string	Relative path of the defining file in the project
source_directory	string	Directory of the defining file (from source_path)
database	string	Target database
schema	string	Target schema
sql_dialect	string	SQL dialect of the warehouse adapter
dbt_version	string	dbt version from the build
git_repo_url	string	Source repository URL when configured on the Euno source
git_repo_branch	string	Source repository branch when configured
total_builds_14d / _30d / _60d	number	Build counts over the lookback window
average_build_time_14d / _30d / _60d	number	Average build duration over the lookback window
defines	list (relationship)	Warehouse table this seed defines

URI pattern

dbt.<dbt_project_name>.<dbt_unique_id>

Example: dbt.jaffle_shop.seed.jaffle_shop.raw_customers

If Override URI prefix is set on the source, the pattern is <override_uri_prefix>.<dbt_unique_id> instead.

dbt Exposure (dbt_exposure)

A dbt exposure — a documented downstream consumer of dbt resources (for example a Tableau dashboard or report).

name	type	Description
type	string	Always dbt_exposure
name	string	Exposure name
label	string	Display label when set
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this exposure
unique_id	string	dbt unique id
subtype	string	Exposure type from dbt (for example dashboard, notebook)
tags	list	Tags from the exposure definition
meta	object	Meta from the exposure definition
source_path	string	Relative path of the defining file in the project
source_directory	string	Directory of the defining file (from source_path)
owner	string	Owner derived from dbt exposure owners when available
dbt_exposure_maturity	string	Maturity from the exposure definition when set

URI pattern

dbt.<dbt_project_name>.exposure.<package_name>.<exposure_name>

Example: dbt.jaffle_shop.exposure.jaffle_shop.weekly_revenue_dashboard

dbt Column (dbt_column)

A dbt_column is the dbt-side documentation of a column on a dbt_model, dbt_source, dbt_seed, or dbt_snapshot.

When the parent dbt resource maps to a warehouse table, Euno also observes a warehouse column on that table and links them with defines / has definer.

name	type	Description
type	string	Always dbt_column
name	string	Column name from the dbt schema YAML / catalog
description	string	Description from dbt, when provided
dbt_project	string	dbt project that contains the parent resource
tags	list	Tags from the dbt column definition
meta	object	Meta from the dbt column definition
is_field	boolean	true for field-level resources
dbt_last_run_pass	boolean	Whether tests on this column passed in the last observed build (when tests ran)
dbt_last_run_failing_tests	list	Failing tests from the last observed build (when present)
defines	list (relationship)	Warehouse column this dbt column defines, when a matching warehouse column is present

URI pattern

<parent_dbt_resource_uri>.column.<column_name>

Example: dbt.jaffle_shop.model.jaffle_shop.customers.column.customer_id

Not every dbt_column defines a warehouse column. For example, ephemeral models or resources without dbt catalog entries may have no matching warehouse column.

Example EQL:

type = 'dbt_column' AND has defined(type = 'column')

type = 'dbt_column' AND has parent(type = 'dbt_model')

dbt Semantic Model (dbt_semantic_model)

A Metricflow semantic model that groups related metrics, dimensions, and measures.

name	type	Description
type	string	Always dbt_semantic_model
name	string	Semantic model name
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this semantic model
unique_id	string	dbt unique id
package_name	string	dbt package name
is_external_package	boolean	Whether the semantic model comes from an installed package

URI pattern

dbt.<dbt_project_name>.<dbt_unique_id>

Example: dbt.jaffle_shop.semantic_model.jaffle_shop.customers

If Override URI prefix is set on the source, the pattern is <override_uri_prefix>.<dbt_unique_id> instead.

dbt Metric (dbt_metric)

A Metricflow metric defined over semantic models.

name	type	Description
type	string	Always dbt_metric
name	string	Metric name
label	string	Display label when set
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this metric
unique_id	string	dbt unique id
metric_type	string	Metricflow metric type
aggregation	string	Aggregation when applicable
has_filter	boolean	Whether the metric has filters
tags	list	Tags from the metric definition
meta	object	Meta from the metric definition
source_path	string	Relative path of the defining file in the project
source_directory	string	Directory of the defining file (from source_path)

URI pattern

metric.<package_name>.<metric_name>

Example: metric.jaffle_shop.total_revenue

dbt Dimension (dbt_dimension)

A dimension on a Metricflow semantic model (or related model).

name	type	Description
type	string	Always dbt_dimension
name	string	Dimension name
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this dimension
dimension_type	string	Dimension type from Metricflow
is_field	boolean	true for field-level resources

URI pattern

<parent_resource_uri>.dimension.<dimension_name>

Example: dbt.jaffle_shop.model.jaffle_shop.customers.dimension.customer_id

dbt Measure (dbt_measure)

A measure on a Metricflow semantic model (or related model).

name	type	Description
type	string	Always dbt_measure
name	string	Measure name
description	string	Description from dbt, when provided
dbt_project	string	Project that contains this measure
dbt_measure_type	string	Aggregation type for the measure
is_field	boolean	true for field-level resources

URI pattern

<parent_resource_uri>.measure.<measure_name>

Example: dbt.jaffle_shop.model.jaffle_shop.customers.measure.total_revenue

Warehouse observed resources

Database (database)

A warehouse database linked from dbt build targets.

name	type	Description
type	string	Always database
name	string	Database name
database_technology	string	Warehouse technology when known

URI pattern

<warehouse_uri_prefix>.<database_name>

Example: snowflake.xy12345.us-east-1.aws.analytics

Schema (database_schema)

A warehouse schema linked from dbt build targets.

name	type	Description
type	string	Always database_schema
name	string	Schema name
database	string	Parent database name
database_technology	string	Warehouse technology when known

URI pattern

<warehouse_uri_prefix>.<database_name>.<schema_name>

Example: snowflake.xy12345.us-east-1.aws.analytics.public

Table (table)

A warehouse table linked from dbt (materialized output or declared source).

name	type	Description
type	string	Always table
name	string	Table name (uses dbt alias or identifier when set)
description	string	Description when provided (including from dbt)
database	string	Database name
schema	string	Schema name
sql_dialect	string	SQL dialect from the dbt build adapter
database_technology	string	Warehouse technology when known
dbt_last_run_pass	boolean	Whether related dbt tests passed in the last observed build (when present)

URI pattern

<warehouse_uri_prefix>.<database_name>.<schema_name>.<table_name>

Example: snowflake.xy12345.us-east-1.aws.analytics.public.customers

Column (column)

A warehouse column on a table linked from dbt.

name	type	Description
type	string	Always column
name	string	Column name
native_data_type	string	Native warehouse data type when available
dbt_last_run_pass	boolean	Whether tests passed in the last observed build (when present)
dbt_last_run_failing_tests	list	Failing tests from the last observed build (when present)

URI pattern

<warehouse_uri_prefix>.<database_name>.<schema_name>.<table_name>.column.<column_name>

Example: snowflake.xy12345.us-east-1.aws.analytics.public.customers.column.customer_id

Relationships

For lineage, Source is the downstream resource and Target is an upstream dependency. Each row is one source type → one target type.

Hierarchical (has parent / has child)

Source type	Relationship	Target type	Notes
dbt_model	has parent	dbt_project
dbt_seed	has parent	dbt_project
dbt_source	has parent	dbt_project
dbt_snapshot	has parent	dbt_project
dbt_exposure	has parent	dbt_project
dbt_metric	has parent	dbt_project
dbt_semantic_model	has parent	dbt_project
dbt_column	has parent	dbt_model
dbt_column	has parent	dbt_source
dbt_column	has parent	dbt_seed
dbt_column	has parent	dbt_snapshot
dbt_dimension	has parent	dbt_model
dbt_dimension	has parent	dbt_semantic_model
dbt_measure	has parent	dbt_model
dbt_measure	has parent	dbt_semantic_model
column	has parent	table
table	has parent	database_schema
database_schema	has parent	database

Lineage (has upstream / has downstream)

Source type	Relationship	Target type	Notes
dbt_model	has upstream	dbt_model	From dbt depends_on
dbt_model	has upstream	dbt_seed	From dbt depends_on
dbt_model	has upstream	dbt_source	From dbt depends_on
dbt_model	has upstream	dbt_snapshot	From dbt depends_on
dbt_model	has upstream	dbt_metric	When metrics are referenced (for example via meta)
dbt_model	has upstream	table	Warehouse tables referenced by the model
dbt_snapshot	has upstream	dbt_model	From dbt depends_on
dbt_snapshot	has upstream	dbt_seed	From dbt depends_on
dbt_snapshot	has upstream	dbt_source	From dbt depends_on
dbt_snapshot	has upstream	dbt_snapshot	From dbt depends_on
dbt_snapshot	has upstream	table	Warehouse tables referenced by the snapshot
dbt_source	has upstream	table	Declared warehouse table
dbt_seed	has upstream	table	Loaded warehouse table
dbt_exposure	has upstream	dbt_model	From exposure dependencies
dbt_exposure	has upstream	dbt_source	From exposure dependencies
dbt_semantic_model	has upstream	dbt_model	From semantic model depends_on
dbt_semantic_model	has upstream	dbt_source	From semantic model depends_on
dbt_semantic_model	has upstream	dbt_seed	From semantic model depends_on
dbt_semantic_model	has upstream	dbt_snapshot	From semantic model depends_on
dbt_semantic_model	has upstream	table	When a dependency resolves to a warehouse table
dbt_metric	has upstream	dbt_semantic_model	Metricflow metric dependencies
dbt_metric	has upstream	dbt_model	Metricflow metric dependencies
dbt_metric	has upstream	dbt_metric	Derived / ratio metrics
dbt_metric	has upstream	dbt_measure	Metricflow metric dependencies
dbt_metric	has upstream	table	When a dependency resolves to a warehouse table
table	has upstream	table	From compiled dbt SQL

Field-level lineage (has upstream_fields / has downstream_fields)

Source type	Relationship	Target type	Notes
column	has upstream_fields	column	Column lineage from compiled SQL
dbt_column	has upstream_fields	column	Field lineage onto warehouse columns
dbt_metric	has upstream_fields	dbt_measure	Metric → measure field lineage
table	has upstream_fields	column	May include columns used only in query logic (JOIN, WHERE, GROUP BY, HAVING, QUALIFY, ORDER BY), not only selected columns

Defined-by (defines / has definer)

Source type	Relationship	Target type	Notes
dbt_model	defines	table	Warehouse table the model materializes
dbt_seed	defines	table	Warehouse table the seed loads
dbt_source	defines	table	Warehouse table the source declares
dbt_snapshot	defines	table	Warehouse table the snapshot materializes
dbt_column	defines	column	When a matching warehouse column is present
table	has definer	dbt_model	Inverse of dbt_model defines
table	has definer	dbt_seed	Inverse of dbt_seed defines
table	has definer	dbt_source	Inverse of dbt_source defines
table	has definer	dbt_snapshot	Inverse of dbt_snapshot defines
column	has definer	dbt_column	Inverse of dbt_column defines

Use EQL relationship predicates such as has upstream, has upstream_fields, has defined, and has definer.