The Select rows action runs the specified select SQL query against a Snowflake database and returns the result set as a data table.

Overview

The Select rows action supports both static and parameterized queries. You can use parameterized queries when the statement includes dynamic values that resolve during the runtime.

Note: Ensure that you add and configure the Connect action before proceeding with configuring the Select 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.
SQL Statement
Specifies the SQL statement that contains the select query. You can choose either Without parameters or With parameters option.
Without parameters
Specifies the SQL statement that does not contain any placeholders. You can enter the statement directly or select the string variable that contains the statement in SQL Statement.
With parameters
Specifies the SQL statement that contains placeholders for dynamic values. You can enter the statement directly or select the string variable that contains the statement in SQL Statement.
Parameters
Specifies the parameters that are required for the dynamic values available in the SQL statement. This option appears when you select With parameters option. You can choose one of the following options to specify the parameters:
  • List: Specify each parameter as an individual list item with type and value using the Add option.
  • Variable: Select the list variable that contains all the parameters and their respective values using the Insert a value option.
Assign output to a variable
Specifies the table variable that stores the query result.