The Backfill That Froze the DashboardsWarehouse · easy · ~10 minSales kickoff, 08:00: every executive dashboard spins. Queries that take 2 seconds are taking 90+. Meanwhile, the data team's month-end backfill — 40 heavy MERGE statements — has been running since 06:30... on the SAME warehouse the BI tool uses (ANALYTICS_WH, size L).Classic collision. Fix the morning, then fix the architecture — and address the objection that a second warehouse 'doubles our cost'.Evidence

Metrics

Config

Checkpoints

Execution p95 is flat (~2s) while elapsed p95 is 90s. Diagnosis?

Right now, with the CEO watching a spinner?

Counter the objection: 'a second warehouse doubles our cost'. Interview-style, with the billing model.