Skip to content

Warehouse

Snowflake Documentation | Snowcap CLI label: warehouse

A virtual warehouse, often referred to simply as a "warehouse", is a cluster of compute resources in Snowflake. It provides the necessary CPU, memory, and temporary storage to execute SQL SELECT statements, perform DML operations such as INSERT, UPDATE, DELETE, and manage data loading and unloading.

Examples

Python

warehouse = Warehouse(
    name="some_warehouse",
    owner="SYSADMIN",
    warehouse_type="STANDARD",
    warehouse_size="XSMALL",
    generation="2",
    resource_constraint="STANDARD_GEN_2",
    max_cluster_count=10,
    min_cluster_count=1,
    scaling_policy="STANDARD",
    auto_suspend=600,
    auto_resume=True,
    initially_suspended=False,
    resource_monitor=None,
    comment="This is a test warehouse",
    enable_query_acceleration=False,
    query_acceleration_max_scale_factor=1,
    max_concurrency_level=8,
    statement_queued_timeout_in_seconds=0,
    statement_timeout_in_seconds=172800,
    tags={"env": "test"},
)
An adaptive warehouse sets max_query_performance_level instead of warehouse_size and cluster/scaling properties: 
adaptive_warehouse = Warehouse(
    name="some_adaptive_warehouse",
    warehouse_type="ADAPTIVE",
    max_query_performance_level="LARGE",
)

YAML

warehouses:
  - name: some_warehouse
    owner: SYSADMIN
    warehouse_type: STANDARD
    warehouse_size: XSMALL
    generation: "2"
    resource_constraint: STANDARD_GEN_2
    max_cluster_count: 10
    min_cluster_count: 1
    scaling_policy: STANDARD
    auto_suspend: 600
    auto_resume: true
    initially_suspended: false
    resource_monitor: null
    comment: This is a test warehouse
    enable_query_acceleration: false
    query_acceleration_max_scale_factor: 1
    max_concurrency_level: 8
    statement_queued_timeout_in_seconds: 0
    statement_timeout_in_seconds: 172800
    tags:
      env: test
An adaptive warehouse in yaml: 
warehouses:
  - name: some_adaptive_warehouse
    warehouse_type: ADAPTIVE
    max_query_performance_level: LARGE

Fields

  • name (string, required) - The name of the warehouse.
  • owner (string) - The owner of the warehouse. Defaults to "SYSADMIN".
  • warehouse_type (string or WarehouseType) - The type of the warehouse: STANDARD, SNOWPARK-OPTIMIZED, or ADAPTIVE. Defaults to STANDARD. ADAPTIVE warehouses do not support warehouse_size, min_cluster_count, max_cluster_count, scaling_policy, auto_suspend, auto_resume, initially_suspended, enable_query_acceleration, query_acceleration_max_scale_factor, resource_constraint, or generation.
  • warehouse_size (string or WarehouseSize) - The size of the warehouse which defines the compute and storage capacity.
  • generation (string or WarehouseGeneration) - The standard warehouse generation, either "1" or "2".
  • resource_constraint (string or WarehouseResourceConstraint) - The warehouse resource constraint, either STANDARD_GEN_1/2 for standard warehouses or MEMORY_* for Snowpark-optimized warehouses.
  • max_query_performance_level (string or WarehouseSize) - The maximum size an ADAPTIVE warehouse may scale to: XSMALL, SMALL, MEDIUM, LARGE, XLARGE, XXLARGE, XXXLARGE, or X4LARGE. Only valid for ADAPTIVE warehouses; Snowflake defaults to XLARGE if omitted.
  • max_cluster_count (int) - The maximum number of clusters for the warehouse.
  • min_cluster_count (int) - The minimum number of clusters for the warehouse.
  • scaling_policy (string or WarehouseScalingPolicy) - The policy that defines how the warehouse scales.
  • auto_suspend (int) - The time in seconds of inactivity after which the warehouse is automatically suspended.
  • auto_resume (bool) - Whether the warehouse should automatically resume when queries are submitted.
  • initially_suspended (bool) - Whether the warehouse should start in a suspended state.
  • resource_monitor (string or ResourceMonitor) - The resource monitor that tracks the warehouse's credit usage and other metrics.
  • comment (string) - A comment about the warehouse.
  • enable_query_acceleration (bool) - Whether query acceleration is enabled to improve performance. If omitted, Snowflake's default applies.
  • query_acceleration_max_scale_factor (int) - The maximum scale factor for query acceleration. If omitted, Snowflake's default applies.
  • max_concurrency_level (int) - The maximum number of concurrent queries that the warehouse can handle.
  • statement_queued_timeout_in_seconds (int) - The time in seconds a statement can be queued before it times out.
  • statement_timeout_in_seconds (int) - The time in seconds a statement can run before it times out.
  • tags (dict) - Tags for the warehouse.