.DkNUKaKx_ZLAT4m.webp?dpl=dpl_F3AP8gE1CJj8GcfnTX9Puwbcey1S){kind=small}
Connectors / Data and analytics · HTTP Connector
Automate dbt with Tray.ai
Call the dbt API from any Tray.ai workflow with the HTTP Connector.
Thanks — someone from our team will be in touch soon.
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.
- Connects through
- HTTP Connector
- Authentication
- A bearer token
Automate & integrate dbt
Automating dbt business processes or integrating dbt data is made easy with Tray.ai.
Use case
Jobs
Read and create jobs in dbt from any Tray.ai workflow. The dbt API covers calls such as trigger a job run and get a run's status.
- Trigger a job run
- Get a run's status
Use case
Webhook subscriptions
Read, create, update, and delete webhook subscriptions in dbt from any Tray.ai workflow. The dbt API covers calls such as list webhook subscriptions and get a webhook subscription.
- List webhook subscriptions
- Get a webhook subscription
- Create a webhook subscription
Use case
dbt events
Start a Tray.ai workflow the moment something happens in dbt. dbt sends events such as job run started and job run completed to a Tray.ai webhook trigger.
- Job run started
- Job run completed
- Job run errored
Ready to solve your dbt integration challenges?
See how Tray.ai makes it easy to connect, automate, and scale your workflows.
Thanks — someone from our team will be in touch soon.
Challenges Tray.ai solves
Common obstacles when integrating dbt — and how Tray.ai handles them.
Challenge
Keeping dbt credentials out of logs
A raw API call usually means pasting a key or token into the request, where it ends up in step inputs, logs, and screenshots.
How Tray.ai helps
Store dbt credentials once as a Tray.ai authentication and reference them from the HTTP Connector. Tray.ai masks authentication values in logs, so the secret never shows up in a step's input or output.
Challenge
Going from the dbt API docs to a working call
Translating an example request from API docs into a workflow step means copying the method, URL, headers, and body by hand.
How Tray.ai helps
Paste a cURL example from the dbt API docs into the HTTP Connector and Tray.ai fills in the method, URL, headers, and body for you.
Challenge
Handling files and non-JSON responses
Not every API answers in JSON. Some return XML, files, or binary data, or expect a multipart upload.
How Tray.ai helps
The HTTP Connector parses JSON and XML responses, returns files you can pass to the next step, and sends multipart form data for uploads.
How Tray.ai makes this work
dbt plugs into the whole Tray.ai platform
Intelligent Integration
Integrate and automate across 700+ connectors 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 →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
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
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
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.
Frequently asked questions
Does Tray.ai connect to dbt?
+
Yes. Tray.ai connects to dbt through the HTTP Connector, which calls the dbt API directly. Any call the dbt API documents can run as a step in a Tray.ai workflow.
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.
Can I get a dedicated dbt connector?
+
dbt runs through the HTTP Connector rather than a dedicated connector. If your team wants one, the Tray.ai connector SDK can build a dedicated dbt connector from the dbt API.
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.