
Connectors / Data and analytics · HTTP Connector
Automate dbt with Tray.ai
Start a Tray.ai workflow when dbt sends “Job run started”. Connect dbt to the rest of your data and analytics stack with Tray.ai.
What can you do with dbt on Tray.ai?
dbt is a data transformation platform where analytics teams build, test and schedule SQL models in their data warehouse, with jobs run from the dbt platform. Tray.ai connects to dbt through the HTTP Connector, so your workflows can call the dbt API alongside the rest of your stack.
- Trigger a job run as soon as your nightly data load lands in the warehouse, so models build on fresh data.
- When dbt sends “Job run errored”, page the on-call data engineer with the failed job name.
- When dbt sends “Job run completed”, refresh the reporting dashboards that depend on those models.
- Connects through
- HTTP Connector
- Authentication
- A bearer token
Set it up
Connect dbt to Tray.ai
Each step uses dbt's own API details, from its documentation.
Step 1
Save dbt's API token
Save the token dbt issues as a Tray.ai authentication. The HTTP Client sends it as a bearer token on every call. The token stays out of the workflow and out of the logs.
Step 2
Import a request from dbt's docs
Add an HTTP Client step and paste a cURL example from dbt's API docs. Tray.ai fills in the method, URL, headers, and query.
Step 3
Start with “Get a run's status”
It's one of 8 documented actions, under Jobs. The response comes back as data the next step can map into your other apps.
Step 4
Start workflows from dbt events
Give dbt the URL of a Tray.ai webhook trigger. “Job run started” can then start a workflow, and so can 2 other events.
Workflows to build with dbt
Each one uses actions and events from dbt's own API documentation.
Alert the data team when a dbt job run errors
When
Job run errored
Then
- Post the job name and error to the data team channel in Slack
- Create an issue in Jira for the failed run
Run a dbt job when a pull request merges in GitHub
When
A pull request is merged in GitHub
Then
- Trigger a job run for the production project
- Get a run's status until it finishes
- Comment on the pull request in GitHub with the result
With GitHub
Apps you can build on dbt data
Internal tools your team can build with an AI assistant, each one using dbt calls from its API documentation.
Data job status board
Shows dbt job runs as they start, complete or error so analysts know when data is fresh.
On-demand model refresh
Lets an analyst trigger a job run before a meeting and shows its status until it finishes.
Give your AI agents dbt tools
Build an MCP server on dbt in Agent Gateway and choose which actions your agents can call. Every call runs with access control and an audit trail. How Agent Gateway works
- Trigger a job run
- List webhook subscriptions
- Get a run's status
- Get a webhook subscription
- Create a webhook subscription
- Update a webhook subscription
- Test a webhook subscription
- Delete a webhook subscription
What the dbt API covers
2 resources and 8 documented actions, each one a call the HTTP Connector can make from a Tray.ai workflow. Connecting it takes a few clicks: here's how.
Jobs
- Trigger a job run
- Get a run's status
Webhook subscriptions
- List webhook subscriptions
- Get a webhook subscription
- Create a webhook subscription
- Update a webhook subscription
- Test a webhook subscription
- Delete a webhook subscription
Events dbt can send to a Tray.ai webhook trigger
- Job run started
- Job run completed
- Job run errored
Checked against dbt's own documentation on 2026-10-22
How Tray.ai makes this work
dbt plugs into the whole Tray.ai platform
Intelligent Integration
Integrate and automate across 12,000+ apps, databases, APIs, and services with visual workflows, error handling, and observability.
Learn more →Agent Builder
Build AI agents that read, write, and take action in dbt — with guardrails, audit, and human-in-the-loop.
Learn more →Agent Gateway for MCP
Expose dbt actions as governed MCP tools — observable, rate-limited, authenticated.
Learn more →Tray Helix
Build apps on dbt data with your AI assistant, then deploy, run, and govern them on Tray.ai.
Learn more →Guides that use dbt
Step by step builds with copy-paste prompts for your coding assistant, and what it takes to run each one in production.
How to build
AutomationSchema change management
Detect a source change before it breaks a model, resolve what depends on it, and tell the owner in time to act.
How to build
IntegrationCRM to warehouse sync
Capture history instead of current state, handle deletes and field changes, land raw then model, and prove the row counts.
How to build
AutomationData quality monitoring
Test what breaks decisions, alert the owner rather than a channel, and say what depends on a failure.
How to build
IntegrationReverse ETL from the warehouse
Push modelled data back into the tools people work in, syncing deltas, respecting field ownership, and never overwriting a human.
More data and analytics apps on Tray.ai
Dedicated connectors and other apps Tray.ai reaches in the same category. See every data and analytics connector →
Frequently asked questions
What can a Tray.ai workflow do in dbt?
+
The dbt API documents 8 actions across 2 resources (Jobs, Webhook subscriptions). For example: Trigger a job run; List webhook subscriptions. A workflow can make any documented call through the HTTP Connector.
How does Tray.ai authenticate with dbt?
+
The dbt API uses a bearer token. You save it once as a Tray.ai authentication, and the HTTP Connector adds it to every request.
Which dbt events can start a Tray.ai workflow?
+
dbt sends 3 events to a webhook URL, for example: Job run started; Job run completed; Job run errored. A Tray.ai webhook trigger receives them and starts a workflow.
See dbt working against your stack.
We'll walk through a tailored demo with your systems plugged in.
Thanks — someone from our team will be in touch soon.