WAREHOUSE
Config path: /warehouse.yaml
Example:
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
Values for
size
are available in CREATE WAREHOUSE documentation.Scaling policy and multi-cluster warehouses require Enterprise Edition or higher.
resource_monitor
can only be applied by user withACCOUNTADMIN
role.All warehouses are created with
INITIALLY_SUSPENDED
andAUTO_RESUME
enabled.
Links
Last updated