Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

SnowPro Advanced Data Engineer: Performance Optimization

Maximize your Snowflake data platform's performance with advanced optimization techniques. This course will teach you expert techniques for identifying and resolving bottlenecks, leveraging caching, and monitoring data pipelines.

Pinal Dave - Pluralsight course - SnowPro Advanced Data Engineer: Performance Optimization
by Pinal Dave

What you'll learn

Optimizing the performance of your Snowflake data platform is crucial for ensuring the efficiency and scalability of your data-driven operations.

In this course, SnowPro Advanced Data Engineer: Performance Optimization, you'll gain the ability to become a Snowflake performance optimization expert.

First, you'll explore techniques for troubleshooting underperforming queries, including identifying bottlenecks, outlining telemetry, increasing efficiency, and identifying root causes.

Next, you'll discover how to configure Snowflake solutions for the best performance, including scaling out vs. scaling up, understanding virtual warehouse properties, optimizing micro-partitions and clustering, leveraging materialized views, and utilizing search and query acceleration services.

Finally, you'll learn how to outline and use caching features, as well as monitor continuous data pipelines, including Snowpipe, tasks, and streams.

When you're finished with this course, you'll have the skills and knowledge of Snowflake performance optimization needed to design, implement, and maintain highly efficient and scalable data solutions on the Snowflake platform.

Table of contents

About the author

Pinal Dave - Pluralsight course - SnowPro Advanced Data Engineer: Performance Optimization
Pinal Dave

Pinal Dave is a Pluralsight Developer Evangelist.

More Courses by Pinal