Skip to content
BENIBIX Learn

Snowflake Virtual Warehouse

Also known as Virtual Warehouse, Snowflake Warehouse

The compute in Snowflake that runs your queries. You pay per second while it runs.

Think of it like

It is like a team of cooks you hire by the minute. A bigger team cooks faster but costs more.

Example

A team gives its dashboards an X-Small warehouse and its nightly load a Large one. The two never slow each other down.

Why it matters

Warehouses are most of a Snowflake bill. The size and the idle time decide what you pay.

Definition

A virtual warehouse is a cluster of compute that Snowflake runs for your queries and loads. It holds no data, because the data sits in shared storage. Sizes run from X-Small to 6X-Large. X-Small uses one credit an hour, and each size up uses twice as many. Billing is per second, with a 60-second minimum each time it starts. By default it stops after 10 idle minutes and wakes when a query comes.

Example code

sql
CREATE WAREHOUSE reports_wh
  WAREHOUSE_SIZE = XSMALL
  AUTO_SUSPEND = 60
  AUTO_RESUME = TRUE;
A small warehouse that stops after 60 idle seconds and wakes on the next query.
Each compute box on the right works like a virtual warehouse. All of them read one shared store.

Common mistake

Making one big warehouse for everyone. Give the nightly load its own, so it cannot slow the dashboards.

Key takeaways

  1. 1
    Compute only. The data lives in shared storage.
  2. 2
    Doubling sizes. Each size up, twice the credits.
  3. 3
    Auto suspend. Stops when idle, wakes on demand.