Stop Snowflake warehouse

The Stop Snowflake warehouse job entry suspends a Snowflake virtual warehouse from PDI.

You can use this entry with Start Snowflake warehouse to limit warehouse runtime and reduce costs.

For more information about working with Snowflake in PDI, see PDI and Snowflake.

For more information about suspending warehouses, see the Snowflake documentation.

General

• Entry name: Specify the unique name of the Stop Snowflake warehouse entry on the canvas. You can customize the name or leave it as the default.

Options

Stop Snowflake warehouse dialog box

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	Specify the Snowflake virtual warehouse to stop by using one of the following methods: Use default warehouse (defined in the database connection): Suspend the default warehouse defined by your database connection. Use an existing warehouse: Suspend a warehouse that you specify.
Activity settings	Select Fail if warehouse doesn’t exist if you want the job to fail when the warehouse does not exist (default). Clear Fail if warehouse doesn’t exist if you want the job to continue and move to the next entry.