Integration Service Activities

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

• Query - Provide a valid Snowflake query.
  Important:

  • 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.
  • The Snowflake VARIANT data type is not supported.
  • For security reasons, some patterns and commands are not supported. For a complete list, see the Query restrictions section below.

Manage Properties

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.

• SQL Comments - The following comment patterns are blocked anywhere in the query, including within string values:
  • # (hash/pound symbol)
  • -- (double dash)
  • /* and */ (block comment delimiters)
  • /**/ (empty block comments)
• File References - Queries cannot contain:
  • file: URL patterns

  • LOAD commands

• DDL Commands - Data Definition Language operations are not supported:

  • CREATE

  • ALTER

  • DROP

• DML Restrictions for executeQuery - When using the executeQuery endpoint, only SELECT statements are supported. The following are blocked:

  • INSERT

  • UPDATE

  • DELETE

  • MERGE

  • TRUNCATE