Optimization Opportunities
What Does the Optimization Opportunities Page Show?
The Optimization Opportunities page provides an overview of all optimization opportunities found for a Snowflake account. It shows four opportunity types: imbalanced workloads, wasteful queries, underprovisioned warehouses, and never-used tables.
What Are Imbalanced Workloads?
Diagnosis: The total number of warehouses with imbalanced workloads. These warehouses have queries running on them that would more efficiently run on a different warehouse.
Severity: Depends on the percentage of workloads that are imbalanced.
Recommendation: Visit "Warehouse Health" > "Workload Imbalance" to see the exact queries that would benefit from migration. These queries are often too large for the warehouse they run on. Contact Keebo customer success to use Smart Query Router, which routes queries to the correct warehouse automatically.
What Are Wasteful Queries?
Diagnosis: The total number of query patterns that fail regularly. When queries fail, the credits spent to run them are wasted.
Severity: Depends on the percentage of queries that fail.
Recommendation: Review queries whose failures waste the most compute resources, then rewrite them to prevent failure, migrate them to a larger warehouse, or increase the timeout on their warehouse. Navigate to "Query Health" > "Wasteful Queries" to view failing queries.
What Are Underprovisioned Warehouses?
Diagnosis: The total number of queries run on underprovisioned warehouses. These queries run on warehouses that are too small for the resources they require, resulting in high latency and execution times.
Severity: Depends on the percentage of queries running on underprovisioned warehouses.
Recommendation: Either increase the respective warehouse sizes or migrate these queries elsewhere. Contact Keebo customer success to use Smart Query Routing, which automatically sends queries to the appropriate warehouse.
What Are Never-Used Tables?
Diagnosis: The total number of tables that have never been used.
Severity: Depends on the percentage of tables that have never been used.
Recommendation: Review these tables and delete them if they are not needed. Navigate to "Data Health" > "Unused Tables" to find them.