Warehouse settings

Pentaho Data Integration

Version

9.3.x

Audience

anonymous

Part Number

MK-95PDIA003-15

You can use these options to resize a warehouse at any time, even while the warehouse is running. These options are useful if your data operations require varying levels of computing resources.

The Auto suspend (in seconds) option verifies that when the warehouse is inactive, it stops consuming credits. The Auto resume warehouse option verifies that the warehouse starts up again as soon as it is needed.

This section also includes resource monitor and scaling policy controls that can be modified from within a PDI job. For more information about virtual warehouse sizes, scaling policies, and resource monitor permissions, see the Snowflake documentation.

Option	Description
Warehouse size	Select a size for this virtual warehouse: X-Small (default) Small Medium Large X-Large 2X-Large 3X-Large 4X-Large CAUTION: The size determines the number of servers in each cluster in the warehouse 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. The following policies are available: Standard Economy
Auto suspend (in seconds)	Specify the time, in seconds, for this virtual warehouse to auto-suspend when it becomes inactive. When a warehouse is suspended, it does not accrue any credit usage. The default value is 600 seconds (10 minutes). You must specify a number of 60 or greater because the minimum amount of time a warehouse can run before it suspends is 60 seconds (1 minute). CAUTION: If you leave this option blank, the warehouse will never suspend. Leave this option blank only if your query workloads require a continually running virtual warehouse.
Resource monitor	Select the name of an existing resource monitor to assign to this existing virtual warehouse. The default value is blank. No resource monitor will be assigned to this warehouse. Note: A resource monitor is a permissions-based control to govern the monthly credits used by the warehouse and all other warehouses to which the monitor is assigned.
Auto resume warehouse	Specify whether to automatically resume a warehouse when a SQL statement, such as QUERY, is submitted. If this check box is clear (default), the warehouse will only resume when using the Start Warehouse job entry. If this check box is selected, the warehouse will resume when a new query is submitted.