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.