Properties
string
required
A human-readable name for the component.
drop-down
required
The Snowflake warehouse. The special value
[Environment Default] uses the warehouse defined in the environment. Read Snowflake’s Virtual Warehouses documentation to learn more.drop-down
required
Select the operation to perform on the Snowflake warehouse:
- Abort All Queries: Aborts all the queries currently running or scheduled on a warehouse.
- Rename To: Rename this warehouse.
- Resume: Choose to bring back a suspended warehouse to a usable state by provisioning compute resources.
- Set: Alters the properties of a warehouse.
- Suspend: Choose to remove all compute nodes from a warehouse. Additionally, puts the warehouse into a SUSPENDED state.
- Unset: Resets the current value of a warehouse property back to its default value.
string
required
The new name for the Snowflake warehouse. This property is only relevant when Command type is set to Rename To.
object selector
required
Select properties to change. This property is only available when
Command type is Set. The available properties are as follows:- MAX_CONCURRENCY_LEVEL: Specifies the maximum number of SQL statements (queries, DDL, DML, etc.) a warehouse cluster can execute concurrently. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is 8.
- STATEMENT_QUEUED_TIMEOUT_IN_SECONDS: Specifies the time, in seconds, an SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is 0 (disabled, so statements can queue indefinitely).
- STATEMENT_TIMEOUT_IN_SECONDS: Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is 172800 seconds (2 days).
- COMMENT: Adds a comment or overwrites the existing comment for the warehouse. If you don’t select this property, the warehouse’s existing comment is left unchanged. For a warehouse where a comment was never set, Snowflake’s default is no comment.
- WAREHOUSE_SIZE: Choose a warehouse size. If you don’t select this property, the warehouse’s current size is left unchanged. For a warehouse created without specifying a size, Snowflake’s default is X-Small.
- MAX_CLUSTER_COUNT: The number of available clusters, from 1 to 10. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is 1.
- MIN_CLUSTER_COUNT: Optionally set to a value from 1 to the value set for MAX_CLUSTER_COUNT. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is 1.
- AUTO_SUSPEND: Specifies the number of seconds of inactivity after which the warehouse is automatically suspended. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is 600 seconds (10 minutes).
- AUTO_RESUME: If auto-resume is enabled (set to TRUE), the warehouse is automatically resumed when any statement that requires a warehouse is submitted to the current warehouse for the session. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is TRUE.
- RESOURCE_MONITOR: Sets the warehouse to use a resource monitor. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse where a resource monitor was never assigned, Snowflake’s default is no resource monitor.
- SCALING_POLICY: Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in auto-scale mode. Set to STANDARD or ECONOMY. If you don’t select this property, the warehouse’s current value is left unchanged. For a warehouse created without specifying this value, Snowflake’s default is Standard.