๐๏ธ CTE in SQL
A Common Table Expression (CTE) is a temporary result set that can be used in a SQL query. You can use CTEs to break up complex queries into simpler blocks of code that can connect and build on each other.
The Analytics Engineering Glossary is a living collection of terms & concepts commonly used in the data industry by dbt Labs. You can use and contribute to this resource to educate yourself, your team, and your stakeholders.