dbt Staging Layer #
Staging layers are cleaned up versions of the raw tables.
Each table should map 1:1 to each raw table.
Staging layers might handle things like:
-
Renaming fields
-
Casting fields
-
Conditional logic
But why? #
This makes the system modular.
This introduces a gatekeeper to controlling the flow of data.
Everything downstream is going to be cleaner and easier to manage.