Snowflake Architecture

Snowlake 2024    |    Intermediate
  • 8 videos | 27m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.9 of 9 users Rating 4.9 of 9 users (9)
Snowflake employs a hybrid architecture to solve the massively parallel processing problem. This architecture uses a shared-disk approach for storage but uses multiple independent compute clusters to process the data. In this course, you'll learn about traditional database architectures, Snowflake hybrid architecture, and the three layers of Snowflake architecture. You'll explore micro-partitioning and how Snowflake stores data. Finally, you'll also learn about the purpose of virtual warehouses and configuring a virtual warehouse.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify shared disk and shared nothing architectures
    Recognize the advantages of snowflake’s hybrid architecture
    Identify the layers of the snowflake architecture, with specific focus on the database storage layer
  • Identify the layers of the snowflake architecture, with specifc focus on the query processing layer of the snowflake architecture
    Explore the features of virtual warehouses in snowflake
    Explore the steps to create new virtual warehouses using the ui and using sql
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 26s
    In this video, you'll be introduced to the key concepts that will be covered in this course. FREE ACCESS
  • 4m 2s
    In this video, you'll learn about the shared disk and shared nothing architectures. FREE ACCESS
  • Locked
    3.  Snowflake’s Hybrid Architecture
    2m 9s
    In this video, you'll learn about the advantages of Snowflake's hybrid architecture. FREE ACCESS
  • Locked
    4.  Layers of Snowflake Architecture
    5m 8s
    In this video, you'll learn about the layers of the Snowflake architecture, with specific focus on the database storage layer. FREE ACCESS
  • Locked
    5.  Micro-partitioning in Snowflake
    4m 39s
    In this video, you'll learn about the query processing layer of the Snowflake architecture and the features of virtual warehouses. FREE ACCESS
  • Locked
    6.  Snowflake: Virtual Warehouses
    4m 59s
    In this video, you'll learn about the features of virtual warehouses, autoscaling for user demands, and functions like suspend and resume. FREE ACCESS
  • Locked
    7.  Configuring a Virtual Warehouse
    2m 57s
    In this video, you'll learn about the steps for creating new virtual warehouses using the user interface and using SQL. FREE ACCESS
  • Locked
    8.  Course Summary
    2m 36s
    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 Getting Started with Snowflake: Using the Snowflake Data Platform
Rating 4.7 of 400 users Rating 4.7 of 400 users (400)
Course Queries in Snowflake: Getting Started with Performance Optimizations
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
Course GCP Data Engineer Pro: Building Robust Data Structures
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)