Overview of Snowflake Data Warehouse

Snowflake is a fully-managed Cloud MPP data warehouse that enables users to spin up as many virtual warehouses as they need to parallelize and isolate the performance of individual queries. Snowflake runs in the AWS cloud and separates storage and compute, meaning that many warehouses can all access the same data source simultaneously, enabling very high concurrency. Snowflake allows users to interact with its data warehouse through a web browser, the command line, an analytics platform, or via Snowflake’s ODBC, JDBC, or other supported drivers.

Snowflake is a fairly new entrant in the data warehouse market, launched by a group of data warehousing experts in 2014, after two years in stealth mode. Its unique architecture was well-described in a SIGMOD 2016 paper.