get_warehouse_right_sizing_recommendations
Analyzes Snowflake warehouse credit usage and query queueing to provide heuristic right-sizing recommendations. Helps identify oversized or undersized warehouses for cost optimization.
Instructions
Heuristic right-sizing recommendations per warehouse, combining credit usage with query queueing behavior:
HIGH credits + very low query count -> likely oversized or left running idle; check auto-suspend and whether it's needed at all.
Meaningful average queued-overload time -> likely undersized or under-provisioned for concurrency; consider a larger size or a multi-cluster warehouse.
Otherwise -> no strong signal either way.
This is a heuristic starting point for investigation, not a guaranteed cost-saving recommendation -- always sanity-check against actual workload requirements before resizing a production warehouse.
Args: lookback_days: How many days back to look (default from server config).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lookback_days | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |