Minzhen Yang

Dive deep into the Snowflake query lifecycle and master techniques to boost performance. Learn actionable insights to enhance workloads by pinpointing and resolving common bottlenecks using Snowflake’s latest features for peak efficiency. Apply practical tips for troubleshooting and optimizations while gaining a detailed understanding of Snowflake’s compiler and optimizer. The expert insights and best practices shared in this session will transform your query performance!

Embark on an immersive journey to master Snowflake optimization techniques for enhanced query performance and workload efficiency. This lab covers innovations such as Automatic Clustering, Materialized View, Query Acceleration Service, Search Optimization Service and Query Join Skewness Optimization to achieve optimal performance and minimize costs. In this lab, you’ll explore techniques for monitoring and tuning, optimize queries and workloads for maximum efficiency and savings, apply best practices in real-world scenarios, identify techniques for varied workload patterns and use AI for improved query monitoring. Join us to elevate your query performance and tuning skills.