The Execute DDL action runs a Data Definition Language (DDL) statement on a Snowflake database and returns the execution result.

Overview

Users create, manipulate, and modify contents in a Snowflake table using DDL statements. The Execute DDL action runs the created DDL statements and returns the modified results in the response data.

Note: Ensure that you add and configure the Connect action before proceeding with configuring the Execute DDL 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.
DDL Statement
Specifies the DDL statement for the action to execute. You can also specify the statement using a string variable.
Assign output to a variable
Specifies the variable that stores the execution 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.