❄️

Snowflake

Snowflake is a cloud data warehouse built around separating storage from compute, maintained by Snowflake Inc. It sits around #18 in real-world usage (roughly 4.1%) — you can scale query power up and down independently of how much data you store, popular for large enterprise analytics teams.

📌 Quick facts
Type: Cloud data warehouse
Made by: Snowflake Inc.
License: Proprietary/managed-cloud (usage-based pricing)
Hosting: Fully managed, multi-cloud (AWS/Azure/GCP)
Primary use case: Enterprise-scale data warehousing and business analytics

Core concepts & example

Snowflake uses standard ANSI SQL with the addition of "virtual warehouses" — independently-scalable compute clusters that read from the same underlying storage:

USE WAREHOUSE analytics_wh; -- pick which compute cluster runs this query

SELECT region, SUM(revenue) AS total_revenue
FROM sales
GROUP BY region
ORDER BY total_revenue DESC;

Getting started

Snowflake is accessed entirely through its web console, CLI, or SDKs — there's no local install, only a free trial account:

# Snowflake CLI (SnowSQL)
snowsql -a your_account -u your_username

🎯 Best for: enterprise-scale data warehousing and business analytics teams that need independently scalable compute.