Skip to content
BENIBIX Learn

Snowflake

Also known as Snowflake Data Cloud, Snowflake Data Warehouse

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

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.

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.

Why it matters

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

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 code

sql
CREATE WAREHOUSE reporting_wh
  WAREHOUSE_SIZE = 'XSMALL'
  AUTO_SUSPEND = 60;
A small compute cluster that pauses itself after 60 idle seconds.

Common mistake

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

Key takeaways

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

Compare