Enqurious logo
Go back

Understanding Performance Optimization in Snowflake

5 Scenarios
3 Hours 45 Minutes
Intermediate
masterclass poster
Industry
general
Skills
data-storage
performance-tuning
cloud-management
search-optimization-service
data-governance
Tools
snowflake

Learning Objectives

Understand the Need and Purpose of Resource Monitors
Learn How to Handle Warehouse Suspension Due to Credit Exhaustion
Learn how to use SYSTEM$CLUSTERING_INFORMATION to analyze clustering efficiency.
Understand how natural clustering in Snowflake impacts data organization and query performance.
Recognize the cost implications of using Search Optimization Service, including compute and storage overhead.
Learn the roles and use cases of Metadata Cache, Query Result Cache, and Warehouse Cache.

Overview

In this masterclass, learners will follow Vinay, a Data Engineer at GlobalMart, as he navigates common performance challenges in Snowflake and learns powerful optimization strategies from Rahul, the Senior Architect. The course will cover key topics like resource management with Snowflake’s Resource Monitors, query performance improvement through clustering techniques, and the optimization of product searches using the Search Optimization Service. Additionally, learners will explore the various caching mechanisms within Snowflake, including how they work and how to leverage them effectively for faster query execution. By the end of this masterclass, learners will gain a deep understanding of Snowflake’s optimization features and learn how to implement them to improve performance, save resources, and optimize costs.

Prerequisites

  • Basic Understanding of Snowflake Architecture
  • Familiarity with Snowflake’s Web UI (Snowsight)
  • Understanding the role of virtual warehouses for query performance
  • Familiarity with Snowflake Object Hierarchy
  • Basic Understanding of Snowflake Billing and Compute Costs
  • Familiarity with Query Execution in Snowflake
Redefining the learning experience

Supercharge Your
Data+AI Teams with us!