Snowflake: Performance Management

Snowflake 2024    |    Intermediate
  • 8 videos | 27m
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Snowflake includes several optimization features, such as the metadata cache, the query result cache, the virtual warehouse cache, and partition pruning, that Snowflake automatically uses to optimize performance. Snowflake also provides additional performance capabilities that can be manually configured to improve performance. These capabilities include scaling up and down a virtual warehouse or autoscaling a virtual warehouse to accommodate increased concurrency. In this course, you'll learn about Snowflake's performance considerations. You'll also learn about the scaling up and scaling down capabilities of Snowflake and the purpose of scaling out. You'll explore the concepts of caching and data clustering in Snowflake and discover the purpose of materialized views in Snowflake.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify snowflake’s performance considerations
    Explore the scaling up and scaling down capabilities of snowflake
    Explore the purpose of scaling out and the standard and economy scaling policies
  • Explore the concept of caching in snowflake
    Explore the concept of data clustering in snowflake
    Recognize the purpose of materialized views in snowflake
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 6s
    In this video, you'll be introduced to the key concepts that will be covered in this course. FREE ACCESS
  • 4m 35s
    In this video, you'll learn about Snowflake's performance considerations, including performance improvement techniques. FREE ACCESS
  • Locked
    3.  Virtual Warehouse Configuration – Part I
    3m
    In this video, you'll learn about the scaling up and scaling down capabilities of Snowflake. FREE ACCESS
  • Locked
    4.  Virtual Warehouse Configuration – Part II
    4m 16s
    In this video, you'll learn about scaling out using multi-cluster virtual warehouses and the standard and economy scaling policies. FREE ACCESS
  • Locked
    5.  Caching in Snowflake
    4m 41s
    In this video, you'll learn about the concept of caching in Snowflake. FREE ACCESS
  • Locked
    6.  Micro-partitions and Data Clustering
    4m 7s
    In this video, you'll learn about the concept of data clustering in Snowflake. FREE ACCESS
  • Locked
    7.  Materialized Views
    3m 54s
    In this video, you'll learn about the purpose of materialized views in Snowflake. FREE ACCESS
  • Locked
    8.  Course Summary
    1m 22s
    Reflect on what you’ve learned. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Snowflake: Data Loading and Stages
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)
Course Snowflake: Continuous Data Protection
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Journey Data Analytics with Snowflake
Rating 4.7 of 15 users Rating 4.7 of 15 users (15)