I am confused with Tip 1: if Modern Data Architecture suggests three different data layers (raw-staging-analytics) does it mean that staging outputs your dbt project builds are stored together with the non-transformed raw data in the same "Snowflake" database? This is a bit messy, isn't it? Shouldn't be stored in separated databases?
Hello, Michael. I just watched your masterful video. It's at least two steps above my head, but I definitely grasp the value of your content to your audience. (Someone on LinkedIn mentioned DBT, and I wound up here.) I want to follow your LinkedIn profile, but it is not allowed. Are you willing to change that option in order to allow LI users to follow your activity? TIA.
Great video, just to add to your tip about lines are cheap, brainpower isnt I would say, dont go overboard with lines and spacing, as it can often be much easier to grasp what a query is doing if you can see the whole query on one page Again balance ia key, not too much, not too little, keep it clean
The question should be if your database supports recursive CTEs, which is something you'll have to look up. Think of dbt as more of just a compiler for your code, and then it sends it to your databases where it actually gets run.
Deliver more impact w/ modern data tools, without getting overwhelmed
See how in The Starter Guide for Modern Data → www.kahandatasolutions.com/guide
Brilliant..how nicely explained..kudos bro
Thank you for sharing. These dbt tips are very useful.
I really enjoyed this video. In particular, it provided some validation of things that I have been doing in my DBT projects. Thanks!
Great tips, thanks. I have right away optimized one query with CTEs.
Glad it was helpful!
FYI, selection in v1.0 of dbt now favors -s or --select vs -m
Nice catch - good to know.
Thanks for the video! Your dbt videos are super helpful.
Glad to hear that, thanks Pate!
Thanks you soo much for your efforts, looking forward for more videos on DBT.
Thanks Manoj! Appreciate your support and for watching the videos
Brilliant! Thanks a lot!
You're welcome!
I am confused with Tip 1: if Modern Data Architecture suggests three different data layers (raw-staging-analytics) does it mean that staging outputs your dbt project builds are stored together with the non-transformed raw data in the same "Snowflake" database? This is a bit messy, isn't it? Shouldn't be stored in separated databases?
Yeah, good question, awaiting suggestions
Hello, Michael. I just watched your masterful video. It's at least two steps above my head, but I definitely grasp the value of your content to your audience. (Someone on LinkedIn mentioned DBT, and I wound up here.)
I want to follow your LinkedIn profile, but it is not allowed. Are you willing to change that option in order to allow LI users to follow your activity? TIA.
Great video, just to add to your tip about lines are cheap, brainpower isnt
I would say, dont go overboard with lines and spacing, as it can often be much easier to grasp what a query is doing if you can see the whole query on one page
Again balance ia key, not too much, not too little, keep it clean
This was very helpful. Thank you.
You're welcome! Thanks for watching
Is recursive CTE supported in dbt?
The question should be if your database supports recursive CTEs, which is something you'll have to look up.
Think of dbt as more of just a compiler for your code, and then it sends it to your databases where it actually gets run.
@@KahanDataSolutions perfect thanks
I love you.
DBT is kind of overengineering ;)