Cost Management & Optimization
The SELECT team regularly writes about the best practices for managing costs and improving query performance in Snowflake. Whether you're a new or experienced Snowflake user, there will be something for you in our blog. If you're unsure where to begin, the posts below serve as a great starting point for your cost optimization journey!
Snowflake Architecture Overview
Learn how the internals of Snowflake work
Introduction to Snowflake's Micro-Partitions
Learn how Snowflake stores data, and how it can greatly accelerate query performance
Effective Clustering in Snowflake
Understand the most important query optimization strategy in Snowflake.
Choosing the right warehouse size in Snowflake
A step by step guide to one of the most important settings in Snowflake.
Snowflake Query Optimization Strategies
Our top tips for accelerating your query workloads in Snowflake.
Snowflake Cost Reduction Strategies
Actionable recommendations and strategies for lowering your Snowflake bill.
Here are some other resources:
- Snowflake Pricing
- Storage Costs
- Query Timeouts
- Resource Monitors
- Query Tags
- How to use the Snowflake Query Profile
- How to calculate cost per query
Query Optimization
- 60x faster database clones
- Effective Clustering in Snowflake
- Query Optimization Strategies
- Should you use CTEs in Snowflake?
- Optimizing Range Joins
- Defining multiple cluster keys in Snowflake with materialized views
Administration
- Stored Procedures
- Tasks
- Terraform for Snowflake
- Alerts & Notifications
- Error Notifications for Tasks
- Snowflake Query Queuing: Analyzing Queuing Overload
- Enabling and Disabling Snowflake MFA
- Using the Snowflake Query History: 9 Practical Examples
- Snowflake key pair authentication
- Snowflake User Type property
