The Snowflake Delete Activity

You can use this activity to remove a single or all rows from a table in Snowflake Data warehouse.

General

The General tab contains the following fields.

Field Module Property? Visual Diff? Description
Name No Yes Specify the name to be displayed as the label for the activity in the process.
Snowflake Connection Resource Yes Yes Click to select a Snowflake JDBC Connection shared resource. If no matching Snowflake JDBC Connection shared resource is found, click Create Shared Resource to create one. For more details, see Creating and Configuring the Snowflake JDBC Connection Resource.
Entity No Yes Click to select an entity. The entities downloaded in Snowflake JDBC Connection shared resource's Schema tab is available for selection.
Time Out Yes Yes Defines activity timeout in seconds. Default value is 0, means activity timeout disabled.

Description

On the Description tab, provide a short description for the activity.

SQL Builder

The SQL Builder tab displays the metadata of the entity selected in the General tab.

Field Editable Description
Field Name No Displays name of the column.
Data Type No Displays the data type of the column.
Primary Key No Displays if the column is a primary key.
Not Null No Displays if the column accepts null value.
Dimension No Displays the dimension of the column.
Parameter Yes Displays the fields that must be part of the WHERE clause of a query SQL statement.

Advanced

This tab has the following fields:

Field Module Property? Visual Diff? Description
Override Database Name Yes Yes Overrides Database name specified in snowflakejdbcResource.
Override Schema Name Yes Yes Overrides Schema name specified in snowflakejdbcResource.
Interpret Empty String as NULL Yes Yes If this check box is selected, empty string is interpreted as NULL value.

Input

All the fields in the SQL Builder tab that have Parameter column selected are a part of the Input tab. The Input tab displays the input schema of the activity as a tree structure. The information in the schema depends on the fields selected on the SQL Builder tab.

Note: It is not mandatory to provide values for fields on the Input tab for Snowflake Delete activity. A default mapping is displayed at the ActivityInput element when the activity is created for the first time. In case the required symbol is visible, then right-click the ActivityInput element and click Show Check > Repair > Select ActivityInput field and click OK.

Output

The Output tab displays the rowsAffected field. The rowsAffected field holds the count of number of rows inserted successfully after the Snowflake Delete activity is invoked. The Output tab displays the output schema of the activity as a tree structure. The output is read-only.

Fault

The Fault tab lists exceptions that are thrown by this activity.