Query and Performance Tuning in Snowflake
Query and Performance Tuning in Snowflake
Released: 07/2025
Duration: 56m 24s | .MP4 1280x720 30 fps(r) | AAC, 48000 Hz, 2ch | 139.60 MB
Genre: eLearning | Language: English
Released: 07/2025
Duration: 56m 24s | .MP4 1280x720 30 fps(r) | AAC, 48000 Hz, 2ch | 139.60 MB
Genre: eLearning | Language: English
Learn to diagnose and tune slow queries in Snowflake using real-world tools and patterns. This course teaches practical skills to analyze performance, refactor SQL, and configure warehouses for faster, more efficient query execution.
What you'll learn
Query tuning in Snowflake becomes far more effective with a structured approach—one that helps you uncover inefficiencies, optimize SQL patterns, and align compute resources with workload demands. In this course, Query and Performance Tuning in Snowflake, you’ll gain the skills to identify, analyze, and fix slow-running queries using the tools built into Snowflake. First, you’ll explore how to assess performance using the Query Profile and metadata views. You’ll learn to spot common symptoms like large scans, long compilation times, and queued executions, and interpret the key metrics behind each. Next, you’ll dive into SQL tuning techniques - refactoring nested CTEs, optimizing joins, applying filters earlier, and using clustering keys to reduce scanned data. You’ll also learn how table types can influence performance and costs. Finally, you’ll tune execution at the compute layer by aligning warehouse size and scaling behavior with workload demands. You’ll compare different storage structures like views, CTAS, and materialized views, and learn how to reduce compilation time for recurring queries. When you’re finished with this course, you’ll be equipped to troubleshoot performance issues and make confident, measurable improvements to your Snowflake queries.
More Info