All posts

Snowflake Optimization Power Hour

  • Ian Whitestone
    Co-founder & CEO of SELECT

In this presentation, I do a dive deep 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.

Presentation Recording

The slides can be viewed here. To navigate the slides, you can click the arrows on the bottom right, or use the arrow keys on your keyboard. Press either the "esc" or the "o" key to zoom out into an "overview" mode where you can see all slides. From there, you can again navigate using the arrows and either click a slide or press "esc"/"o" to focus on it.

Snowflake optimization power hour presentation overview

A recording of the presentation will be shared soon. If you would like, I am more than happy to come in and give this presentation to your team where they can have the opportunity to ask questions. Send an email to [email protected] if you would like to set that up.

Get up and running with SELECT in 15 minutes.

Automatically optimize, understand and monitor Snowflake usage

Gain visibility into Snowflake usage, optimize performance and automate savings with the click of a button.

SELECT web application screenshot

Want to hear about our latest Snowflake learnings? 
Subscribe to get notified.