What is Snowflake?

Snowflake is a cloud-based data warehouse platform where organisations store, manage, and analyse very large amounts of data.

A regular database handles today's operational data current orders, active customers. A data warehouse stores historical data at massive scale and runs complex analytical queries across it "what were sales trends across all regions for the last five years?"

What makes Snowflake distinctive:

• Runs entirely in the cloud (AWS, Google Cloud, or Azure) no hardware to manage
• Separates storage and computing scale each independently
• Multiple teams query the same data simultaneously without slowing each other down
• Supports structured data (tables) and semi-structured data (JSON)
• Pay only for what you use

Works closely with tools like dbt, Tableau, and Apache Spark.