# Suboptimal Query Routing

Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-query-routing

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

# Suboptimal Query Routing

## Explanation

Organizations may experience unnecessary Snowflake spend due to inefficient query-to-warehouse routing, lack of dynamic warehouse scaling, or failure to consolidate workloads during low-usage periods. Third-party platforms offer solutions to address these inefficiencies:

- Sundeck enables highly customizable, SQL-based control over the query lifecycle through user-defined rules (Flows, Hooks, Conditions). Cost optimization techniques include adaptive warehouse routing, instant warehouse suspension, and off-peak consolidation. However, it requires users to maintain optimization logic manually.

- Keebo offers a fully automated AI-driven approach, dynamically tuning warehouse size, clustering, and memory configurations without requiring manual query intervention. It prioritizes minimal operational effort with continuous background optimization.

Choosing between these solutions depends heavily on the organization's internal capabilities and desired balance between control and automation.

## Relevant Billing Model

## Detection

- Assess whether query workloads are currently routed manually or rely on static warehouse assignments

- Review warehouse utilization patterns to identify opportunities for dynamic resizing, load balancing, or consolidation during off-peak periods

- Evaluate whether internal teams have the expertise and capacity to manage custom query optimization rules

- Consider whether an AI-driven optimization platform would better fit organizational needs for cost reduction with minimal manual overhead

## Remediation

- Implement customizable query lifecycle management platforms (e.g., Sundeck) if granular control is required and in-house SQL/DevOps expertise is available

- Deploy AI-driven warehouse optimization platforms (e.g., Keebo) for organizations prioritizing ease of use and autonomous cost management

- Pilot third-party solutions in a limited environment to validate cost savings and performance impacts before full-scale adoption

- Continuously monitor optimization effectiveness and adjust platform configurations based on workload evolution and business priorities

## Relevant Documentation

[Submit Feedback](https://hub.pointfive.co/inefficiencies/suboptimal-query-routing)

## At a glance

Reference

CER-0029

Cloud provider

Snowflake

Service

Snowflake Query Processing

Category

[Other](https://www.pointfive.co/efficiency-hub/service-category/other)

Inefficiency type

Suboptimal Query Routing and Warehouse Utilization

## Contributed by

- Simar Arora 

### Simar Arora

Value Engineer - FinOps @ Snowflake

[LinkedIn](https://www.linkedin.com/in/simarpreet-arora/)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.