# Snowflake

> A warehouse in the cloud. You pay for the space and the work apart.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Snowflake Data Cloud, Snowflake Data Warehouse

## Think of it like

It is like a library where you rent reading rooms by the hour. The books stay put. You pay for the rooms you use.

## Definition

Snowflake is a cloud data warehouse sold as a service. It keeps storage and computing apart. Your data sits in one shared store. You start compute clusters, called virtual warehouses, to run queries on it. Each one can be sized up, sized down or paused, and you pay for the time it runs.

## Example

A team runs reports on a small warehouse and a big monthly job on a large one. Both read the same tables at once.

## Example code

```sql
CREATE WAREHOUSE reporting_wh
  WAREHOUSE_SIZE = 'XSMALL'
  AUTO_SUSPEND = 60;
```

A small compute cluster that pauses itself after 60 idle seconds.

## Why it matters

Teams can query the same data without slowing each other down. A paused warehouse costs nothing for compute.

## Common mistake

Leaving a big warehouse running all night. The bill grows by the second, even when no one queries it.

## Three principles

- **Storage apart.** Data sits in one shared store.
- **Compute apart.** Virtual warehouses run the queries.
- **Pay per use.** Paused compute costs nothing.

## Related terms

- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Google BigQuery](https://learn.benibix.com/term/data/bigquery)
- [Amazon Redshift](https://learn.benibix.com/term/data/amazon-redshift)
- [Time Travel Query](https://learn.benibix.com/term/data/time-travel)
- [Snowflake Virtual Warehouse](https://learn.benibix.com/term/data/snowflake-virtual-warehouse)
- [Snowpark](https://learn.benibix.com/term/data/snowpark)
- [Zero-Copy Clone](https://learn.benibix.com/term/data/zero-copy-clone)

## Told apart from

- [Snowflake vs Snowflake Schema](https://learn.benibix.com/compare/snowflake-vs-snowflake-schema): People think the snowflake schema is named after the Snowflake product. It is not. The schema is a way to lay out tables, and the name comes from its branching shape. Snowflake is a cloud data warehouse. You can build a star or a snowflake schema in it.

---

Source: https://learn.benibix.com/term/data/snowflake
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
