Execute Query

Description

This activity executes the user-specified query on the specified connection.

Input

Files in the connection

Output

Data or file

Configuration Fields

Connection

Specifies the connection on which the query needs to be applied.

Query

The SQL query to perform the task on the data source files.

Save As file When enabled

1. Saves the output in a file.
2. Renders more configuration fields
   • Secret Key Key to encrypt the file.
   • File pattern Pattern for naming the files generated by the query.
   • Sheetname Sheet name in the file to store the query.
   • File Template for the file to be created.
   • Sheet name Name of the sheet within the template.
   • Split by column Column by which the query result should be split.
   • Starting row Row from which the query result starts.
   • Starting column Column from which the query result starts.

Sample Input

Not Applicable

Sample Configuration

Sample Output

Query Result