Create Snowflake warehouse

The Create Snowflake warehouse job entry creates a new Snowflake virtual warehouse from within a PDI job.

You can use it to define the warehouse size, scaling behavior, auto-suspend/resume settings, and other properties. If your requirements change later, you can adjust the warehouse using the Modify Snowflake warehouse job entry.

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 Create Snowflake warehouse entry on the canvas. You can customize the name or leave it as the default.

Options

The Create Snowflake warehouse entry includes several options for creating a virtual warehouse and defining its attributes.

Create Snowflake warehouse

Database connection and warehouse

Specify the Snowflake database connection and identify the virtual warehouse you want to create.

Option	Description
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.
Warehouse name	Specify a valid identifier for the virtual warehouse you are creating. The name must be unique in your Snowflake account.
Warehouse comment	Specify a description or other information to help identify the warehouse and its purpose.

Warehouse settings

The Auto suspend (in seconds) option helps ensure that the warehouse stops consuming credits when it is inactive. The Auto resume warehouse option controls whether the warehouse starts automatically when needed.

For information about warehouse sizes, scaling policies, and resource monitor permissions, see the Snowflake documentation.

Option	Description
Warehouse size	Select a size for this new virtual warehouse: X-Small (default) Small Medium Large X-Large 2X-Large 3X-Large 4X-Large Important: The size affects both 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.

Option	Description
Minimum cluster count	If you are creating a multi-cluster warehouse, 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

Use these settings to define the initial state of the warehouse after creation and what the job should do if the warehouse already exists.

Option	Description
If warehouse exists	Select what the job should do if the warehouse already exists: Fail (default): Stop the job. No warehouse is created. Replace: Replace the existing warehouse and continue the job. Continue: Continue the job without creating a warehouse.
Initially suspend warehouse after creation	Specify whether the warehouse is created in the suspended state: Cleared (default): start the warehouse after creation. Selected: suspend the warehouse after creation.