Skip to main content

Jobs in dbt Cloud

These are the available job types in dbt Cloud:

Below is a comparison table that describes the behaviors of the different job types:

Deploy jobsCI jobsMerge jobs
PurposeBuilds production data assets.Builds and tests new code before merging changes into production.Build merged changes into production or update state for deferral.
Trigger typesTriggered by a schedule or by API.Triggered by a commit to a PR or by API.Triggered by a successful merge into the environment's branch or by API.
DestinationBuilds into a production database and schema.Builds into a staging database and ephemeral schema, lived for the lifetime of the PR.Builds into a production database and schema.
Execution modeRuns execute sequentially, so as to not have collisions on the underlying DAG.Runs execute in parallel to promote team velocity.Runs execute sequentially, so as to not have collisions on the underlying DAG.
Efficiency run savingsDetects over-scheduled jobs and cancels unnecessary runs to avoid queue clog.Cancels existing runs when a newer commit is pushed to avoid redundant work.N/A
State comparisonOnly sometimes needs to detect state.Almost always needs to compare state against the production environment to build on modified code and its dependents.Almost always needs to compare state against the production environment to build on modified code and its dependents.
Job run durationLimit is 24 hours.Limit is 24 hours.Limit is 24 hours.
0