Snowflake Performance: Scaling and Autoscaling Warehouses

Snowflake 2024    |    Intermediate
  • 11 videos | 1h 39m 58s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
By understanding Snowflake's warehouse configurations and scaling, you can optimize performance and ensure efficient resource utilization in Snowflake. In this course, you will discover the features and architecture of Snowflake, gaining a foundational understanding of how it operates as a cloud data platform. Then you will explore the different editions of Snowflake and their billing structures, helping you make informed decisions about which version best fits your organizational needs. Next, you will learn how to choose between resizing warehouses and multi-cluster warehouses within Snowflake. You will focus on creating warehouses and selecting appropriate configurations to optimize performance and cost. You will also find out how to scale up warehouses to handle increasing workloads, ensuring efficient data processing. You will investigate advanced topics such as multi-cluster warehouses and their modes of operation and examine how to dynamically adjust resources based on workload demands, leading to cost efficiency and improved performance. Finally, you will use resource monitors to effectively track and manage warehouse usage, ensuring optimal utilization without unnecessary costs.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline the defining aspects of snowflake and analyze the three layers in snowflake architecture
    Analyze the different editions and the pricing model of snowflake
    Provide an overview of the snowflake editions and contrast the price of credits across platforms and regions
    Choose between resizing warehouses and multi-cluster warehouses
    Create a new compute warehouse and explore warehouse settings
  • Evaluate the benefits of large compute warehouses for more complex queries and greater concurrency
    Configure a multi-cluster warehouse in auto-scale mode with an economy scaling policy
    Contrast the performance of auto-scale mode clusters with standard scaling and maximized mode clusters
    Utilize snowflake resource monitors to take action when usage of credits exceeds certain thresholds
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 14s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 11m 21s
    After completing this video, you will be able to outline the defining aspects of Snowflake and analyze the three layers in Snowflake architecture. FREE ACCESS
  • Locked
    3.  Editions and Billing in Snowflake
    11m 8s
    In this video, we will analyze the different editions and the pricing model of Snowflake. FREE ACCESS
  • Locked
    4.  Navigating Snowflake Editions and Pricing
    12m 33s
    Upon completion of this video, you will be able to provide an overview of the Snowflake editions and contrast the price of credits across platforms and regions. FREE ACCESS
  • Locked
    5.  Types and Settings of Warehouses
    9m 35s
    In this video, find out how to choose between resizing warehouses and multi-cluster warehouses. FREE ACCESS
  • Locked
    6.  Creating Warehouses
    9m 26s
    Learn how to create a new compute warehouse and explore warehouse settings. FREE ACCESS
  • Locked
    7.  Scaling up Warehouses
    11m 13s
    During this video, discover how to evaluate the benefits of large compute warehouses for more complex queries and greater concurrency. FREE ACCESS
  • Locked
    8.  Using Auto-scale Mode with Economy Scaling
    10m 1s
    Find out how to configure a multi-cluster warehouse in auto-scale mode with an economy scaling policy. FREE ACCESS
  • Locked
    9.  Using Standard Scaling and Maximized Mode Clusters
    8m 50s
    In this video, you will learn how to contrast the performance of auto-scale mode clusters with standard scaling and maximized mode clusters. FREE ACCESS
  • Locked
    10.  Using Resource Monitors
    13m 2s
    Discover how to utilize Snowflake Resource Monitors to take action when usage of credits exceeds certain thresholds. FREE ACCESS
  • Locked
    11.  Course Summary
    1m 34s
    In this video, we will summarize the key concepts covered in this course. 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 Prompt Engineering for Data: Basic Data Manipulation Using Generative AI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Database Performance at Scale: A Practical Guide
Course GCP Data Engineer Pro: BigQuery Data Warehouse
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)