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
Source SQLELT PipelinesLake StorageStaging LakeWarehouseSecretsLogs

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.