The Snowflake Update Activity

General

Use this activity to run the update SQL statements on the Snowflake database. You can update multiple rows in the database. This activity returns the information in the form of total rows affected.

The General tab contains the following fields.

Field Module Property Description
Name No Specify the name to be displayed as the label for the activity in the process.
Snowflake Connection Resource 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 Click to select an entity. The entities downloaded in Snowflake JDBC Connection shared resource's Schema tab is available for selection.
Time Out 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.
Values Yes Displays the fields that must be a part of the SET clause for an update SQL statement. By default Values column is selected for all the fields.
Parameter Yes Displays the fields that must be part of the WHERE clause of an update SQL statement.

Input

All the fields in the SQL Builder tab that have Values and Parameter columns 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: The columns which are not mapped are ignored automatically from the SQL query.

Output

The Output tab displays the rowsAffected field which holds the count of number of rows affected after the Snowflake Update 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.