Using Results Explicitly with RESULT_SCAN()
I am a fan of the result set cache in Snowflake. It is one of three layers of caching, and can be a reliable way to mitigate the impact of repeated queries when the underlying tables are fairly slow to…
Tag pruning
Static and Dynamic Partition Pruning in Snowflake
One key to performance in Snowflake is using partition pruning to read as little data as possible. I’ve previously written about what partition pruning is in Snowflake, but there are really two different types of partition pruning. Static Partition Pruning…
Snowflake Partition Pruning: What is it, and why does it matter?
One of the most basic building blocks of Snowflake query performance is partition pruning. Let’s explore partition pruning, identifying when it is occurring, and why it matters for query performance. Micro-Partitions Snowflake stores data in micro-partitions. Micro-partitions are proprietarily structured…