SELECT
SELECT Blog
Perspectives, product guidance, and practical stories for teams working with SELECT.
Latest
All Posts
55 published posts
How to speed up range joins in Snowflake by 300x
A deep dive into how you can optimize queries involving a range join for up to a 300x performance improvement.
Exclude and rename columns when using SELECT * in Snowflake
An overview of Snowflake's new SQL syntax which allows users to exclude and rename specific columns when running a SELECT * style query.
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.
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.
3 Ways to Achieve 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, and the three ways you can effectively cluster your tables.
Micro-Partitions: Understanding Snowflake's File Structure
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.
Snowflake Architecture Explained: 3 Crucial Layers
An overview of Snowflake's unique elastic data warehouse architecture and its three subcomponents cloud: cloud services, compute and storage