Posts

All the latest Snowflake learnings, live and direct from experienced Snowflake practitioners.

Sign up for our newsletter

SELECT at Data Council 2023

Ian and Niall share their learnings and best practices on Snowflake cost optimization in a 30-minute presentation at Data Council 2023.

Date
Read more, SELECT at Data Council 2023

Identifying unused tables in Snowflake

Removing unused tables in your Snowflake account can reduce spend, increase security and improve overall warehouse usability. In this post, we show how to identify tables that have not been accessed recently.

Date
Read more, Identifying unused tables in Snowflake

How to use Query Timeouts in Snowflake

Query timeouts are an important tool for Snowflake users looking to control costs and prevent accidental cost spikes. In this post we’ll cover why they’re useful and how they can be configured.

Date
Read more, How to use Query Timeouts in Snowflake

Should you use CTEs in Snowflake?

CTEs are an extremely valuable tool for modularizing and reusing SQL logic. They're also a frequent focus of optimization discussions, as their usage has been associated with unexpected and sometimes inefficient query execution. In this post, we dig into the impact of CTEs on query plans, understand when they are safe to use, and when they may be best avoided.

Date
Read more, Should you use CTEs in Snowflake?

Essential Snowflake Cost Reduction Strategies

Snowflake is an incredibly powerful platform, easily scaling to handle ever-larger data volumes without compromising on performance. But, if not controlled, costs associated with this scaling quickly climb. Whether your goal is to reduce the price of an upcoming renewal, extend your existing contract's runway, or reduce on-demand costs, use the strategies in this post to make significant savings.

Date
Read more, Essential Snowflake Cost Reduction Strategies

Essential Snowflake Optimization Strategies

In this guide, we share optimization techniques to maximize the performance and efficiency of Snowflake. Follow these best practices to make queries run faster while reducing costs.

Date
Read more, Essential Snowflake Optimization Strategies

Configuring Snowflake warehouse sizes in dbt

The ability to use different warehouse sizes for different workloads in Snowflake provides enormous value for performance and cost optimization. dbt natively integrates with Snowflake to allow specific warehouses to be chosen down to the model level. In this post, we explain exactly how to use this feature and share some best practices.

Date
Read more, Configuring Snowflake warehouse sizes in dbt

Snowflake Performance Tuning and Cost Optimization

Ian gives a dive deep presentation into Snowflake’s architecture, the lifecycle of a query, optimal warehouse configuration, table clustering and micro-partition pruning. A detailed methodology for calculating cost per query is also shared.

Date
Read more, Snowflake Performance Tuning and Cost Optimization

How to use the Snowflake Query Profile

The Snowflake Query Profile is the single best resource you have to understand how Snowflake is executing your query and learn how to improve it. In this post we cover important topics like how to interpret the Query Profile and the things you should look for when diagnosing poor query performance.

Date
Read more, How to use the Snowflake Query Profile

Choosing the right warehouse size in Snowflake

Snowflake users enjoy a lot of flexibility when it comes to compute configuration. In this post we cover the implications of virtual warehouse sizing on query speeds, and share some techniques to determine the right one.

Date
Read more, Choosing the right warehouse size in Snowflake

Effective Clustering in Snowflake

Pairing query design with effective clustering can dramatically improve pruning and query speeds. We'll explore how and when you should leverage this powerful Snowflake feature.

Date
Read more, Effective Clustering in Snowflake

Introduction to Snowflake's Micro-Partitions

Independently scalable compute and storage is an architecture fundamental of Snowflake. In this post, we’ll be focusing on how Snowflake stores data, and how it can greatly accelerate query performance.

Date
Read more, Introduction to Snowflake's Micro-Partitions

60x faster database clones in Snowflake

Snowflake's zero-copy cloning feature is extremely powerful for quickly creating production replica environments. But, anyone who has cloned a database or schema with a large number of tables has experienced that it can take over ten minutes to complete. In this post we explore a potential solution.

Date
Read more, 60x faster database clones in Snowflake

Calculating cost per query in Snowflake

Understanding the cost of each query in your Snowflake virtual warehouses is critical for cost management. This post provides a detailed overview and working code to help you calculate cost per query.

Date
Read more, Calculating cost per query in Snowflake

Snowflake Optimization Power Hour

Ian gives a dive deep presentation into Snowflake’s architecture, the lifecycle of a query, how to use the query profile, optimal warehouse configuration, table clustering and micro-partition pruning. We also get into query best practices & anti-patterns - including some fun things like how to optimize range joins.

Date
Read more, Snowflake Optimization Power Hour

Snowflake Architecture Overview

An overview of Snowflake's unique elastic data warehouse architecture and its three subcomponents cloud: cloud services, compute and storage

Date
Read more, Snowflake Architecture Overview