Platform Build Playbook — FNB Medallion Platform
This playbook documents how the FNB data platform was built phase by phase. Use it as a reusable template when building a similar GCP medallion platform for a new domain or client.
How to Use This Playbook
Each phase is a self-contained prompt + task checklist. Work through them in order. Each phase feeds into the next.
| Phase | File | What It Produces |
|---|---|---|
| 0 | phase-0-profiling.md | Source profiling report, grain + key decisions |
| 1 | phase-1-bronze.md | Loaded bronze tables, ingestion audit |
| 2 | phase-2-silver-dims.md | dim_* tables, normalized keys |
| 3 | phase-3-silver-rules.md | fact_* tables, bridge tables |
| 4 | phase-4-silver-resolved.md | Resolved analytic table (core grain) |
| 5 | phase-5-gold.md | Gold marts, KPI definitions |
| 6 | phase-6-quality.md | Tests, exception tables, reconciliation |
| 7 | phase-7-extensibility.md | Extension strategy, future hooks |
| — | business-questions.md | Full business question catalogue by stakeholder |
Adapting for a New Domain
- Replace all references to "food additives" / "CODEX" with your new domain
- Keep the same phase sequence — the pattern is domain-agnostic
- Phase 0 is the most important: get grain and keys right before writing any SQL
- Phases 2–4 form the silver core — do not skip or merge them
- Phase 6 is not optional — data quality gates protect gold consumers
Stack Assumptions
- Cloud: GCP
- Warehouse: BigQuery
- Transformations: Dataform (Core 3.0+)
- Infra: Terraform
- BI: Plotly/React UI
- Governance: Dataplex Universal Catalog