Skip to content
Components

dbt Cloud Job Trigger

The dbt Cloud Job Trigger is used for triggering dbt Cloud jobs.

Create a new configuration of the dbt Cloud Job Trigger application. Then fill in your Account ID, Job ID and API key. You also have the option to choose a custom Cause message to identify the trigger. It saves the response from triggerRun into the table dbt_cloud_trigger. If you check the Wait for result option, the component will wait for the job to finish for the maximum time set via the Max wait time field after it has been triggered. Then it will store the result of getRunById into the table dbt_cloud_run. It will also store all available artifacts, unless you turn that off with Don’t store artifacts.

dbt Cloud Job Trigger - Configuration

  1. Fill in Account ID
  2. Fill in Job ID
  3. Fill in API Key
  4. You can use the Cause field to enter the custom Cause message to be sent every time the Cloud job is triggered. It defaults to Triggered from Keboola.
  5. If you want the component to wait until the job finishes and store the results of getRunById along with all available artifacts into the artifacts storage, select the Wait for result option.
  6. Select the maximum time the component waits for results using the Max wait time field (in seconds, default 60).
  7. Don’t store artifacts — skip writing the run’s artifacts to artifacts storage. Off by default, so artifacts are stored.
  8. DBT Cloud URL — the base URL of your dbt Cloud instance. Defaults to https://cloud.getdbt.com; change it if your account is hosted on a different region or a single-tenant instance.

You can find out how to get a service account token in the dbt Cloud documentation.

In order to be able to use Keboola artifacts, the project must have the artifact feature enabled. You can find more information about this in Keboola’s docs.

Ask Kai

Hi, I'm Kai — Keboola's AI assistant for the docs. Ask me anything and I'll answer from the documentation and cite the pages I use.

Kai is an AI and can make mistakes. Check the sources it links.