How to use ONE dbt project for all environments

[@KahanDataSolutions]

Looking for help with your team's data strategy? → www.kahandatasolutions.com Looking to improve your data engineering skillset?→ bit.ly/more-kds

[@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.

[@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.

[@alaham2590]

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

[@KahanDataSolutions]

Appreciate it!

[@sharvilpopli5505]

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

[@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?

[@roberbonox]

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

[@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

[@surajprasad9155]

How to config and run it in dbt cloud

[@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

[@metaller_alex]

Changing logic between environments is shooting in the leg.

[@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.