dbt (data-build-tool) - SQL vs dbt Models (& the value of CTEs)

All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- There's a difference between writing SQL and designing a well structured dbt model. A lot of these nuances can be subtle. But when combined, make a big difference in the success of your project. So in today's video I want to talk about one of those nuances in particular. The usage of CTEs, or Common Table Expressions. You'll learn how they can: - Be used to provide functionality similar to Python - Improve the cleanliness and structure of your query - Simplify the process of de-bugging code Enjoy. Link to the Discourse article referenced: https://discourse.getdbt.com/t/ctes-are-passthroughs-some-research/155 Timestamps: 0:00 - Intro 0:32 - CTEs are "Passthroughs" 1:32 - Creating "Imports" 2:08 - Easier Debugging Title & Tags: SQL vs dbt Models (& the value of CTEs) #kahandatasolutions #dataengineering #dbt