thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Virtual Warehouse

A named cluster of Snowflake compute resources that executes queries and DML; it can be started, stopped and resized independently.

Definition

Warehouses come in T-shirt sizes from X-Small up to 6X-Large, and each size up doubles the compute and credits per hour. They are billed per second with a 60-second minimum each time they start. Separate warehouses isolate workloads such as ETL and BI so they don't compete.

Example

CREATE WAREHOUSE bi_wh WAREHOUSE_SIZE = 'SMALL' AUTO_SUSPEND = 60 AUTO_RESUME = TRUE;

Exam tip

Scale up (a bigger size) for complex or slow queries; scale out (multi-cluster) for concurrency and queuing.

Related terms