Posts

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

Sign up for our newsletter

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

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