dbt Cloud - Trigger Job and Download Results to Workflows

Overview

A Vessel built with this Blueprint will kick off a single job on dbt Cloud and check for the status every 60 seconds. Once the status is confirmed to be completed, Workflows will attempt to download all of the logs and artifacts. The final status of this Vessel in Workflows will reflect the status of the run in dbt Cloud. The "cause" for an execution triggered via Workflows will always contain the following details: - Fleet ID - Vessel ID - Vessel Log ID **Note:** This is considered an "all-in-one" Blueprint for the other 2 dbt Cloud Blueprints. This blueprint will not incur any billable runtime.

Variables

Name	Reference	Type	Required	Default	Options	Description
Service Token	DBT_API_KEY	Password	✅	None	-	Your unique service token for dbt Cloud. Instructions for how to get this token can be found in the authorization documentation.
Account ID	DBT_ACCOUNT_ID	Alphanumeric	✅	None	-	Your unique Account ID, found in the URL of dbt Cloud. https://cloud.getdbt.com/#/accounts/ACCOUNT_ID/projects/PROJECT_ID/dashboard/
Job ID	DBT_JOB_ID	Alphanumeric	✅	None	-	The ID of a specific job you want to run, found in the URL of dbt Cloud. https://cloud.getdbt.com/#/accounts/ACCOUNT_ID/projects/PROJECT_ID/jobs/JOB_ID/
Download Artifacts?	DBT_DOWNLOAD_ARTIFACTS	Boolean	✅	"true"	-	Determines if the artifacts from the run that was generated will be downloaded. Checked by default.
Download Logs?	DBT_DOWNLOAD_LOGS	Boolean	✅	"true"	-	Determines if the logs from the run that was generated will be downloaded. Checked by default.

YAML

Below is the YAML template

YAML


source:
  template: dbt Cloud - Trigger Job and Download Results to Workflows
  inputs:
    DBT_API_KEY:
    DBT_ACCOUNT_ID:
    DBT_JOB_ID:
    DBT_DOWNLOAD_ARTIFACTS: '"true"'
    DBT_DOWNLOAD_LOGS: '"true"'
  type: TEMPLATE
guardrails:
  retry_count: 0
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 200
    - 201
    - 211
    - 212