Execute Any Query Asynchronously

Description

Executes any query asynchronously, including select, insert, update, and even stored procedures.

Project compatibility

Windows | Cross-platform

Configuration

• Connection ID - The connection established in Integration Service. Access the dropdown menu to choose, add, or manage connections.

• Query - Provide a valid Snowflake query.
  Note: To retrieve the status of asynchronous queries, use Get Asynchronous Query Execution Status. If the status is successful, use Get Asynchronous Query Execution Results. You can use the Query ID from the output to generate an output schema while using Get Asynchronous Query Execution Results.

Manage Properties

Use the Manage Properties wizard to configure or use any of the object's standard or custom fields. You can select fields to add them to the activity canvas. The added standard or custom fields are available in the Properties panel (in Studio Desktop) or under Show additional properties (in Studio Web).

Additional properties

• Query tag - The query tags are labels that you can attach to each individual query or group of queries to help organize and categorize them for tracking and reporting purposes. Use the available dropdown list to select a tag. This field supports String type input.

Output

• Query ID - The query statement’s unique execution ID. Automatically generated output variable.