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.
@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.
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?
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?
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
Looking for help with your team's data strategy? → www.kahandatasolutions.com
Looking to improve your data engineering skillset?→ bit.ly/more-kds
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.
@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.
how would you change target dynamically based on branch its in in git?
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?
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?
This is YAML syntax for handling multi-line strings. I cover it more in this video - th-cam.com/video/BEki_rsWu4E/w-d-xo.html
Dude how are u, how can i used already created streams in snowflake in DBT?? Call them as tables sources or what? Thanks
How to config and run it in dbt cloud
Nice content on dbt, thank u, keep it up !
Appreciate it!
Hello Kahan,
I want to know if maybe DBT can connect with 2 adapters in one project
If yes, then how?
Thank You.
As I understand it, you can only use one adapter per project.
Hello Kahan,
I want to know if maybe DBT can run multi-selector tags
If yes, then how?
Thank You.
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
@@KahanDataSolutions Thank You
Changing logic between environments is shooting in the leg.