Skip to main content

dbt Cloud - Check Run Status (Deprecated)

Overview​

This Blueprint has been deprecated. Please use the vendor's "Trigger" Blueprint and set the "Wait for Completion" option to "True". Using this new option is free, more stable, and will complete faster. Read more about this change here.

Check for the status of a single run on dbt Cloud. The Vessel's exit code and status will match the status of the dbt Cloud run.

  • If the run is not completed, the Vessel will return an exit code of 255, an error.
  • If the run has completed with an error, the Vessel will return an exit code of 1, an error.
  • If the run has completed, but was canceled, the Vessel will return an exit code of 2, an error.
  • If the run has completed successfully, the Vessel will return an exit code of 0, interpreted by Platform as Successful.

The response for this request will always be stored at shipyard-artifacts/dbtcloud-blueprints/responses/run_RUNID_response.json

Recommended Setup:

  1. A Vessel built with this Blueprint should be paired with guardrail retries. This will allow the Vessel to continually check for status until a final result is found.

  2. This Vessel should run immediately after a Vessel built with the dbt Cloud - Execute Job Blueprint. With this setup, you can leave the Run ID field blank and this Vessel will check for the results of the recently created run.

Variables​

NameReferenceTypeRequiredDefaultOptionsDescription
Service TokenDBT_API_KEYPassword✅--Your unique service token for dbt Cloud. Instructions for how to get this token can be found in the authorization documentation.
Account IDDBT_ACCOUNT_IDAlphanumeric✅--Your unique Account ID, found in the URL of dbt Cloud. https://cloud.getdbt.com/#/accounts/ACCOUNT_ID/projects/PROJECT_ID/dashboard/
Run IDDBT_RUN_IDAlphanumeric➖--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/runs/RUN_ID/. If left blank, will try to find the run ID from an "Execute Job" Vessel that ran upstream.

YAML​

Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.

source:
  blueprint: dbt Cloud - Check Run Status (Deprecated)
  inputs:
    DBT_API_KEY: null  ## REQUIRED
    DBT_ACCOUNT_ID: null ## REQUIRED
    DBT_RUN_ID: null
  type: BLUEPRINT
guardrails:
  retry_count: 10
  retry_wait: 0h5m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - '200'
    - '201'
    - '211'
    - '212'