Snowflake Cost Optimization
Paradime's Snowflake Cost Optimization is an advanced feature of our Radar product, designed to automatically reduce your Snowflake costs without compromising performance. By leveraging AI-driven analysis, this tool optimizes your Snowflake warehouses, providing significant savings with minimal effort.
How to Set Up
Set up Snowflake Cost Access - Complete all steps to give Paradime the necessary Snowflake access to optimize your Snowflake spend. This includes creating a new snowflake role and users, creating a paradime-specific data warehouse, creating an S3 integration, etc.
For a fast setup, update the placeholders and execute the code below:
Configure dbt™️ Project - Set up your dbt™ project to allow Paradime to enrich your Snowflake queries with additional metadata. This involves creating a new macro and updating your dbt_project.yml file.
Configure Cost Connection in Paradime - Connect your Snowflake account to Paradime using the credentials and information from the previous setup steps. This allows Paradime to access and optimize your Snowflake costs.
Snowflake cost optimizer will active one hour after setup.
Overview Tab
The Overview tab of the Snowflake Cost Optimizer serves as your central hub for analyzing (not controlling) warehouse spend. It offers a comprehensive snapshot of expenses related to both Snowflake and dbt™️ operations.
Key features
Comprehensive Snowflake usage and cost metrics
Detailed dbt™️ operation insights
Interactive elements for in-depth exploration
Optimizations tab
The Optimizations tab is where you can view and control the AI-driven cost-saving features of the Snowflake Cost Optimizer. This tab offers two powerful tools designed to maximize your Snowflake efficiency and minimize costs: Warehouse Autoscaler and Idle Time Optimizer.
Key Features
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
How to Use
Review potential savings and current savings
Examine the savings chart for overall performance
Scroll through warehouses to see specific optimization opportunities
Enable or disable optimizations as needed
Monitor "Current savings" to track actual savings over time
Last updated