Resources

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!

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

Security

• Roles & Access Control

Loading Data

• Data Loading Options
• Batch Data Loading Best Practices
• Snowpipe
• Merge Command

Data Transformations

• Stored Procedures
• Tasks
• Working with Semi-Structured Data
• JSON Data Parsing
• Exclude and rename
• DATEDIFF

dbt & Snowflake

• 3 ways to configure Snowflake warehouse sizes in dbt
• Monitoring dbt model spend and performance with metadata
• Identifying Unused dbt Models
• dbt Optimization Strategies
• dbt threads