Snowflake Cost Optimization
Last updated
Was this helpful?
Last updated
Was this helpful?
The Snowflake Cost Optimization dashboard, part of Paradime's Radar suite, allows you to control AI-driven cost-saving features that automatically reduce costs while maintaining performance. This section offers two powerful tools designed to maximize your Snowflake efficiency: Warehouse AI Agent Optimizer and Warehouse AI Autoscaler.
Prerequisites
Completed the setup in Radar's .
24/7 usage analysis and automatic rightsizing
Adapts to time-of-day and utilization patterns
Conservative approach maintains query performance
Optimized for BI tools and reporting warehouses
Value: Track your potential annual savings, actual savings to date, and review how optimizations have impacted your warehouse spend.
You can enable or disable these optimizations based on your cost-saving goals while maintaining performance. The two available optimization options are:
1. Warehouse AI Agent Optimizer
The Warehouse AI Agent Optimizer is responsible for optimizing the configuration of your Snowflake warehouses based on real-time and historical usage data. It ensures that your warehouses are right-sized and configured optimally without manual intervention, helping you save costs while maintaining query performance.
How it Works:
The AI agent reviews your warehouse usage patterns and automatically adjusts configuration settings to optimize performance.
The optimizer reduces the resources allocated to underused warehouses while maintaining adequate capacity for peak usage times.
The Warehouse AI Autoscaler dynamically adjusts the size of your Snowflake warehouses based on the workload. It scales resources up or down automatically based on demand, ensuring that you're only using the capacity you need, which reduces costs while maintaining performance.
How it Works:
The Autoscaler monitors the real-time query workload for each warehouse and automatically resizes it.
It ensures resources are right-sized during peak demand while scaling down during off-peak hours to prevent unnecessary resource costs.
The Autoscaler is optimized for BI tools and reporting warehouses, making it ideal for environments with fluctuating workloads.
Start with Your Most Expensive Warehouses: Focus your efforts on the warehouses with the highest potential savings, as these can generate the largest cost reductions.
Regularly Review Optimization Performance: Use different time ranges (7, 14, 30, or 60 days) to analyze how well your warehouses are being optimized. Adjust settings if you notice savings aren't as high as expected.
Pay Attention to Warehouses with High Potential but No Current Savings: Review warehouses that show high potential savings but currently have no savings. This may indicate they need further adjustments or more aggressive optimizations.