two sources and two destinations in dbt
09:14 04 Dec 2025

I have two source schemas:

  • source_prd

  • source_dev

I also have two targets schemas:

  • target_prd

  • target_dev

All the tables are the same between dev and prd. I am essentially creating bunch of views from the source and inserting them to target.

I have defined two targets in my profiles.yml. and I have listed two sources in my sources.yml

how would I run each one of them with their corrseponsing source?

so far I got the code below but that does not specificy which source to run.

dbt run --target prd 
python dbt