What does Atlan crawl from dbt Core?

Atlan crawls and maps the following assets and properties from dbt Core. Atlan also supports lineage between the following:

• dbt models
• dbt seeds
• dbt sources
• dbt semantic models, measures, dimensions, and entities
• dbt metrics
• SQL tables and views materialized by dbt models, dbt seeds, dbt sources
• Column-level lineage for dbt models, dbt seeds, dbt sources and their materialized counterparts
• Semantic layer lineage (model → semantic model → metric)

Once you've crawled dbt, you can use dbt-specific filters for quick asset discovery:

• Test status - filter dbt tests that passed, failed, or have a warning or error
• Alias - filter by the name of a dbt model's identifier in the dbt project
• Unique id - filter by the unique node identifier of a dbt model
• Project name - filter by dbt project name, only supported for dbt Core version 1.6+
• Job name - filter by dbt job name
• Environment name - filter by dbt environment name
• Job status - filter by dbt job status
• Last job run - filter by the last run of the dbt job

Atlan's dbt crawler also populates custom metadata to further enrich the assets in Atlan. The Atlan dbt-specific property column in the tables below gives the name of the mapped custom metadata property in Atlan.

Did you know?

Atlan enables you to sync your dbt tags and update your dbt assets with the synced tags. You can also map other metadata to Atlan's assets through your dbt models.

Tables and views

Atlan maps materialized tables and views from dbt Core to its Table/View asset type.

Source property	Atlan property	Where in Atlan
description	description	asset profile and overview sidebar
alias	assetDbtAlias	asset filter and properties sidebar
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	asset filter and overview sidebar
packageName	assetDbtPackageName	asset filter and properties sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only
[collected via dbt files]	assetDbtTestStatus	API and dbt test sidebar

Columns

Atlan maps materialized columns from dbt Core to its Column asset type.

Source property	Atlan property	Where in Atlan
description	description	asset profile and overview sidebar
alias	assetDbtAlias	asset filter and properties sidebar
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	asset filter and overview sidebar
packageName	assetDbtPackageName	properties sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only
[collected via dbt files]	assetDbtTestStatus	dbt test sidebar

Models

Atlan maps models from dbt Core to its DbtModel asset type.

Source property	Atlan property	Where in Atlan
name	name	asset profile and overview sidebar
description	description	asset profile and overview sidebar
owner	sourceCreatedBy	asset profile and properties sidebar
alias	assetDbtAlias	asset filter and properties sidebar
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	asset filter and overview sidebar
packageName	assetDbtPackageName	properties sidebar
raw_sql or raw_code	dbtRawSQL	overview sidebar
compiled_sql or compiled_code	dbtCompiledSQL	overview sidebar
status	dbtJobRuns.dbtModelRunStatus	overview sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only
config.materialized	dbtMaterializationType	API only
executeCompletedAt	sourceUpdatedAt	asset profile and properties sidebar
stats	dbtStats	API only
[dynamically generated using accountId, projectId, and uniqueId]	sourceURL	overview sidebar

Sources

Atlan maps sources from dbt Core to its DbtSource asset type.

Source property	Atlan property	Where in Atlan
name	name	asset profile and overview sidebar
description	description	asset profile and overview sidebar
owner	sourceCreatedBy	asset profile and properties sidebar
alias	assetDbtAlias	asset filter and properties sidebar
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	Asset filter and overview sidebar
packageName	assetDbtPackageName	properties sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only
stats	dbtStats	API only
freshness	assetDbtSourceFreshnessCriteria	Overview sidebar
criteria	assetDbtSourceFreshnessCriteria	overview sidebar
[dynamically generated using accountId, projectId, and uniqueId]	sourceURL	Overview sidebar

Tests

warning

For dbt Core, upload the run_results.json file to crawl dbt tests. It's recommended to place the file in the same folder as the manifest.json file.

Atlan maps tests from dbt Core to its DbtTest asset type.

Source property	Atlan property	Where in Atlan
name	name	asset profile and overview sidebar
description	description	asset profile and overview sidebar
alias	assetDbtAlias	asset filter and properties sidebar
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	asset filter, overview and properties sidebar
packageName	assetDbtPackageName	properties sidebar
raw_code	dbtTestRawCode	overview sidebar
raw_sql	dbtTestRawSQL	overview sidebar
compiled_code	dbtTestCompiledCode	overview sidebar
compiled_sql	dbtTestCompiledSQL	overview sidebar
status	dbtTestStatus	overview sidebar
error	dbtTestError	asset profile and overview sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only
[dynamically generated using accountId, projectId, and uniqueId]	sourceURL	overview sidebar

Seeds

Atlan maps seeds from dbt Core to its DbtSeed asset type.

Source property	Atlan property	Where in Atlan
name	name	asset profile and overview sidebar
description	description	asset profile and overview sidebar
executeCompletedAt	sourceUpdatedAt	asset profile and properties sidebar
owner	sourceCreatedBy	asset profile and properties sidebar
status	dbtJobRuns.dbtModelRunStatus	overview sidebar
alias	assetDbtAlias	asset filter and properties sidebar
meta	assetDbtMeta	API only
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
stats	dbtSeedStats	API only
filePath	dbtSeedfilePath	asset profile and overview sidebar

Semantic models

Atlan maps semantic models from dbt Core to its DbtSemanticModel asset type. Semantic models are containers for measures, entities, and dimensions that define the structure of your metrics layer.

Source property	Atlan property	Where in Atlan
name	name	asset profile and overview sidebar
description	description	asset profile and overview sidebar
unique_id	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	asset filter and overview sidebar
packageName	assetDbtPackageName	properties sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only

Measures, dimensions, and entities

Atlan maps measures, dimensions, and entities from dbt Core to their respective asset types: DbtMeasure, DbtDimension, and DbtEntity.

Source property	Atlan property	Where in Atlan
name	name	asset profile and overview sidebar
description	description	asset profile and overview sidebar
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	asset filter and overview sidebar
packageName	assetDbtPackageName	properties sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only
expr	semanticExpression	overview sidebar
agg	semanticType	overview sidebar (measures only)
type	semanticType	overview sidebar (dimensions and entities only)

Metrics

Atlan maps metrics from dbt Core to its DbtMetric asset type. Metrics are calculated business metrics that can be simple aggregations, cumulative calculations, derived expressions, ratios, or conversion rates.

Source property	Atlan property	Where in Atlan
label	name	asset profile and overview sidebar
description	description	asset profile and overview sidebar
name	assetDbtAlias	asset filter and properties sidebar
uniqueId	assetDbtUniqueId	asset filter and overview sidebar
accountName	assetDbtAccountName	asset qualified name
projectName	assetDbtProjectName	asset filter and overview sidebar
packageName	assetDbtPackageName	properties sidebar
tags	assetDbtTags	asset filter and overview sidebar
meta	assetDbtMeta	API only
type	metricType	overview sidebar
formula	metricSQL	overview sidebar
filter	dbtMetricFilter	overview sidebar
window	dbtMetricWindow	overview sidebar
cumulative_type_params.period_agg	dbtMetricCumulativePeriodAgg	overview sidebar
conversion_type_params.calculation	dbtMetricConversionCalculation	overview sidebar

Metric lineage

Atlan creates DbtProcess assets to visualize how metrics are calculated from upstream dependencies. Atlan captures the following lineage relationships for dbt Semantic Layer assets:

Source	Target
Model	Semantic Model
Measure	Metric
Semantic Model	Metric
Metric	Metric

Source property	Atlan property	Where in Atlan
formula	sql	overview sidebar
[dynamically generated]	dbtUpstreamContexts	overview sidebar
[dynamically generated]	dbtUpstreamContexts[].dbtInputContextName	overview sidebar
[dynamically generated]	dbtUpstreamContexts[].dbtInputContextQualifiedName	overview sidebar
[dynamically generated]	dbtUpstreamContexts[].dbtInputContextType	overview sidebar
[dynamically generated]	dbtUpstreamContexts[].dbtInputContextAlias	overview sidebar
[dynamically generated]	dbtUpstreamContexts[].dbtInputContextFilter	overview sidebar
[dynamically generated]	dbtUpstreamContexts[].dbtInputContextOffsetWindow	overview sidebar
[dynamically generated]	dbtUpstreamContexts[].dbtInputContextOffsetToGrain	overview sidebar