Atlan crawls and maps the following assets and properties from dbt Cloud.
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
- 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
- Account name — filter by dbt account name
- Project name — filter by dbt project name
- Job name — filter by dbt job name
- Package name — filter by dbt package 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
- Last job run (created at) — filter by when a job run was created
- Last job run (updated at) — filter by when a job run was completed
- Last job run (dequeued at) — filter by when the dbt job scheduler dequeued a job from the wait queue and triggered a run
- Last job run (started at) — filter by when the latest job run started after the job scheduler triggered a run
Atlan's dbt connectivity 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 allows you to sync your dbt tags and update your dbt assets with the synced tags. It is also possible to map other metadata on Atlan's assets through your dbt models.
Tables
Atlan maps tables from dbt Cloud to its Table
asset type.
Source property | Atlan property | Where in Atlan |
---|---|---|
description |
description |
asset profile and overview sidebar |
alias |
alias |
asset filter and properties sidebar |
stats (row_count) |
rowCount |
asset profile and overview sidebar |
stats (bytes) |
sizeBytes |
overview sidebar |
stats (last_modified) |
sourceUpdateAt |
asset profile and properties sidebar |
Source property | Atlan dbt-specific property | Where in Atlan |
---|---|---|
account (name) |
assetDbtAccountName |
asset filter |
project (name) |
assetDbtProjectName |
asset filter, overview and properties sidebar |
job (name) |
assetDbtJobName |
asset filter and overview sidebar |
uniqueID |
assetDbtUniqueId |
asset filter and overview sidebar |
rawSQL |
dbtRawSQL |
overview sidebar |
tags |
assetDbtTag |
asset filter and overview sidebar |
packageName |
assetDbtPackageName |
asset filter and properties sidebar |
alias |
alias |
asset filter and properties sidebar |
description |
description |
asset profile and overview sidebar |
created at |
sourceCreatedAt |
asset profile, overview and properties sidebar |
compiledSql |
dbtCompiledSQL |
overview sidebar |
criteria |
assetDbtSourceFreshnessCriteria |
asset filter and overview sidebar |
Columns
Atlan maps columns from dbt Cloud to its Column
asset type.
Source property | Atlan property | Where in Atlan |
---|---|---|
description |
description |
asset profile and overview sidebar |
Source property | Atlan dbt-specific property | Where in Atlan |
---|---|---|
meta |
assetDbtMeta |
API only |
account (name) |
assetDbtAccountName |
asset filter |
project (name) |
assetDbtProjectName |
asset filter, overview and properties sidebar |
job (name) |
assetDbtJobName |
asset filter and overview sidebar |
tags |
assetDbtTag |
asset filter and overview sidebar |
packageName |
assetDbtPackageName |
asset filter and properties sidebar |
created at |
sourceCreatedAt |
asset profile, overview and properties sidebar |
Models
Atlan maps models from dbt Cloud to its Model
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 |
dynamically generated using accountId, jobId, and uniqueId | sourceURL |
overview sidebar |
Source property | Atlan dbt-specific property | Where in Atlan |
---|---|---|
alias |
assetDbtAlias |
asset filter and properties sidebar |
meta |
assetDbtMeta |
API only |
uniqueId |
assetDbtUniqueId |
asset filter and overview sidebar |
accountName |
assetDbtAccountName |
asset filter |
projectName |
assetDbtProjectName |
asset filter and overview sidebar |
packageName |
assetDbtPackageName |
asset filter and properties sidebar |
job.name |
assetDbtJobName |
asset filter and properties sidebar |
job.schedule |
assetDbtJobSchedule |
API only |
job.status |
assetDbtJobStatus |
asset profile and properties sidebar |
job.cron_humanized |
assetDbtJobScheduleCronHumanized |
API only |
job.last_run_finished_at |
assetDbtJobLastRun |
asset filter, overview and properties sidebar |
job.latest_run.href |
assetDbtJobLastRunUrl |
API only |
job.latest_run.created_at |
assetDbtJobLastRunCreatedAt |
asset filter |
job.latest_run.updated_at |
assetDbtJobLastRunUpdatedAt |
asset filter |
job.latest_run.dequeued_at |
assetDbtJobLastRunDequeuedAt |
asset filter |
job.latest_run.started_at |
assetDbtJobLastRunStartedAt |
asset filter |
job.latest_run.duration |
assetDbtJobLastRunTotalDuration |
API only |
job.latest_run.duration_humanized |
assetDbtJobLastRunTotalDurationHumanized |
API only |
job.latest_run.queued_duration |
assetDbtJobLastRunQueuedDuration |
API only |
job.latest_run.queued_duration_humanized |
assetDbtJobLastRunQueuedDurationHumanized |
API only |
job.latest_run.run_duration |
assetDbtJobLastRunRunDuration |
overview and properties sidebar |
job.latest_run.queued_duration_humanized |
assetDbtJobLastRunRunDurationHumanized |
overview and properties sidebar |
job.latest_run.git_branch |
assetDbtJobLastRunGitBranch |
API only |
job.latest_run.git_branch_sha |
assetDbtJobLastRunGitSha |
API only |
job.latest_run.status_message |
assetDbtJobLastRunStatusMessage |
API only |
job.latest_run.owner_thread_id |
assetDbtJobLastRunOwnerThreadId |
API only |
job.latest_run.executed_by_thread_id |
assetDbtJobLastRunExecutedByThreadId |
API only |
job.latest_run.artifacts_saved |
assetDbtJobLastRunArtifactsSaved |
API only |
job.latest_run.artifact_s3_path |
assetDbtJobLastRunArtifactS3Path |
API only |
job.latest_run.has_docs_generated |
assetDbtJobLastRunHasDocsGenerated |
API only |
job.latest_run.has_sources_generated |
assetDbtJobLastRunHasSourcesGenerated |
API only |
job.latest_run.notifications_sent |
assetDbtJobLastRunNotificationsSent |
API only |
job.next_run |
assetDbtJobNextRun |
API only |
job.next_run_humanized |
assetDbtJobNextRunHumanized |
API only |
environment.name |
assetDbtEnvironmentName |
asset filter, overview and properties sidebar |
environment.dbt_version |
assetDbtEnvironmentDbtVersion |
properties sidebar |
tags |
assetDbtTags |
asset filter and overview sidebar |
status |
dbtStatus |
asset filter and overview sidebar |
error |
dbtError |
API only |
rawSql |
dbtRawSQL |
overview sidebar |
compiledSql |
dbtCompiledSQL |
overview sidebar |
stats |
dbtStats |
API only |
materializedType |
dbtMaterializationType |
API only |
compileStartedAt |
dbtModelCompileStartedAt |
API only |
compileCompletedAt |
dbtModelCompileCompletedAt |
API only |
executeStartedAt |
dbtModelExecuteStartedAt |
API only |
executeCompletedAt |
dbtModelExecuteCompletedAt |
API only |
executionTime |
dbtModelExecutionTime |
API only |
runGeneratedAt |
dbtModelRunGeneratedAt |
API only |
runElapsedTime |
dbtModelRunElapsedTime |
API only |
Sources
Atlan maps sources from dbt Cloud 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 |
executeCompletedAt |
sourceUpdatedAt |
asset profile and properties sidebar |
owner |
sourceCreatedBy |
asset profile and properties sidebar |
dynamically generated using accountId, jobId, and uniqueId | sourceURL |
overview sidebar |
Source property | Atlan dbt-specific property | Where in Atlan |
---|---|---|
alias |
assetDbtAlias |
asset filter and properties sidebar |
meta |
assetDbtMeta |
API only |
uniqueId |
assetDbtUniqueId |
asset filter and overview sidebar |
accountName |
assetDbtAccountName |
asset filter |
projectName |
assetDbtProjectName |
asset filter and overview sidebar |
packageName |
assetDbtPackageName |
asset filter and properties sidebar |
job.name |
assetDbtJobName |
asset filter and properties sidebar |
job.schedule |
assetDbtJobSchedule |
API only |
job.status |
assetDbtJobStatus |
asset profile and properties sidebar |
job.cron_humanized |
assetDbtJobScheduleCronHumanized |
API only |
job.last_run_finished_at |
assetDbtJobLastRun |
asset filter, overview and properties sidebar |
job.latest_run.href |
assetDbtJobLastRunUrl |
API only |
job.latest_run.created_at |
assetDbtJobLastRunCreatedAt |
asset filter |
job.latest_run.updated_at |
assetDbtJobLastRunUpdatedAt |
asset filter |
job.latest_run.dequeued_at |
assetDbtJobLastRunDequeuedAt |
asset filter |
job.latest_run.started_at |
assetDbtJobLastRunStartedAt |
asset filter |
job.latest_run.duration |
assetDbtJobLastRunTotalDuration |
API only |
job.latest_run.duration_humanized |
assetDbtJobLastRunTotalDurationHumanized |
API only |
job.latest_run.queued_duration |
assetDbtJobLastRunQueuedDuration |
API only |
job.latest_run.queued_duration_humanized |
assetDbtJobLastRunQueuedDurationHumanized |
API only |
job.latest_run.run_duration |
assetDbtJobLastRunRunDuration |
overview and properties sidebar |
job.latest_run.queued_duration_humanized |
assetDbtJobLastRunRunDurationHumanized |
overview and properties sidebar |
job.latest_run.git_branch |
assetDbtJobLastRunGitBranch |
API only |
job.latest_run.git_branch_sha |
assetDbtJobLastRunGitSha |
API only |
job.latest_run.status_message |
assetDbtJobLastRunStatusMessage |
API only |
job.latest_run.owner_thread_id |
assetDbtJobLastRunOwnerThreadId |
API only |
job.latest_run.executed_by_thread_id |
assetDbtJobLastRunExecutedByThreadId |
API only |
job.latest_run.artifacts_saved |
assetDbtJobLastRunArtifactsSaved |
API only |
job.latest_run.artifact_s3_path |
assetDbtJobLastRunArtifactS3Path |
API only |
job.latest_run.has_docs_generated |
assetDbtJobLastRunHasDocsGenerated |
API only |
job.latest_run.has_sources_generated |
assetDbtJobLastRunHasSourcesGenerated |
API only |
job.latest_run.notifications_sent |
assetDbtJobLastRunNotificationsSent |
API only |
job.next_run |
assetDbtJobNextRun |
API only |
job.next_run_humanized |
assetDbtJobNextRunHumanized |
API only |
environment.name |
assetDbtEnvironmentName |
asset filter, overview and properties sidebar |
environment.dbt_version |
assetDbtEnvironmentDbtVersion |
properties sidebar |
tags |
assetDbtTags |
asset filter and overview sidebar |
criteria |
assetDbtSourceFreshnessCriteria |
overview sidebar |
stats |
dbtStats |
API only |
state |
dbtState |
API only |
Tests
Atlan maps tests from dbt Cloud to its Test
asset type.
Source property | Atlan property | Where in Atlan |
---|---|---|
name |
name |
asset profile and overview sidebar |
description |
description |
asset profile and overview sidebar |
dynamically generated using accountId, jobId, and uniqueId | sourceURL |
overview sidebar |
Source property | Atlan property | Where in Atlan |
---|---|---|
name
|
assetDbtAlias
|
asset filter and properties sidebar |
meta
|
assetDbtMeta
|
API only |
uniqueId
|
assetDbtUniqueId
|
asset filter and overview sidebar |
tags
|
assetDbtTags
|
asset filter and overview sidebar |
status
|
dbtTestStatus
|
asset profile |
state
|
dbtTestState
|
API only |
error
|
dbtTestError
|
asset filter and overview sidebar |
rawCode
|
dbtTestRawCode
|
overview sidebar |
rawSql
|
dbtTestRawSQL
|
overview sidebar |
compiledCode
|
dbtTestCompiledCode
|
API only |
compiledSql
|
dbtTestCompiledSQL
|
API only |
language
|
dbtTestLanguage
|
asset profile and overview sidebar |