Modify Snowflake warehouse
You can use the Modify Snowflake warehouse job entry to change the settings of an existing Snowflake virtual warehouse.
Modifying a warehouse is useful when usage patterns change throughout the day, week, month, or year. For example, you might scale up the warehouse during ETL processing to meet service-level agreements (SLAs), then scale it back down when the ETL completes.
For more information about working with Snowflake in PDI, see PDI and Snowflake.
For more information about Snowflake warehouse settings, see the Snowflake documentation.
General
Entry name: Specify the unique name of the Modify Snowflake warehouse entry on the canvas. You can customize the name or leave it as the default.
Options
The Modify Snowflake warehouse entry includes options for selecting a warehouse and changing warehouse attributes.
Database connection and warehouse
Specify the Snowflake database connection and identify the virtual warehouse you want to modify.
Database connection
Select an existing Snowflake connection. If you do not have an existing connection, click New. If you need to modify an existing connection, click Edit.
Note: If timeout errors occur, see Snowflake timeout errors.
Use default warehouse
Select to use the Snowflake default warehouse identified in the Database connection.
Use an existing warehouse
Select to use a warehouse other than the default one. Choose the warehouse name from the list.
Warehouse settings
You can resize a warehouse at any time, even while it is running.
The Auto suspend (in seconds) setting helps ensure that an inactive warehouse stops consuming credits. The Auto resume warehouse setting controls whether the warehouse starts automatically when needed.
Warehouse size
Select a size for this virtual warehouse:
X-Small (default)
Small
Medium
Large
X-Large
2X-Large
3X-Large
4X-Large
Important: The size affects the number of servers in each cluster and the number of credits consumed while the warehouse is running.
Scaling policy
Select the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in auto-scale mode:
Standard
Economy
Auto suspend (in seconds)
Specify the time (in seconds) for the warehouse to auto-suspend when it becomes inactive. The default is 600 seconds (10 minutes).
You must specify a value of 60 or greater.
Important: If you leave this option blank, the warehouse never suspends. Leave this option blank only if your workload requires a continually running warehouse.
Resource monitor
Select an existing resource monitor to assign to this warehouse. The default is blank (no monitor).
Note: A resource monitor is a permissions-based control that governs monthly credits used by this warehouse and any other warehouses that share the monitor.
Auto resume warehouse
Specify whether to automatically resume the warehouse when a SQL statement is submitted.
Cleared (default): the warehouse resumes only when you use the Start Snowflake warehouse job entry.
Selected: the warehouse resumes automatically when a new query is submitted.
Cluster settings
The minimum and maximum cluster settings work together:
If the minimum and maximum cluster count are the same, the warehouse runs in Maximized mode.
If the minimum cluster count is less than the maximum cluster count, the warehouse runs in Auto-scale mode.
Minimum cluster count
Select the minimum number of server clusters. Valid values are 1 to 10. The default is 1. This value must be less than or equal to Maximum cluster count.
Maximum cluster count
Select the maximum number of server clusters. Valid values are 1 to 10. The default is 1. Higher values require Snowflake Enterprise Edition.
Activity settings
This setting controls what happens if the job requests a Snowflake warehouse that does not exist.
Fail if warehouse doesn't exist
Specify how the job should behave if the requested warehouse does not exist:
Selected (default): fail the job.
Cleared: continue the job and move to the next entry.
Last updated
Was this helpful?