Skip to main content
Version: 4

Run long query using custom SQL

The Run long query using custom SQL action enables you to execute custom SQL queries asynchronously, adhering to the configured timeout. It supports executing Data Manipulation Language (DML) statements such as INSERT, UPDATE, and DELETE, along with Data Definition Language (DDL) commands like CREATE, ALTER, and DROP.

Action Conditions​

Action condition
Description
SQL
  • Enter a valid SQL string for execution on your Snowflake instance.
  • If multiple SQL statements are provided, all will execute, but only results from the last statement will be returned. Separate each statement with a semicolon (;).
Statement countProvide the MULTI_STATEMENT_COUNT parameter, which corresponds to the number of SQL statements being submitted.