Execute Select Query Synchronously

Description

Executes a select query on a Snowflake warehouse and returns the query result.

Project compatibility

Windows | Cross-platform

Configuration

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

• Select Query - Input a valid SELECT query and then click the Generate output schema button. Query example: SELECT * FROM PERSONS.
  Note: Add a valid query (without variables) to generate the schema. You can add or update variables in the query after the schema is successfully generated. See the Snowflake official documentation on query syntax.

Output

• Query results - The query results. Dynamic output based on the used query.
  Note: During design time, the query builds the output properties while running. You can then use these properties in downstream activities as input.