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.
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.
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.