What you'll learn

Slow Snowflake workloads can be frustrating because the obvious fix is not always the right fix. In this course, SnowPro® Core Certification (COF-C03): Performance Optimization, Querying, and Transformation, you'll gain the ability to slow down, read the evidence, and make tuning decisions you can explain to another Snowflake practitioner. First, you'll explore how Query Profile, Query Insights, query history, attribution, pruning, spill, joins, and queueing help you see what Snowflake actually did. Next, you'll discover how query acceleration service, search optimization service, clustering keys, and materialized views each solve a different kind of problem, with different cost and maintenance tradeoffs. Finally, you'll learn how to use result cache, metadata cache, warehouse cache, aggregates, optimized SQL patterns, and window functions while working with structured, semi-structured, and unstructured data. When you're finished with this course, you'll have the skills and knowledge of Snowflake performance optimization, querying, caching, and transformation needed to make COF-C03-ready decisions and talk about performance with calm, practical confidence.