SnowDDL
Search…
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
    • 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
    • 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.

Links

Copy link
On this page
Schema
Usage notes
Links