Architecture of the week · Week 37, 2026
Enterprise Data Warehouse
Data Factory ELT from operational SQL through a staging lake into a Synapse warehouse for enterprise reporting.
Azure7 resourcesData & Analytics · intermediate
Why this architecture works
- ELT via the lake keeps source extracts cheap and lets Synapse do set-based transforms at scale
- Staging in ADLS Gen2 decouples extraction cadence from warehouse load windows
- Data Factory integration runtime isolates source connectivity from the analytical plane
- Warehouse access uses workspace identities; source credentials live only in Key Vault
- Pipeline run history and Synapse DMV metrics feed Log Analytics for freshness SLA tracking
Coming up
In 1 week
Zero-Trust Network Perimeter
Azure · 11 resources
In 2 weeks
Monitoring & Observability Stack
Azure · 8 resources
In 3 weeks
Cloud Run Services + API Gateway
Google Cloud · 9 resources
Previously featured
A new architecture every week.
Every pick is a real, editable diagram — open it, change it, and generate the Terraform that builds it.