[trumpeta]

ELT approach means you copy raw data from transactional sources, events, external APIs and dump it in the first “layer” of your data warehouse.

Then you progressively clean it and model it into some format that is easily usable for dashboards or self service analytics.

To do that you build a DAG of SQL scripts and dbt makes that easy through templating, macros and automatically generated docs.

You still have to execute the DAG somehow and here you either use their OSS version and schedule it with anything from Github Actions to Airflow, OR you buy their Cloud offering