5 Tips to Improve Your dbt Project

[@KahanDataSolutions]

Want to build a reliable, modern data architecture without the mess? Here’s a free checklist to help you → bit.ly/kds-checklist

[@prakashreddy8121]

Brilliant..how nicely explained..kudos bro

[@JesseSteinfort]

I really enjoyed this video. In particular, it provided some validation of things that I have been doing in my DBT projects. Thanks!

[@TusharKale9]

Thank you for sharing. These dbt tips are very useful.

[@vaclavdekanovsky9608]

Great tips, thanks. I have right away optimized one query with CTEs.

[@KahanDataSolutions]

Glad it was helpful!

[@noelgomez9202]

FYI, selection in v1.0 of dbt now favors -s or --select vs -m

[@KahanDataSolutions]

Nice catch - good to know.

[@patehubbard6892]

Thanks for the video! Your dbt videos are super helpful.

[@KahanDataSolutions]

Glad to hear that, thanks Pate!

[@bs.manoj33]

Thanks you soo much for your efforts, looking forward for more videos on DBT.

[@KahanDataSolutions]

Thanks Manoj! Appreciate your support and for watching the videos

[@kakegotam]

Brilliant! Thanks a lot!

[@KahanDataSolutions]

You're welcome!

[@danielvelascodiaz2169]

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?

[@bamboos]

Yeah, good question, awaiting suggestions

[@haydenhaddad2933]

This was very helpful. Thank you.

[@KahanDataSolutions]

You're welcome! Thanks for watching

[@houstonvanhoy7767]

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.

[@prateekkemkar8192]

Is recursive CTE supported in dbt?

[@KahanDataSolutions]

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.

[@prateekkemkar8192]

@@KahanDataSolutions perfect thanks

[@TheRoyalRandom]

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

[@sas19092008]

DBT is kind of overengineering ;)

[@pipepi4888]

I love you.