All posts

Snowflake Performance Tuning and Cost Optimization

Date

On September 28, I gave a presentation to the Snowflake Toronto User Group on Snowflake performance tuning and cost optimization. The following content was covered:

  1. Snowflake architecture
  2. The lifecycle of a Snowflake query
  3. Snowflake's billing model
  4. A simple framework for cost optimization, along with a detailed methodology for how to calculate cost per query
  5. Warehouse configuration best practices
  6. Table clustering tips

Slides

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 performance tuning and cost optimization presentation overview

Presentation Recording

A recording of the presentation is available on youtube. The presentation starts at 3:29.

If you would like, I am more than happy to come in and give this presentation (or a variation of it) 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.

Previous
How to use the Snowflake Query Profile

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