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?