The Update rows action updates one or more rows in a Snowflake table by using a primary key filter and a set of new column values.

Overview

The Update rows action uses the column name specified in the Primary Key Column to identify the target rows. The action then replaces the values specified in Primary Key Values with the values specified in Column values.

Note: Ensure that you add and configure the Connect action before proceeding with configuring the Update rows action as Connect action provides the authentication context for the automation session.

Settings

The following settings are available in this action:

Session name
Specifies the session name that the Connect action creates. The session name serves as the authentication context for the operation. Choose one of the two options as per the Connect settings.
  • Session name: Specify the session name directly or create a string variable for the name and select it using the Insert a value option.
  • Variable: Select an existing Snowflake session variable using the Insert a value option.
Table Name
Specifies the table name in which the action makes the update. You can also specify the table name using a string variable.
Primary Key Column
Specifies the column name that the action uses to identify the rows to update. You can also specify the primary key column name using a string variable.
Primary Key Values
Specifies the values available in the column specified in Primary Key Column that the action must replace. You can choose one of the following options to specify the values:
  • List: Specify each value as an individual list item with type and value using the Add option.
  • Variable: Select the list variable that contains all the values using the Insert a value option.
Column values
Specifies the column names and the new values that the action must update. You can choose one of the following options to specify the column values:
  • Dictionary: Specify each column name and the new value as an individual entry using the Add option.
  • Variable: Select the dictionary variable that contains all the column names and new values using the Insert a value option.
Assign output to a variable
Specifies the number variable to store the response data that contains the number of rows that the action updates. You can select an existing number variable from the dropdown, or create one using the Create variable option and select it.