# Analytics Stack — SnowBridge + Snowflake

SnowBridge owns the full path: ingest + in-process transform + curated-table write.

- Custom-built .NET service that reads from Aveva Historian SQL (Year 1) and Redpanda/ScadaBridge (Year 2).
- In-process transforms, canonical-model-aligned — aggregation, state enrichment, dim_equipment resolution.
- No dbt, no external orchestrator, no Snowflake landing tier — transforms live in the service.
- Governed selection of topics/tags via operator web UI with blast-radius-based approval workflow.
- ≤15-minute analytics SLO end-to-end (ScadaBridge emit → curated table in Snowflake).
- One "not possible before" AI/analytics use case in production by end of plan — pillar 2 gate.