How to run Models on DBT Cloud through MWAA without using DBT Cloud Jobs

Help
1

Hi Everyone,

I have a requirement to build/run dbt models in dbt cloud using MWAA. As per the dbt platform, in order to do so we need to create dbt Cloud jobs and run those Cloud jobs through MWAA. Is there any other way where I can build/run dbt models in dbt cloud using MWAA without using dbt Cloud jobs?

2

Airflow run on MWAA and from there you can run dbt jobs.

3

yes, but I’m trying to figure out if I can run models without creating dbt cloud jobs, so basically through MWAA can I directly run dbt build commands for models

4

If you want models to run in dbt Cloud specifically, a job is how you would trigger that. There is no mechanism to pass an ad hoc command. You need a Deployment Environment and a Job.

But generally speaking in Airflow it is easy to clone a repo and execute dbt Core using any command you pass on the fly.