capabilities.work

Cloud Create, Run, Poll and Collect Artifacts

A 4-step recipe with dbt. We can help you get access.

Recipe · 4 steps

Cloud Create, Run, Poll and Collect Artifacts

with dbt

Create a job, run it, poll to success, and collect its artifacts.

  1. Create a job bound to the supplied project and environment.
  2. Trigger the first run of the newly created job.
  3. Fetch the run. Status codes: 1 queued, 2 starting, 3 running, 10 success, 20 error, 30 cancelled. Success advances to artifacts, a terminal failure or cancellation ends the workflow, and any non-terminal status loops back.
  4. List the artifacts produced by the successful run.
What you'll need to have ready
  • accountId: The dbt Cloud account id.
  • projectId: The project the new job belongs to.
  • environmentId: The environment the job runs in.
  • jobName: A display name for the new job.
  • executeSteps: The list of dbt commands the job runs.
  • token: The dbt Cloud service token (sent as Authorization Bearer Token).
  • cause: A human-readable reason for the run.
For your developer

Arazzo workflow dbt:create-run-poll-artifacts, 4 operations: createJob → triggerJobRun → getRun → listRunArtifacts. Specs on APIs.io.