Guide to CTEs | dbt Labs
A CTE is a temporary result set that can be used in a SQL query.
docs.getdbt.com