Script Execute Snowflake Statement

Overview

Executes an SQL statement in Snowflake.

Setup

The script has the following parameters:

• RestConnection - select a valid Snowflake REST CM.
• Statement - the actual statement to be executed, it can contain variables e.g. SELECT * FROM @[User::TableNameVar].
• Warehouse - specifies a warehouse.
• Timeout - specifies the request timeout.
• ResultVar - specify a variable which will store the result JSON as string.
• WaitForResponse - specify whether you want partitions to be handled for large responses.