Join us for a FREE hands-on Meetup webinar on Introduction to Agentic AI | Friday, March 21st, 2025 · 7:30 PM IST/ 10:00 AM EDT Join us for a FREE hands-on Meetup webinar on Introduction to Agentic AI | Friday, March 21st, 2025 · 7:30 PM IST/ 10:00 AM EDT
Search
Close this search box.
Search
Close this search box.

Snowflake Performance Automation and Tuning

Optimize Query Performance, Resource Management, and Automation for a Faster Snowflake Experience

Duration

3 Days

Level

Advanced Level

Design and Tailor this course

Official Course

Edit Content

This three-day accelerated course presents key performance capabilities, Snowflake best practices, and tuning techniques to help participants use the Snowflake Data Cloud to develop diverse, high-performance workloads. The course illustrates performance design best practices and pitfalls so participants can apply the methodology and features to their diverse workloads.

The course is delivered on the latest version of the Snowflake Data Cloud with new performance features and some emerging features in public preview.

This course consists of lectures with many practical examples in instructor-led demos, followed by experiential exercises.

ACQUIRED SKILLS

  • Work effectively and efficiently with the key capabilities and best practices behind Snowflake’s Data Cloud four-tier architecture designed for performance and scale.
  • Apply the appropriate Snowflake-provided tools for performance assessment and optimization.
  • Use Snowflake’s tuning methodology on established performance features, including best practices and avoiding pitfalls to work efficiently with the platform.
  • Explore emerging performance features with suitable use cases and adoption of best practices.
  • Formulate diverse, high-performance, and efficient workloads, including data transformations, analytic applications, and data sharing.
  • Achieve cost optimization by working effectively and monitoring the Snowflake Data Cloud.
Edit Content
  • Data Application Developers
  • Data Architects
  • Data Engineers
  • Snowflake Administrators
  • Technical Team Leads
Edit Content
  • Query Compilation
  • Query Execution
  • Filtering Data
  • Joining Data
  • Aggregating, Ordering, and Grouping Data
  • Subqueries and CTEs
  • Estimating and Sampling
  • Accessing External Data
  • Virtual Warehouse Types
  • Virtual Warehouse Settings
  • Monitor Virtual Warehouse Efficiency
  • Overview
  • Evaluate Ordering (Clustering)
  • Implement and Test Cluster Keys
  • Create a Cluster Key
  • Monitor Clustering Cost
  • Clustering: Common Misconceptions
  • Why Materialized Views?
  • Monitor Materialized Views
  • Monitor Dynamic Tables
  • Dynamic Tables vs. Materialized Views
  • Overview
  • How it Works
  • Add a Search Optimization
  • Monitor Search Optimization Cost
  • Overview
  • Identify Eligible Queries
  • Configure Query Acceleration
  • Monitor Query Acceleration
  • Finding Trouble in the Query_History
  • Finding Problematic Query Operators
  • Finding Patterns and Trends in Queries
  • Finding Inefficiencies
Edit Content

This course is designed for participants with extensive Snowflake experience or participants who have completed other relevant Snowflake courses such as “Snowflake Fundamentals” or “Snowflake Advanced”.

Connect

we'd love to have your feedback on your experience so far