Portfolio piece — no longer accepting signups. See what I'm building now

Portfolio piece — no longer accepting signups. See what I'm building now

Deploy6 min readIntermediate

dbt Cloud Integration

Connect DataChonk to dbt Cloud to trigger runs, monitor status, and close the loop between building models and running them in production.

Overview

After pushing your DataChonk-generated code to Git, you can optionally trigger a dbt Cloud run to validate and materialize your models. This creates a seamless build-push-run workflow.

Git repository required

dbt Cloud projects must be connected to a Git repository. Make sure your dbt Cloud project is linked to the same repository where DataChonk pushes your code.

Prerequisites

A dbt Cloud account (Team or Enterprise plan)
A dbt Cloud project connected to a Git repository
At least one job configured in your dbt Cloud project
API access enabled for your account

Getting API Credentials

You need two pieces of information to connect DataChonk to dbt Cloud: your Account ID and an API token.

Finding Your Account ID

Your Account ID is in the URL when you're logged into dbt Cloud:

text

https://cloud.getdbt.com/accounts/12345/projects/...
                                      ^^^^^
                              This is your Account ID

Creating an API Token

Go to Account Settings

Click your profile icon in dbt Cloud and select 'Account Settings'.

Navigate to API Access

In the left sidebar, click 'API Access' under 'Account Settings'.

Create a Service Token

Click 'Create Service Token' and give it a descriptive name like 'DataChonk Integration'.

Select the following permissions:

Account Admin - Read account-level information
Jobs - View and trigger jobs
Runs - View run information and artifacts

Copy the token

Copy your new token immediately - you won't be able to see it again. It will start with 'dbtc_' or 'dbt_'.

Keep your token secure

Treat your API token like a password. Don't commit it to version control or share it publicly. DataChonk encrypts and stores your token securely.

Connecting in DataChonk

Via Web UI

After pushing code to Git, you'll see the dbt Cloud connection step:

Enter credentials

Paste your Account ID and API token into the form.

Verify connection

DataChonk will verify your credentials and fetch your available projects.

Select project and job

Choose the dbt Cloud project (it should match your Git repo) and select a job to trigger.

Via CLI

Configure dbt Cloud in your project's datachonk.yaml or use environment variables:

datachonk.yaml

deploy:
  dbt_cloud:
    account_id: 12345
    project_id: 67890
    job_id: 11111
    # Optional: auto-trigger after push
    auto_trigger: true

Or use environment variables:

Terminal

export DBT_CLOUD_API_TOKEN="dbtc_your_token_here"
export DBT_CLOUD_ACCOUNT_ID="12345"
export DBT_CLOUD_PROJECT_ID="67890"
export DBT_CLOUD_JOB_ID="11111"

datachonk push --trigger-dbt-run

Triggering Runs

Once connected, DataChonk can trigger dbt Cloud jobs and monitor their status.

From the Web UI

After selecting a job, click Trigger Run. DataChonk will:

Send a run request to dbt Cloud's API
Include metadata about the DataChonk project and commit SHA
Poll for status updates every few seconds
Show real-time progress (Queued → Running → Success/Error)
Provide a direct link to view the full run in dbt Cloud

From the CLI

Terminal

# Push and trigger run
datachonk push --trigger-dbt-run

# Trigger run without pushing (if code is already in Git)
datachonk dbt-run --job-id 11111

# Trigger run with custom cause message
datachonk push --trigger-dbt-run --cause "New customer dimension model"

# Wait for run to complete
datachonk push --trigger-dbt-run --wait

Understanding Run Status

Status	Meaning	Action
Queued	Waiting for available runner	Wait for processing
Running	Job is executing	Monitor progress
Success	All steps completed successfully	Models are live!
Error	One or more steps failed	Check logs in dbt Cloud
Cancelled	Run was manually cancelled	Re-trigger if needed

Job Configuration Tips

Set up your dbt Cloud jobs to work well with DataChonk's workflow.

Create a "Slim CI" job

Create a dedicated job for validating new models without running the entire project:

yaml

commands:
  - dbt build --select state:modified+ --defer --state ./prod-manifest

Enable "Triggered via API"

Make sure your job has "Triggers: API" enabled in the job settings. This allows DataChonk to start runs programmatically.

Use environment-specific jobs

Consider separate jobs for development/staging vs production environments. Trigger dev jobs for quick validation, production jobs for final deployment.

API Reference

If you're integrating programmatically, here are the endpoints DataChonk uses.

Property	Type	Default	Description
POST /api/dbt-cloud/connect*	JSON	-	Connect to dbt Cloud with API token and account ID
GET /api/dbt-cloud/status	-	-	Check connection status and list projects
GET /api/dbt-cloud/projects/:id/jobs	-	-	List jobs for a specific project
POST /api/dbt-cloud/trigger-run*	JSON	-	Trigger a job run with optional metadata
GET /api/dbt-cloud/runs/:id	-	-	Get run status by run ID

dbt Cloud Integration

Connect DataChonk to dbt Cloud to trigger runs, monitor status, and close the loop between building models and running them in production.

Overview

After pushing your DataChonk-generated code to Git, you can optionally trigger a dbt Cloud run to validate and materialize your models. This creates a seamless build-push-run workflow.

Git repository required

dbt Cloud projects must be connected to a Git repository. Make sure your dbt Cloud project is linked to the same repository where DataChonk pushes your code.

Prerequisites

A dbt Cloud account (Team or Enterprise plan)
A dbt Cloud project connected to a Git repository
At least one job configured in your dbt Cloud project
API access enabled for your account

Getting API Credentials

You need two pieces of information to connect DataChonk to dbt Cloud: your Account ID and an API token.

Finding Your Account ID

Your Account ID is in the URL when you're logged into dbt Cloud:

text

https://cloud.getdbt.com/accounts/12345/projects/...
                                      ^^^^^
                              This is your Account ID

Creating an API Token

Go to Account Settings

Click your profile icon in dbt Cloud and select 'Account Settings'.

Navigate to API Access

In the left sidebar, click 'API Access' under 'Account Settings'.

Create a Service Token

Click 'Create Service Token' and give it a descriptive name like 'DataChonk Integration'.

Select the following permissions:

Account Admin - Read account-level information
Jobs - View and trigger jobs
Runs - View run information and artifacts

Copy the token

Copy your new token immediately - you won't be able to see it again. It will start with 'dbtc_' or 'dbt_'.

Keep your token secure

Treat your API token like a password. Don't commit it to version control or share it publicly. DataChonk encrypts and stores your token securely.

Connecting in DataChonk

Via Web UI

After pushing code to Git, you'll see the dbt Cloud connection step:

Enter credentials

Paste your Account ID and API token into the form.

Verify connection

DataChonk will verify your credentials and fetch your available projects.

Select project and job

Choose the dbt Cloud project (it should match your Git repo) and select a job to trigger.

Via CLI

Configure dbt Cloud in your project's datachonk.yaml or use environment variables:

datachonk.yaml

deploy:
  dbt_cloud:
    account_id: 12345
    project_id: 67890
    job_id: 11111
    # Optional: auto-trigger after push
    auto_trigger: true

Or use environment variables:

Terminal

export DBT_CLOUD_API_TOKEN="dbtc_your_token_here"
export DBT_CLOUD_ACCOUNT_ID="12345"
export DBT_CLOUD_PROJECT_ID="67890"
export DBT_CLOUD_JOB_ID="11111"

datachonk push --trigger-dbt-run

Triggering Runs

Once connected, DataChonk can trigger dbt Cloud jobs and monitor their status.

From the Web UI

After selecting a job, click Trigger Run. DataChonk will:

Send a run request to dbt Cloud's API
Include metadata about the DataChonk project and commit SHA
Poll for status updates every few seconds
Show real-time progress (Queued → Running → Success/Error)
Provide a direct link to view the full run in dbt Cloud

From the CLI

Terminal

# Push and trigger run
datachonk push --trigger-dbt-run

# Trigger run without pushing (if code is already in Git)
datachonk dbt-run --job-id 11111

# Trigger run with custom cause message
datachonk push --trigger-dbt-run --cause "New customer dimension model"

# Wait for run to complete
datachonk push --trigger-dbt-run --wait

Understanding Run Status

Status	Meaning	Action
Queued	Waiting for available runner	Wait for processing
Running	Job is executing	Monitor progress
Success	All steps completed successfully	Models are live!
Error	One or more steps failed	Check logs in dbt Cloud
Cancelled	Run was manually cancelled	Re-trigger if needed

Job Configuration Tips

Set up your dbt Cloud jobs to work well with DataChonk's workflow.

Create a "Slim CI" job

Create a dedicated job for validating new models without running the entire project:

yaml

commands:
  - dbt build --select state:modified+ --defer --state ./prod-manifest

Enable "Triggered via API"

Make sure your job has "Triggers: API" enabled in the job settings. This allows DataChonk to start runs programmatically.

Use environment-specific jobs

Consider separate jobs for development/staging vs production environments. Trigger dev jobs for quick validation, production jobs for final deployment.

API Reference

If you're integrating programmatically, here are the endpoints DataChonk uses.

Property	Type	Default	Description
POST /api/dbt-cloud/connect*	JSON	-	Connect to dbt Cloud with API token and account ID
GET /api/dbt-cloud/status	-	-	Check connection status and list projects
GET /api/dbt-cloud/projects/:id/jobs	-	-	List jobs for a specific project
POST /api/dbt-cloud/trigger-run*	JSON	-	Trigger a job run with optional metadata
GET /api/dbt-cloud/runs/:id	-	-	Get run status by run ID

Overview

Prerequisites

Getting API Credentials

Finding Your Account ID

Creating an API Token

Go to Account Settings

Navigate to API Access

Create a Service Token

Copy the token

Connecting in DataChonk

Via Web UI

Enter credentials

Verify connection

Select project and job

Via CLI

Triggering Runs

From the Web UI

From the CLI

Understanding Run Status

Job Configuration Tips

Create a "Slim CI" job

Enable "Triggered via API"

Use environment-specific jobs

API Reference

Related Documentation

Deploy Overview

dbt Cloud API Docs

CI/CD Best Practices

Overview

Prerequisites

Getting API Credentials

Finding Your Account ID

Creating an API Token

Go to Account Settings

Navigate to API Access

Create a Service Token

Copy the token

Connecting in DataChonk

Via Web UI

Enter credentials

Verify connection

Select project and job

Via CLI

Triggering Runs

From the Web UI

From the CLI

Understanding Run Status

Job Configuration Tips

Create a "Slim CI" job

Enable "Triggered via API"

Use environment-specific jobs

API Reference

Related Documentation

Deploy Overview

dbt Cloud API Docs

CI/CD Best Practices