SQL vs dbt Models (& the value of CTEs)

Download The Modern Data Architecture Checklist (Free PDF) → https://bit.ly/kds-checklist
OR Get 1:1 Guidance For Your Small (Or 1-Person) Data Team → https://bit.ly/kds-advising

-----

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-a...

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