Extras · Lesson 4 of 22

Snowflake - Cloud Data Warehouse

Snowflake is a cloud-native data warehouse used by thousands of companies.

Key features:

  • Separates compute from storage (scale independently)
  • Pay only for what you use
  • No infrastructure to manage
  • Handles massive datasets

Snowflake SQL is ANSI-standard with extensions:

  • FLATTEN() - expands JSON arrays
  • VARIANT - stores semi-structured data
  • Time Travel - query historical data
  • Zero-copy cloning

Common at: Netflix, DoorDash, Capital One, and many startups.

Your SQL skills transfer directly to Snowflake!

Check your understanding

What makes Snowflake's architecture unique?