Snowflake
MentionedDatabase
Cloud data warehouse that separates storage from compute, built for analysing large volumes of data.
Snowflake, explained
Written by EduVerseWhat it is
Snowflake is a cloud data warehouse: a database built for analytics on large amounts of data, rather than for an app’s everyday reads and writes. You use plain SQL, and it runs as a managed service on AWS, Azure or Google Cloud, so there are no servers to look after.
Why teams use it
Storage and compute are separate: the data sits in one place, and you start “virtual warehouses” (compute clusters) in the size you need, which can suspend automatically when idle. That way an analyst’s heavy report doesn’t slow down your production database or other teams. BigQuery and Redshift are the best-known alternatives.
An example from work
You connect to Snowflake to check a reporting table and your first query fails with “No active warehouse selected in the current session”. You run USE WAREHOUSE with the warehouse your team uses for analytics, run the query again and it works.
Our own explanation, not a quote from the book.
Where it fits
Data analytics, reporting and business intelligence
Coverage in the book
Mentioned as part of the wider landscape, without in-depth coverage.
