Snowflake

Snowflake is a cloud-native data warehouse. It separates compute ("Virtual Warehouses") from storage, allowing them to scale independently.

When to Use

• Data Warehousing: Central repository for all business data.
• ELT Workflows: Load raw data (JSON/CSV) then Transform it via SQL.
• Data Sharing: Securely share live data tables with other companies/accounts without copying.

Quick Start (SQL)

-- Create warehouse (Compute)
CREATE WAREHOUSE my_wh WITH WAREHOUSE_SIZE = 'X-SMALL';