dbt Cloud and MySQL integrations and automations

Seamlessly connect dbt Cloud and MySQL. Automate workflows, and boost efficiency with Workato.

Ratings

4.9

Peer Insights™

100%

Customer Recommendation

Total

100+

active users

Avg

2 min

to connect

Custom connections

Available

via HTTP connector

Market leaders run on Workato

Build powerful workflows, fast

Triggers

When this happens…

dbt Cloud

Run Event Real-time
Triggers when a dbt Cloud job run event is created. This can be run.started, run.completed or run.errored

Any other trigger you can think up

MySQL

New row
New row in a table in MySQL
New rows Batch
New batch of rows in a table in MySQL
Scheduled query Batch
New/updated batch of rows via scheduled custom SQL in MySQL
New/updated row
New/updated row in a table in MySQL
New/updated rows Batch
New/updated batch of rows in a table in MySQL

Any other trigger you can think up

Actions

Do this…

dbt Cloud

Custom action
Custom action in dbt Cloud (Custom)
List Accounts
List Accounts in DBT
Retrieve Job
List Job in dbt
List Jobs
List Jobs in dbt Cloud
List Runs
List Runs in dbt Cloud
Retrieve Run
Retrieve Run in dbt Cloud
Retry Run
Retry run in dbt Cloud
Trigger job run
Trigger a job run in DBT Cloud

Any other action you can think up

MySQL

Delete rows Batch
Delete rows in a table in MySQL
Execute stored procedure Batch
Execute stored procedure in MySQL
Export query result
Export query result as a CSV file in MySQL
Insert row
Insert row in a table in MySQL
Insert rows Batch
Insert batch of rows in a table in MySQL
Run custom SQL Batch
Run custom SQL in MySQL
Run long query using custom SQL
Run long query using custom SQL in MySQL
Select rows Batch
Select rows in a table in MySQL
Get table schema
Get table schema for MySQL
Update rows
Update rows in a table in MySQL
Upsert rows Batch
Upsert batch of rows in a table in MySQL
Upsert row
Upsert row in a table in MySQL

Any other action you can think up

One platform

Power
Agility
Speed
Innovation

Let’s start automating

Schedule a Demo