Skip to content

Alter Warehouse

The Alter Warehouse Component allows users to edit a warehouse from within Matillion ETL for Snowflake. This component makes use of Snowflake's Alter Warehouse functionality.

Properties

Name = string

A human-readable name for the component.

Warehouse = drop-down

The Snowflake warehouse used to run the queries. The special value, [Environment Default], will use the warehouse defined in the environment. Read Overview of Warehouses to learn more.

Command Type = drop-down

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.

New Name = string

The new name for the Snowflake warehouse. This property is only available when Command Type is set to Rename To.

Properties = dual listbox

Choose one or more properties to change. This property is only available when Command Type is set to 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. The maximum concurrency is 8* the number of processors on your cloud instance. For example, an instance with two processors has a maximum concurrency of 16.
  • 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.
  • STATEMENT_TIMEOUT_IN_SECONDS: Specifies the time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.
  • COMMENT: Adds a comment or overwrites the existing comment for the warehouse.
  • WAREHOUSE_SIZE: Choose a warehouse size.
  • MAX_CLUSTER_COUNT: The number of available clusters (1, 2, 3, 4 or 5).
  • MIN_CLUSTER_COUNT: (Optionally) set to a value greater than 1.
  • AUTO_SUSPEND: If auto-suspend is enabled, the warehouse is automatically suspended if the warehouse is inactive for the specified period of time. (TRUE or FALSE)
  • AUTO_RESUME: If auto-resume is enabled, the warehouse is automatically resumed when any statement that requires a warehouse is submitted to the current warehouse for the session. (TRUE or FALSE)
  • RESOURCE_MONITOR: Sets the warehouse to use a resource monitor.
  • SCALING_POLICY: Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in auto-scale mode ("STANDARD" or "ECONOMY").
Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics
✅ ❌ ❌ ❌ ❌