Warehouse demo — run index

Self-contained index for the agentic warehouse-design demonstration. Synthetic data only.

Runs (complete)

Run	Focus	Status
1	Synthetic source-data pack	Complete
2	Agent definitions + source profiling	Complete
3	Warehouse design proposal	Complete
4	Azure SQL artefacts	Complete
5	ADF specs + reporting QA demo	Complete

source-data → profile → design → SQL → ADF → mart → report QA → human review

Artefact	Path
Generator	`generator/create_synthetic_source_data.py`
Source extracts	`source-data/`
Manifest	`profile-output/source_manifest.csv`
Human answer key	human-only reviewer checklist (not published on site) — reviewers only

Artefact	Path
Agent rule	`../../agent-rules/source-profiling-agent.md`
Profiler	`../profiler/profile_sources.py`
Profiling report	`../profile-output/source_profiling_report.md`
Conversation	`../../examples/warehouse-source-profiling-conversation.md`
Checkpoint	`../checkpoints/run2_checkpoint.md`

Artefact	Path
Agent rule	`../../agent-rules/warehouse-design-agent.md`
Design proposal	`../design/warehouse_design_proposal.md`
Human review pack	`../design/human_review_pack.md`
Conversation	`../../examples/warehouse-design-conversation.md`
Checkpoint	`../checkpoints/run3_checkpoint.md`

Artefact	Path
SQL README	`../sql/README.md`
Expected load counts	`../sql/EXPECTED_SYNTHETIC_LOAD_COUNTS.md`
Demo loader	`../sql/load/load_from_csv.py`
Checkpoint	`../checkpoints/run4_checkpoint.md`

Artefact	Path
Pipeline overview	`../pipelines/pipeline_overview.md`
Measure builder	`../generator/build_provider_month_measures.py`
Mart CSV	`../marts/demo_provider_month_measures.csv`
Flawed draft	`../../examples/warehouse-draft-urgent-care-brief-flawed.md`
Corrected brief	`../reports/urgent-care-provider-month-brief.html`
QA conversation	`../../examples/warehouse-report-qa-conversation.md`
QA agent addendum	`../../agent-rules/warehouse-report-qa-agent.md`
Checkpoint	`../checkpoints/run5_checkpoint.md`

Page	Path
Explanatory hub	`../../data-warehouse-agent-demo.html`
Legacy pointer	`../agentic-warehouse-build.html` — redirects to top-level page
Urgent-care analysis	`../reports/synthetic-urgent-care-analysis.html`
Reporting-table assurance	`../reports/synthetic-reporting-table-assurance.html`
Corrected brief	`../reports/urgent-care-provider-month-brief.html`

File	Do not rewrite after later runs
`run2_checkpoint.md`	Preserves Run 2 state
`run3_checkpoint.md`	Preserves Run 3 state
`run4_checkpoint.md`	Preserves Run 4 state
`run5_checkpoint.md`	Session complete
`runs_2_5_internal_qa.md`	Internal consistency QA (Runs 2–5)
`reporting_pages_checkpoint.md`	Reader-facing pages created
`dedicated_page_checkpoint.md`	Top-level dedicated page