Plans003 2026 02 20 Transform Layer
Completed
- T-001: Create @packages/transform scaffold
- T-002: Create sources.yml
- T-003: stg_transactions.sql
- T-004: stg_students.sql
- T-005: stg_targets.sql
- T-006: stg_marketing_activity.sql
- T-007: Staging schema tests
- T-008: int_orders.sql
- T-009: int_enrollments.sql
- T-010: mart_revenue.sql
- T-011: mart_program_progress.sql
- T-012: mart_channel_marketing.sql
- T-013: mart_school_progress.sql
- T-014: Mart schema tests
- T-015: Full dbt run and test verification
- T-016: Update AGENTS.md with transform commands
In Progress
- None yet
Blocked
- None
Pending
- None
Learnings
uv runon a non-package dbt project requires[tool.uv] package = falseinpyproject.toml.- Current
raw_targetsand parts ofraw_marketing_activityarrive with positional/misaligned headers, so staging models need defensive column fallbacks. - End-to-end dbt pipeline now runs successfully with 10 models and 15 tests passing against
atlas.db.
Questions
- None yet
Next
- Start Plan 004 (Format layer) using marts now available in
atlas.db. - Optionally harden sync extraction for
raw_targets/raw_marketing_activityheaders to simplify staging SQL.