Snowflake Cost Optimization

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 Cost Management setup in Radar's Get Started guide.

Key Features

🔄 Warehouse Autoscaler

• 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

⏳ Idle Time Optimizer

• AI-powered learning from warehouse monitoring

• Reduces wasted idle time

• Optimizes suspension timing across all executions

• Works seamlessly with your existing Snowflake setup

---

Savings Overview

Value: Track your potential annual savings, actual savings to date, and review how optimizations have impacted your warehouse spend.

How to Use:

1. Review savings: Check potential annual savings and total savings to date using the Warehouse Optimizations table. Apply the Date Range Filter (7, 14, 30, or 60 days) to focus on specific periods.

2. Monitor the savings chart: Use the Warehouse Savings Across Optimizations chart to track optimization performance. Apply the Optimization Type Filter to focus on specific optimizations like the AI Agent or Autoscaler.

3. Adjust strategy: Review cost-saving trends with the Date Range Filter and adjust optimizations accordingly to maximize savings over different periods.

---

Warehouse Optimizations

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.

How to Use:

• Enable the Warehouse AI Agent Optimizer for specific warehouses using the Warehouse Optimizations table.

• Monitor potential savings for each warehouse to see where the most savings can be generated.

• Track actual savings using the "Savings" column in the table and adjust optimizations as needed based on performance.

---

2. Warehouse AI Autoscaler

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.

How to Use:

• Enable the Warehouse AI Autoscaler for specific warehouses using the Warehouse Optimizations table.

• Review the estimated savings generated by the Autoscaler and compare it to your overall warehouse costs.

• Use the savings data to ensure that warehouses with fluctuating demand are automatically right-sized to minimize costs.listed.

---

Best Practices:

• 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.