Delete rows action in Snowflake package

The Delete rows action deletes rows from the specified Snowflake table using the column name in which the rows are available.

Overview

The Delete rows action removes one or more rows from a Snowflake table using the column name and the set of values to match the data in that column. The action returns the number of rows deleted as the response data.

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

Settings

The following settings are available in the Delete rows 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 name of the target table.
Primary Key Column
Specifies the name of the column that the action uses to identify the rows to delete.
Primary Key Values
Specifies the values that are available in the column identified using the Primary Key Column setting. Use one of the following option to provide the values:
  • List: Specify each value in a list with type and value. For each entry, select the value type and enter the value.
  • Variable: Specify all values in a list variable and select the variable 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 deletes from the table. You can select an existing number variable from the dropdown, or create one using the Create variable option and select it.