Medallion SQL
sql/bronze, sql/silver, sql/gold
Defines raw preservation, clean typed events, and BI-ready fact/dimension tables.
StreamFlow Phase 2
Enterprise analytics pipeline
A Snowflake medallion architecture, Gold star schema, Airflow orchestration template, and Power BI semantic contract built on top of the StreamFlow Phase 1 event stream.
01 Preserve raw payloads in Bronze
02 Type and deduplicate records in Silver
03 Publish facts and dimensions in Gold
04 Validate counts and joins before BI
05 Document dashboard measures and QA checks
Warehouse story
From stream output to business metrics
Phase 2 shows the handoff from data engineering to analytics engineering: raw event files become audited warehouse layers, reconciled reporting tables, and dashboard-ready measures.
Reconciliation
tests/reconciliation_checks.sql
Checks row counts and dimensional join integrity before dashboard refresh.
Semantic Layer
powerbi/measures.md
Documents DAX measures and Snowflake queries used to validate dashboard totals.
Open the interactive StreamFlow analytics dashboard backed by exported Snowflake Gold metrics