Skip to content
This repository has been archived by the owner on Feb 5, 2025. It is now read-only.

Clarification about CTE in staging model #61

Open
sdebruyn opened this issue Mar 15, 2022 · 0 comments
Open

Clarification about CTE in staging model #61

sdebruyn opened this issue Mar 15, 2022 · 0 comments

Comments

@sdebruyn
Copy link

The style guide recommends to use CTEs for transformation steps, ending with a CTE called final. It also recommends to use staging models to select from sources.

Would you also recommend to use a single CTE called final in these staging models?

E.g. this dbt learn course doesn't have that CTE and IMHO this makes sense as the only purpose there is to map the sources and you should not do any transformation logic in there.

cc @coapacetic (maintainer of that course)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant