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?

Practice it on a real question

All SELECT & filtering questions

Practice on your iPhone

Query Dojo for iPhone has 85 interview questions, timed mock interviews and a tile builder, so you can write queries without a keyboard.

Get the app