Underutilized Snowflake Warehouse
Simar Arora
Service Category
Compute
Cloud Provider
Snowflake
Service Name
Virtual Warehouse
Inefficiency Type
Underutilized Resource
Explanation

Underutilized Snowflake warehouses occur when a workload is assigned a larger warehouse size than necessary. For example, a workload that could efficiently execute on a Medium (M) warehouse may be running on a Large (L) or Extra Large (XL) warehouse.This leads to unnecessary credit consumption without a proportional benefit to performance. Underutilization is often driven by early provisioning decisions that were not later reassessed, or by a desire for marginal speed improvements that do not justify the increased operational cost.

Relevant Billing Model

Snowflake charges based on the size and active runtime of a warehouse. Larger warehouses consume more credits per second of operation compared to smaller sizes, and relevant size should be used depending on workload requirements.

Detection
  • Analyze historical query activity for each warehouse to assess typical concurrency levels and peak usage patterns
  • Evaluate whether workloads experience query queuing or whether the warehouse is frequently underloaded
  • Review warehouse credit consumption relative to query volume and complexity over a representative time period
  • Confirm with data engineering or application teams whether the warehouse can be downsized without affecting SLAs or performance requirements
Remediation
  • Right-size the Snowflake warehouse by selecting a smaller size (e.g., from L to M, or M to S) that adequately supports workload performance and concurrency needs.
  • Implement a periodic review process to reassess warehouse sizing based on observed usage patterns and changes in workload requirements
  • Coordinate with business and engineering teams to validate any SLA requirements before resizing
Relevant Documentation