r/snowflake

Fourteen warehouses, one per team, because that is how finance got its split. Nine of them served a single dashboard each and sat idle using nearly 40% of compute.

It took three weekends to merge them down to 4 by workload and the BI team fought it the whole way. Ran the same query before and after.

SELECT warehouse_name,
       ROUND(SUM(credits_used_compute),1) AS compute,
       ROUND(SUM(credits_attributed_compute_queries),1) AS attributed,
       ROUND(100*(1-SUM(credits_attributed_compute_queries)
             /NULLIF(SUM(credits_used_compute),0)),1) AS idle_pct
FROM snowflake.account_usage.warehouse_metering_history
GROUP BY 1 ORDER BY 4 DESC

                 COMPUTE   ATTRIBUTED   IDLE_PCT
before, 14 wh      4,210        2,530       39.9
after, 4 wh        2,890        2,540       12.1

Attributed barely moved and we stopped paying for 1,320 credits of nothing.

Finance used to read the per-team figure straight off warehouse names. Now the 2,540 splits by query tag and the 350 idle sits on one warehouse that four teams share. I can spread it or leave it unowned and neither is a measurement.

What do you put in the per-team column after a consolidation?