Skip to content
dbt logo

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

  1. Post the job name and error to the data team channel in Slack
  2. Create an issue in Jira for the failed run

With Slack and Jira

Run a dbt job when a pull request merges in GitHub

When

A pull request is merged in GitHub

Then

  1. Trigger a job run for the production project
  2. Get a run's status until it finishes
  3. 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

docs.getdbt.com/docs/dbt-apis/admin-api

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.

Great — a couple more details

This helps us connect you with the right person. Optional, and you can skip it.