WAREHOUSE

Config path: /warehouse.yaml

Example:

task_wh:
  size: XSMALL
  auto_suspend: 60

multi_custer_wh:
  size: SMALL
  min_cluster_count: 1
  max_cluster_count: 4
  auto_suspend: 60

Schema

• {key} (ident) - warehouse name

• {value} (dict)

  • size (str) - warehouse size

  • type (str) - warehouse type

  • min_cluster_count (int) - (default: 1)

  • max_cluster_count (int) - (default: 1)

  • scaling_policy (str) - (default: STANDARD)

  • auto_suspend (int) - number of idle seconds before warehouse is automatically suspended (default: 60)

  • resource_monitor (ident) - name of resource monitor managed by SnowDDL config

  • global_resource_monitor (ident) - name of resource monitor created externally

  • enable_query_acceleration (bool) - enable query acceleration service

  • query_acceleration_max_scale_factor (int) - (default: 8)

  • resource_constraint (str) - (default MEMORY_X16 for Snowpark-optimized warehouses)

  • warehouse_params (dict)

    • {key} (ident) - warehouse param name

    • {value} (bool, float, int, str) - warehouse param value

  • comment (str)

Usage notes

1. Values for size are available in CREATE WAREHOUSE documentation.

2. Scaling policy and multi-cluster warehouses require Enterprise Edition or higher.

3. resource_monitor can only be applied by user with ACCOUNTADMIN role.

4. All warehouses are created with INITIALLY_SUSPENDED and AUTO_RESUME enabled.

5. When creating Snowpark-optimized warehouse, please pay attention to resource_constraint values depending on warehouse size. Default is MEMORY_16X, which requires at least MEDIUM warehouse size. For small warehouse sizes you should set MEMORY_1X or similar constraint explicitly.

Links

• CREATE WAREHOUSE

• ALTER WAREHOUSE

• SHOW WAREHOUSES

• Parser & JSON Schema (GitHub)