Go back
Understanding Performance Optimization in Snowflake
5 Scenarios
3 Hours 45 Minutes
Intermediate
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
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