Snowflake Architecture

Introduction to Snowflake

Palak Raina

Senior Data Engineer

Shared-Disk and Shared-Nothing Architecture

shared-disk.png

shared-nothing.png

Introduction to Snowflake

Decoupling Storage & Compute

 

  • Efficient data storage.
  • Independent data processing.
  • Components operate without interdependence.

 

Benefits

  • Enhanced scalability.
  • Faster data processing and response.
  • Cost-effective operations.
Introduction to Snowflake

Snowflake Architecture

Snowflake architecture diagram showing three layers:Storage Layer, Compute/Query Processing Layer and Cloud Services Layer

Introduction to Snowflake

Storage Layer

  • Columnar storage

    • Efficient data retrieval
    • Analysis
  • Optimized
  • Compressed
  • Tables, schemas, databases

Storage Layer diagram

Introduction to Snowflake

Compute Layer

  • Query execution
  • Virtual warehouses

Compute Layer Diagram

Introduction to Snowflake

Compute Layer - virtual warehouse

 

  • Scalability
  • Performance
  • Cost-effectiveness
  • Different sizes: XS, S, M, L, XL
Introduction to Snowflake

Cloud Services Layer

  • Infrastructure management
  • Query Optimization
  • Authentication
  • Access control
  • Security

Cloud Services Layer diagram

Introduction to Snowflake

Let's practice!

Introduction to Snowflake

Preparing Video For Download...