What does Atlan crawl from dbt Cloud?

Have more questions? Submit a request

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

Nodes

Atlan maps nodes from dbt Cloud to its Process asset type. Atlan derives its lineage from the Process asset type.

Source property Atlan property Where in Atlan
uniqueId assetDbtUniqueId asset filter and overview sidebar
rawSQL dbtRawSQL overview sidebar
compiledSql dbtCompiledSQL overview 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

Metrics

Atlan maps metrics from dbt Cloud to its Metric 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
type metricType asset filter and overview sidebar
sql metricSQL asset preview and overview sidebar
timestamp metricTimestamp overview sidebar
timeGrains metricTimeGrains asset preview and overview sidebar
dimensions metricDimensions 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 dbt-specific 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

Related articles

Was this article helpful?
1 out of 1 found this helpful