> For the complete documentation index, see [llms.txt](https://docs.euno.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.euno.ai/sources/transformation-etl/dbt-core/dbt-integration-discovered-resources.md).

# dbt Integration Discovered Resources

## Overview

The dbt integration discovers dbt transformation and semantic layer resources from dbt artifacts, and the warehouse resources that dbt builds. The dbt Core, dbt Cloud, and dbt Source Project integrations process dbt artifacts the same way and discover the same resources:

* dbt project (`dbt_project`)
* dbt Transformation Layer:
  * dbt model (`dbt_model`)
  * dbt source (`dbt_source`)
  * dbt seed (`dbt_seed`)
  * dbt exposure (`dbt_exposure`)
  * dbt column (`dbt_column`) — documented columns on dbt models, sources, and seeds (distinct from warehouse `column`)
* dbt Semantic Layer:
  * dbt semantic model (`dbt_semantic_model`)
  * dbt metric (`dbt_metric`)
  * dbt dimension (`dbt_dimension`)
  * dbt entity (`dbt_entity`)
  * dbt measure (`dbt_measure`)
* Warehouse resources (databases, schemas, tables, and columns linked from dbt builds):
  * Database (`database`)
  * Schema (`database_schema`)
  * Table (`table`)
  * Column (`column`)

`<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.

{% hint style="info" %}
dbt snapshots are discovered as `dbt_model` resources with `dbt_materialization_strategy` set to `snapshot`. Search for them with `type = 'dbt_model' AND dbt_materialization_strategy = 'snapshot'`.
{% endhint %}

## Resource hierarchy

```
dbt project
├── dbt model
│   └── dbt column
├── dbt source
│   └── dbt column
├── dbt seed
│   └── dbt column
├── dbt exposure
├── dbt semantic model
│   ├── dbt dimension
│   ├── dbt entity
│   └── dbt measure
└── dbt metric

Database
└── Schema
    └── Table
        └── Column
```

## dbt Project (`dbt_project`)

The top-level container for a dbt project.

| Property      | Type   | Description                                             |
| ------------- | ------ | ------------------------------------------------------- |
| `name`        | string | dbt project name                                        |
| `type`        | string | Always `dbt_project`                                    |
| `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. dbt snapshots are also discovered as `dbt_model`.

| Property                                   | Type      | Description                                                                                                      |
| ------------------------------------------ | --------- | ---------------------------------------------------------------------------------------------------------------- |
| `name`                                     | string    | Model name                                                                                                       |
| `type`                                     | string    | Always `dbt_model`                                                                                               |
| `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 (derived)                                                                                       |
| `is_external_package`                      | boolean   | Whether the model comes from an installed package (derived)                                                      |
| `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 (derived from `source_path`)                                                      |
| `database`                                 | string    | Target database (derived)                                                                                        |
| `schema`                                   | string    | Target schema (derived)                                                                                          |
| `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`, or `snapshot` for snapshots) (derived) |
| `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                                                                              |
| `native_last_data_update`                  | timestamp | Completion time 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                                                                  |

**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`

A snapshot uses the same pattern, for 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.

| Property                     | Type    | Description                                                      |
| ---------------------------- | ------- | ---------------------------------------------------------------- |
| `name`                       | string  | Source table name                                                |
| `type`                       | string  | Always `dbt_source`                                              |
| `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 (derived)                                       |
| `is_external_package`        | boolean | Whether the source comes from an installed package (derived)     |
| `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 (derived from `source_path`)      |
| `database`                   | string  | Database of the declared source (derived)                        |
| `schema`                     | string  | Schema of the declared source (derived)                          |
| `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)        |

**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.

| Property                                   | Type    | Description                                                 |
| ------------------------------------------ | ------- | ----------------------------------------------------------- |
| `name`                                     | string  | Seed name                                                   |
| `type`                                     | string  | Always `dbt_seed`                                           |
| `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 (derived)                                  |
| `is_external_package`                      | boolean | Whether the seed comes from an installed package (derived)  |
| `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 (derived from `source_path`) |
| `database`                                 | string  | Target database (derived)                                   |
| `schema`                                   | string  | Target schema (derived)                                     |
| `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             |

**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).

| Property                | Type   | Description                                                              |
| ----------------------- | ------ | ------------------------------------------------------------------------ |
| `name`                  | string | Exposure label, or the exposure name when no label is set                |
| `type`                  | string | Always `dbt_exposure`                                                    |
| `subtype`               | string | Exposure type from dbt (for example `dashboard`, `notebook`)             |
| `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                                                            |
| `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 (derived from `source_path`)              |
| `git_repo_url`          | string | Source repository URL when configured on the Euno source                 |
| `git_repo_branch`       | string | Source repository branch when configured                                 |
| `owner`                 | string | Owner derived from the dbt exposure owner when an email is set (derived) |
| `dbt_exposure_maturity` | string | Maturity from the exposure definition when set (`low`, `medium`, `high`) |

**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`, or `dbt_seed`.

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**.

| Property                     | Type    | Description                                                                     |
| ---------------------------- | ------- | ------------------------------------------------------------------------------- |
| `name`                       | string  | Column name from the dbt schema YAML / catalog                                  |
| `type`                       | string  | Always `dbt_column`                                                             |
| `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)                       |

**URI pattern**

```
<parent_dbt_resource_uri>.column.<column_name>
```

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

{% hint style="info" %}
Not every `dbt_column` **defines** a warehouse `column`. For example, ephemeral models or resources without dbt catalog entries may have no matching warehouse column.
{% endhint %}

## dbt Semantic Model (`dbt_semantic_model`)

A MetricFlow semantic model that owns entities, dimensions, and measures and supplies metric definitions.

| Property              | Type    | Description                                                          |
| --------------------- | ------- | -------------------------------------------------------------------- |
| `name`                | string  | Semantic model name                                                  |
| `type`                | string  | Always `dbt_semantic_model`                                          |
| `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 (derived)                                           |
| `is_external_package` | boolean | Whether the semantic model comes from an installed package (derived) |
| `subnodes`            | list    | Entities, dimensions, and measures owned by this semantic model      |
| `git_repo_url`        | string  | Configured project repository URL; unset for installed packages      |
| `git_repo_branch`     | string  | Configured project repository branch; unset for installed packages   |

**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.

Semantic children remain discoverable even when their underlying model has no catalog entry. Discover counts for dimensions, measures, and entities belong to the semantic model; transformation models retain their column counts.

## dbt Metric (`dbt_metric`)

A MetricFlow metric defined over semantic models.

| Property           | Type    | Description                                                                          |
| ------------------ | ------- | ------------------------------------------------------------------------------------ |
| `name`             | string  | Metric name                                                                          |
| `type`             | string  | Always `dbt_metric`                                                                  |
| `label`            | string  | Display label when set                                                               |
| `description`      | string  | Description from dbt, when provided                                                  |
| `dbt_project`      | string  | Project that contains this metric                                                    |
| `metric_type`      | string  | MetricFlow metric type (`conversion`, `cumulative`, `derived`, `ratio`, or `simple`) |
| `aggregation`      | string  | Aggregation of the underlying measure, for `simple` metrics                          |
| `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 (derived 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.

| Property         | Type    | Description                                                                                             |
| ---------------- | ------- | ------------------------------------------------------------------------------------------------------- |
| `name`           | string  | Dimension name                                                                                          |
| `type`           | string  | Always `dbt_dimension`                                                                                  |
| `description`    | string  | Description from dbt, when provided                                                                     |
| `dbt_project`    | string  | Project that contains this dimension                                                                    |
| `dimension_type` | string  | Dimension type from MetricFlow (`categorical` or `time`)                                                |
| `is_field`       | boolean | `true` for field-level resources                                                                        |
| `raw_code`       | string  | YAML definition, or unset when the dimension name matches an underlying model column (case insensitive) |

**URI pattern**

```
<semantic_model_uri>.dimension.<dimension_name>
```

Example: `dbt.jaffle_shop.semantic_model.jaffle_shop.customers.dimension.customer_name`

## dbt Entity (`dbt_entity`)

An entity defined on a MetricFlow semantic model, such as a primary or foreign entity used for joins.

| Property      | Type    | Description                                          |
| ------------- | ------- | ---------------------------------------------------- |
| `name`        | string  | Entity name                                          |
| `type`        | string  | Always `dbt_entity`                                  |
| `description` | string  | Description from dbt, when provided                  |
| `dbt_project` | string  | Project that contains this entity                    |
| `is_field`    | boolean | `true` for field-level resources                     |
| `raw_code`    | string  | YAML definition including entity type and expression |

**URI pattern**

```
<semantic_model_uri>.entity.<entity_name>
```

Example: `dbt.jaffle_shop.semantic_model.jaffle_shop.customers.entity.customer`

## dbt Measure (`dbt_measure`)

A measure on a MetricFlow semantic model.

| Property           | Type    | Description                         |
| ------------------ | ------- | ----------------------------------- |
| `name`             | string  | Measure name                        |
| `type`             | string  | Always `dbt_measure`                |
| `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**

```
<semantic_model_uri>.measure.<measure_name>
```

Example: `dbt.jaffle_shop.semantic_model.jaffle_shop.customers.measure.lifetime_spend`

## Warehouse observed resources

The dbt integration also observes the warehouse resources that dbt models, sources, and seeds resolve to. These use the same URIs as the warehouse integration, so they merge with the resources that the warehouse integration discovers.

## Database (`database`)

A warehouse database linked from dbt build targets.

| Property              | Type   | Description                     |
| --------------------- | ------ | ------------------------------- |
| `name`                | string | Database name                   |
| `type`                | string | Always `database`               |
| `subtype`             | string | Always `database`               |
| `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.

| Property              | Type   | Description                     |
| --------------------- | ------ | ------------------------------- |
| `name`                | string | Schema name                     |
| `type`                | string | Always `database_schema`        |
| `subtype`             | string | Always `database_schema`        |
| `database`            | string | Parent database name (derived)  |
| `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).

| Property                     | Type    | Description                                                                |
| ---------------------------- | ------- | -------------------------------------------------------------------------- |
| `name`                       | string  | Table name (uses dbt alias or identifier when set)                         |
| `type`                       | string  | Always `table`                                                             |
| `description`                | string  | Description when provided (including from dbt)                             |
| `database`                   | string  | Database name (derived)                                                    |
| `schema`                     | string  | Schema name (derived)                                                      |
| `sql_dialect`                | string  | SQL dialect from the dbt build adapter                                     |
| `database_technology`        | string  | Warehouse technology when known                                            |
| `defined_by`                 | string  | `dbt` for tables that dbt resources define                                 |
| `dbt_last_run_pass`          | boolean | Whether related dbt tests passed in the last observed build (when present) |
| `dbt_last_run_failing_tests` | list    | Failing related dbt tests from 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.

| Property                     | Type    | Description                                                    |
| ---------------------------- | ------- | -------------------------------------------------------------- |
| `name`                       | string  | Column name                                                    |
| `type`                       | string  | Always `column`                                                |
| `subtype`                    | string  | Always `column`                                                |
| `native_data_type`           | string  | Native warehouse data type when available                      |
| `defined_by`                 | string  | `dbt` for columns that dbt columns define                      |
| `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

Each row is one relationship edge, written in the canonical direction for its family. Use the predicate in each heading to search for these relationships in EQL.

### Containment (`has parent` / `has child`)

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

### Lineage (`has upstream` / `has downstream`)

| Source type          | Relationship | Target type          | Notes                                                     |
| -------------------- | ------------ | -------------------- | --------------------------------------------------------- |
| `dbt_model`          | has upstream | `dbt_model`          | From dbt `depends_on` (includes snapshots)                |
| `dbt_model`          | has upstream | `dbt_source`         | From dbt `depends_on`                                     |
| `dbt_model`          | has upstream | `dbt_seed`           | From dbt `depends_on`                                     |
| `dbt_model`          | has upstream | `dbt_metric`         | When metrics are referenced in `euno.ai/saved_query` meta |
| `dbt_exposure`       | has upstream | `dbt_model`          | From exposure `depends_on`                                |
| `dbt_exposure`       | has upstream | `dbt_source`         | From exposure `depends_on`                                |
| `dbt_exposure`       | has upstream | `dbt_seed`           | From exposure `depends_on`                                |
| `dbt_exposure`       | has upstream | `dbt_metric`         | From exposure `depends_on`                                |
| `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_metric`         | has upstream | `dbt_semantic_model` | Semantic models the metric is built on                    |
| `dbt_metric`         | has upstream | `dbt_model`          | dbt models behind those semantic models                   |
| `dbt_metric`         | has upstream | `dbt_metric`         | Derived and ratio metrics                                 |
| `table`              | has upstream | `table`              | From dbt dependencies and compiled dbt SQL                |

### Field-level lineage (`has upstream_fields` / `has downstream_fields`)

| Source type  | Relationship         | Target type   | Notes                                                                                                                                  |
| ------------ | -------------------- | ------------- | -------------------------------------------------------------------------------------------------------------------------------------- |
| `dbt_metric` | has upstream\_fields | `dbt_measure` | The measure a `simple` or `cumulative` metric aggregates, under the owning semantic model URI                                          |
| `column`     | has upstream\_fields | `column`      | Column lineage from compiled SQL                                                                                                       |
| `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 |

### Definition (`defines` / `has definer`)

Looker fields tagged with `euno.ai/based_on_column/<dbt_column_uri>` or `euno.ai/based_on_metric/<dbt_metric_uri>` can be traced back to the corresponding dbt resource through these relationships. Euno derives each Looker `defines` relationship only when that target already exists with the matching dbt type and active authoritative sponsorship. The relationship does not make Looker a co-sponsor or lifecycle owner of the dbt resource; a tag alone does not create a dbt resource.

| Source type  | Relationship | Target type        | Notes                                                                              |
| ------------ | ------------ | ------------------ | ---------------------------------------------------------------------------------- |
| `dbt_model`  | defines      | `table`            | Warehouse table the model (or snapshot) materializes; not set for ephemeral models |
| `dbt_source` | defines      | `table`            | Warehouse table the source declares                                                |
| `dbt_seed`   | defines      | `table`            | Warehouse table the seed loads                                                     |
| `dbt_model`  | defines      | `looker_view`      | LookML views that Euno generated from this dbt model                               |
| `dbt_model`  | defines      | `looker_explore`   | LookML explores that Euno generated from this dbt model                            |
| `dbt_column` | defines      | `column`           | When a matching warehouse column is present                                        |
| `dbt_column` | defines      | `looker_dimension` | Canonical column tag points to this authoritative dbt column                       |
| `dbt_column` | defines      | `looker_measure`   | Canonical column tag points to this authoritative dbt column                       |
| `dbt_metric` | defines      | `looker_dimension` | Canonical metric tag points to this authoritative dbt metric                       |
| `dbt_metric` | defines      | `looker_measure`   | Canonical metric tag points to this authoritative dbt metric                       |

## Usage in EQL

```
# dbt columns that define a warehouse column
type = 'dbt_column' AND has defined(type = 'column')

# dbt columns on dbt models
type = 'dbt_column' AND has parent(type = 'dbt_model')

# dbt snapshots
type = 'dbt_model' AND dbt_materialization_strategy = 'snapshot'

# Warehouse tables defined by a dbt model
type = 'table' AND has definer(type = 'dbt_model')
```

{% hint style="info" %}
Use EQL relationship predicates such as `has upstream`, `has upstream_fields`, `has defined`, and `has definer`.
{% endhint %}

## Known limitations

* Ephemeral models do not define a warehouse `table`, and their `dbt_column` resources do not define warehouse columns.
* Builds that run in dbt Cloud CI schemas (`dbt_cloud_pr_*`) do not create warehouse tables or `defines` relationships from dbt models, sources, and seeds to tables.
* dbt models materialized as `semantic_view` are not discovered.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.euno.ai/sources/transformation-etl/dbt-core/dbt-integration-discovered-resources.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.