Insert row action in Snowflake package

The Insert row action inserts one or more rows into a Snowflake database table using an insert SQL statement.

Overview

The action inserts the rows specified in the SQL statement into a Snowflake table and returns the number of rows that the action inserts as the response data.

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

Settings

The following settings are available in the Insert row 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.
SQL statement
Specifies the SQL statement that contains the code for inserting one or more rows into a table. You can create a string variable with the SQL statement as the default value 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 inserts into the table. You can select an existing number variable from the dropdown, or create one using the Create variable option and select it.