How to use ONE dbt project for all environments

[@KahanDataSolutions]

Get my Modern Data Essentials training (for free) & start building more reliable data architectures www.ModernDataCommunity.com

[@0523036]

@kahanDataSolutins, will The Playbook for dbt include the DBT cloud knowledge as well.. like how to schedule and how to run the jobs in different environments and how to set up those environment variables in the cloud and all please, Jinja and macro coding etc.

[@khabulbasha366]

Can we have multiple profiles in the profiles.yml apart from multiple environmnents. For example, haivng Snowflake and Redshift. If yes, how to connect the same?

[@sergzador]

Hey @Mike thank you for the video. One thing I did not see anyone covered is how DBT layers translate to DW objects. For example, it was quite surprising to me that "raw" layer is a separate DB. I just joined a new org and they did the same. I think this is a bit unusual approach, so would be great to see it covered.

[@HuongPham-kk5pk]

Hello Kahan, I want to know if maybe DBT can connect with 2 adapters in one project If yes, then how? Thank You.

[@KahanDataSolutions]

As I understand it, you can only use one adapter per project.

[@roberbonox]

Dude how are u, how can i used already created streams in snowflake in DBT?? Call them as tables sources or what? Thanks

[@olaoluwatobi9795]

Hello Kahan, I want to know if maybe DBT can run multi-selector tags If yes, then how? Thank You.

[@KahanDataSolutions]

Try adding comma-separated tags (ex. dbt run -s tag: tag_1, tag_2) to run multiple. I haven't tried myself but that would be my first thought. Here are the docs for more info: docs.getdbt.com/reference/resource-configs/tags

[@olaoluwatobi9795]

@@KahanDataSolutions Thank You

[@HeavensMeat]

Do you know why a pipe symbol | is necessary for the database assignment in your example ~5:54 mark on line 5 (database: |)? If so could you please explain this?

[@KahanDataSolutions]

This is YAML syntax for handling multi-line strings. I cover it more in this video - kzbin.info/www/bejne/eHbOmpKoqLyoaqc

[@sharvilpopli5505]

how would you change target dynamically based on branch its in in git?

[@surajprasad9155]

How to config and run it in dbt cloud

[@alaham2590]

Nice content on dbt, thank u, keep it up !

[@KahanDataSolutions]

Appreciate it!

[@metaller_alex]

Changing logic between environments is shooting in the leg.