Warehouse bills cut in half — the actual moves

Warehouse bills cut in half — the actual moves

Five teams that slashed Snowflake/BigQuery spend without losing capability. Forward if your data bill scares finance.

— 1. A startup's query-pattern audit — found 8 dashboards re-running full scans hourly; materializing them cut compute 41%. Read if BI tools hammer your warehouse.
— 2. A retailer's clustering+partitioning pass — repartitioned the events table on date; scan bytes per query dropped 70%. The partition-key choice is the whole game.
— 3. A SaaS's auto-suspend tuning — dropped warehouse idle time from 8 min to 1; monthly credits fell 28%. The cheapest fix on this list.
— 4. A media co's incremental-model rewrite — stopped full-refreshing a 2B-row table nightly; build time went 90 min to 7. Essential if dbt full-refreshes are your bottleneck.
— 5. A fintech's result-cache push — routed repeated BI queries to cache, hit rate hit 60%, compute spend down a third. Skip if your queries are all unique; gold if they're not.

That's the stack for this week. Forward to a teammate.