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.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.
Links
​CREATE WAREHOUSE​
​ALTER WAREHOUSE​
​SHOW WAREHOUSES​
​Parser & JSON Schema (GitHub)​

VIEW

Next - Basic usage (CLI + YAML)

Page

Last modified 1yr ago