SnowDDL
Search
K
Comment on page

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)
    • warehouse_params (dict)
      • {key} (ident) - warehouse param name
      • {value} (bool, float, int, str) - warehouse param value
    • comment (str)

Usage notes

  1. 1.
    Values for size are available in CREATE WAREHOUSE documentation.
  2. 2.
    Scaling policy and multi-cluster warehouses require Enterprise Edition or higher.
  3. 3.
    resource_monitor can only be applied by user with ACCOUNTADMIN role.
  4. 4.
    All warehouses are created with INITIALLY_SUSPENDED and AUTO_RESUME enabled.