Open topic with navigation

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake 6.3.0

# Snowflake Update Activity

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.

## 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 the Create New Process Property icon 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 the Browse resource icon 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. The checkbox is selected if the constraints to the column in snowflake DB is marked as 'Not Null'. The checkbox is cleared if the constraints to the column in snowflake DB is not marked as 'Not Null'. This checkbox is non-editable.
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.

## Advanced

This tab has the following fields:

Field | Module Property? | Description
--- | --- | ---
Override Database Name | Yes | Overrides Database name specified in snowflakejdbcResource.
Override Schema Name | Yes | Overrides Database name specified in snowflakejdbcResource.
Interpret Empty String as NULL | Yes | If this checkbox is selected, empty string is interpreted as NULL value.
Merge | No | If this checkbox is selected and if the record does not exist, the update process inserts the record by executing the merge query.
Merge On Columns | Yes | This field is enabled only when the Merge checkbox is selected. Enter the column names on which the merge operation should be performed. For more than one column names, enter column names separated by comma. Column names are not case-sensitive.
Create Table If None Exists | Yes | This field is enabled only when the Merge checkbox is selected. If this checkbox is selected and if the table does not exist in Snowflake, the update process creates a new table based on the entity metadata downloaded at design time.

## 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.
Note: It is necessary to have input data for all columns specified in the Merge On Columns field.

## Output

The Output tab displays the rowsAffected field which holds the count of the 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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake

Copyright © 2020-2024. Cloud Software Group, Inc. All Rights Reserved.