staging-layer

What problem does it solve?

Build dbt staging models that convert raw source data into a clean, consistent staging layer with a 1:1 mapping.

Core Features & Use Cases

• One staging model per source table with the naming convention stg_<source_name>__<table_name>.
• Enforce 1:1 source-to-staging mapping and forbid joins or business logic in staging.
• Read existing sources to avoid duplicates and use schema introspection for column stability.

Quick Start

Create a new staging model by inspecting the raw source with schema-introspect.js and naming it using stg_<source_name>__<table_name>, then run dbt compile and dbt test --select staging to validate.