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

PreviousVIEWNextYAML placeholders

Last updated