Build scalable data transformations
dbt-transformation-patternsskillsetup L2★0
Sheshiyer/skill-clusters ↗What it does
Build modular, tested data transformations for analytics warehouse
Best for
When you need reproducible, documented, version-controlled analytics transformations.
Inputs
- · raw data tables
- · dbt models (.sql)
- · tests (.yml)
Outputs
- · transformed tables
- · data quality tests
- · lineage documentation
Requires
- · dbt-core
- · Jinja2 templating
- · SQL warehouse (Postgres/BigQuery/Snowflake)
Preconditions
- · raw data layer available
- · dbt project initialized
Failure modes
- · circular model dependencies
- · test coverage gaps on intermediate models
Trust signals
- · upstream/downstream dependencies mapped
- · test coverage per model
- · incremental strategies