Atlas Plan
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 run on a non-package dbt project requires [tool.uv] package = false in pyproject.toml.
  • Current raw_targets and parts of raw_marketing_activity arrive 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

  1. Start Plan 004 (Format layer) using marts now available in atlas.db.
  2. Optionally harden sync extraction for raw_targets/raw_marketing_activity headers to simplify staging SQL.

On this page