dbt · Arazzo Workflow

dbt Cloud Bootstrap From Account to First Run

Version 1.0.0

Resolve account, project and environment, create a job, and trigger its first run.

1 workflow 5 source APIs 1 provider
View Spec View on GitHub Analytics EngineeringDataELTMetricsProjectSQLTransformationArazzoWorkflows

Provider

dbt

Workflows

bootstrap-account-and-run
From a token alone, resolve account/project/environment, create a job, and run it.
Lists accounts (first), projects (first), environments (first), creates a job in that project and environment, then triggers its first run.
5 steps inputs: cause, executeSteps, jobName, token outputs: accountId, environmentId, jobId, projectId, runId
1
listAccounts
List accounts and select the first one.
2
listProjects
List the selected account's projects and pick the first.
3
listEnvironments
List the account's environments and pick the first.
4
createJob
Create a job bound to the resolved project and environment.
5
triggerRun
Trigger the first run of the newly created job.

Source API Descriptions

Arazzo Workflow Specification

Raw ↑
arazzo: 1.0.1
info:
  title: dbt Cloud Bootstrap From Account to First Run
  summary: Resolve account, project and environment, create a job, and trigger its first run.
  description: >-
    The end-to-end onboarding flow that takes a caller from nothing but a token
    to a running job. The workflow lists accounts and selects the first, lists
    that account's projects and selects the first, lists the account's
    environments and selects the first, creates a job bound to that project and
    environment, and triggers the job's first run. Every step spells out its
    request inline so the flow can be read and executed without opening the
    underlying OpenAPI description.
  version: 1.0.0
sourceDescriptions:
- name: accountsApi
  url: ../openapi/dbt-accounts-api-openapi.yml
  type: openapi
- name: environmentsApi
  url: ../openapi/dbt-environments-api-openapi.yml
  type: openapi
- name: jobsApi
  url: ../openapi/dbt-jobs-api-openapi.yml
  type: openapi
- name: projectsApi
  url: ../openapi/dbt-projects-api-openapi.yml
  type: openapi
- name: runsApi
  url: ../openapi/dbt-runs-api-openapi.yml
  type: openapi
workflows:
- workflowId: bootstrap-account-and-run
  summary: From a token alone, resolve account/project/environment, create a job, and run it.
  description: >-
    Lists accounts (first), projects (first), environments (first), creates a
    job in that project and environment, then triggers its first run.
  inputs:
    type: object
    required:
    - jobName
    - executeSteps
    - token
    properties:
      jobName:
        type: string
        description: A display name for the new job.
      executeSteps:
        type: array
        description: The list of dbt commands the job runs.
        items:
          type: string
      token:
        type: string
        description: The dbt Cloud service token (sent as Authorization Bearer Token).
      cause:
        type: string
        description: A human-readable reason for the first run.
        default: Bootstrap first run
  steps:
  - stepId: listAccounts
    description: >-
      List accounts and select the first one.
    operationId: listAccounts
    parameters:
    - name: Authorization
      in: header
      value: Bearer $inputs.token
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      accountId: $response.body#/data/0/id
  - stepId: listProjects
    description: >-
      List the selected account's projects and pick the first.
    operationId: listProjects
    parameters:
    - name: Authorization
      in: header
      value: Bearer $inputs.token
    - name: accountId
      in: path
      value: $steps.listAccounts.outputs.accountId
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      projectId: $response.body#/data/0/id
    onSuccess:
    - name: hasProject
      type: goto
      stepId: listEnvironments
      criteria:
      - context: $response.body
        condition: $.data.length > 0
        type: jsonpath
    - name: noProject
      type: end
      criteria:
      - context: $response.body
        condition: $.data.length == 0
        type: jsonpath
  - stepId: listEnvironments
    description: >-
      List the account's environments and pick the first.
    operationId: listEnvironments
    parameters:
    - name: Authorization
      in: header
      value: Bearer $inputs.token
    - name: accountId
      in: path
      value: $steps.listAccounts.outputs.accountId
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      environmentId: $response.body#/data/0/id
    onSuccess:
    - name: hasEnvironment
      type: goto
      stepId: createJob
      criteria:
      - context: $response.body
        condition: $.data.length > 0
        type: jsonpath
    - name: noEnvironment
      type: end
      criteria:
      - context: $response.body
        condition: $.data.length == 0
        type: jsonpath
  - stepId: createJob
    description: >-
      Create a job bound to the resolved project and environment.
    operationId: createJob
    parameters:
    - name: Authorization
      in: header
      value: Bearer $inputs.token
    - name: accountId
      in: path
      value: $steps.listAccounts.outputs.accountId
    requestBody:
      contentType: application/json
      payload:
        account_id: $steps.listAccounts.outputs.accountId
        project_id: $steps.listProjects.outputs.projectId
        environment_id: $steps.listEnvironments.outputs.environmentId
        name: $inputs.jobName
        execute_steps: $inputs.executeSteps
    successCriteria:
    - condition: $statusCode == 201
    outputs:
      jobId: $response.body#/data/id
  - stepId: triggerRun
    description: >-
      Trigger the first run of the newly created job.
    operationId: triggerJobRun
    parameters:
    - name: Authorization
      in: header
      value: Bearer $inputs.token
    - name: accountId
      in: path
      value: $steps.listAccounts.outputs.accountId
    - name: jobId
      in: path
      value: $steps.createJob.outputs.jobId
    requestBody:
      contentType: application/json
      payload:
        cause: $inputs.cause
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      runId: $response.body#/data/id
  outputs:
    accountId: $steps.listAccounts.outputs.accountId
    projectId: $steps.listProjects.outputs.projectId
    environmentId: $steps.listEnvironments.outputs.environmentId
    jobId: $steps.createJob.outputs.jobId
    runId: $steps.triggerRun.outputs.runId

Work with this as data

Every workflow here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for arazzo workflows

4 MCP tools reach this
  • find_arazzoBrowse and filter every workflow in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This workflow
curl "https://apis.io/api/v1/arazzo/dbt-bootstrap-account-and-run-workflow"
All arazzo workflows
curl "https://apis.io/api/v1/arazzo?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.