The Execute stored procedure action runs a procedure stored in Snowflake and returns the result.

Overview

The Execute stored procedure action uses the name of the specified stored procedure to execute the procedure. For procedures that contain dynamic values, you can use the Input parameters option to specify the parameters and their values.

Note: Ensure that you add and configure the Connect action before proceeding with configuring the Execute stored procedure 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.
Procedure name
Specifies the name of the stored procedure. You can also specify the procedure name using a string variable.
Input parameters (optional)
Specifies the input parameter values that are required for a procedure containing dynamic values. You can choose one of the following options to specify the parameters:
  • Dictionary: Specify each parameter key and its value as an individual entry using the Add option.
  • Variable: Select the dictionary variable that contains all the parameter keys and their values using the Insert a value option.
Assign output to a variable
Specifies the variable that stores the stored procedure result. You can choose one of the following options:
  • Multiple variables: Create and specify individual variables to store specific response data.

    Use the Add variable mapping option to specify the key and corresponding variable type to store the specific response data.

  • Dictionary: Create and specify a dictionary variable to store the entire response data using the Create variable option.