Delete Snowflake warehouse

The Delete Snowflake warehouse job entry drops a virtual warehouse from your Snowflake environment.

Dropping unused virtual warehouses can help you keep your Snowflake environment organized.

When you drop a warehouse, Snowflake immediately halts processing of all SQL queries and statements, which stops consumption of additional credits. If you want to prevent in-progress actions from terminating, suspend processing first using Stop Snowflake warehouse.

A dropped warehouse cannot be recovered. You can only recreate it.

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

For more information about using Snowflake, see the Snowflake documentation.

General

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

Options

Delete 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	Select the virtual warehouse to delete.
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.