🗄️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
Definition
Example code
sql
CREATE WAREHOUSE reports_wh
WAREHOUSE_SIZE = XSMALL
AUTO_SUSPEND = 60
AUTO_RESUME = TRUE;Common mistake
Key takeaways
- 1Compute only. The data lives in shared storage.
- 2Doubling sizes. Each size up, twice the credits.
- 3Auto suspend. Stops when idle, wakes on demand.