Snowflake Query Activity
Use this activity to run the query SQL statements on the Snowflake data warehouse.
General
The General tab contains the following fields.
| Field | Module Property? | Visual Diff? | Description |
|---|---|---|---|
| Name | No | Yes | Specify the name to be displayed as the label for the activity in the process. |
| Snowflake Connection Resource | Yes | Yes | Click the Create New Process Property icon to select a Snowflake JDBC Connection shared resource. If no matching Snowflake JDBC Connection shared resource is found, click
Create Shared Resource to create one. For more details, see
Creating and Configuring the Snowflake JDBC Connection Resource.
|
| Entity | No | Yes | Click the Browse resource to select an entity. The entity includes database tables and database views. The entities downloaded in the Snowflake JDBC Connection shared resource
Schema tab are available for selection.
|
| Maximum Rows | Yes | Yes | The maximum number of rows to retrieve. To retrieve all rows, specify 0. The default value is 100. |
| Time Out | Yes | Yes | Defines activity timeout in seconds. The default value is 100 seconds. |
Description
On the Description tab, provide a short description for the activity.
SQL Builder
You can use the SQL Builder tab to configure SQL queries.
| Field | Editable | Description |
|---|---|---|
| SQL | No | Opens the Eclipse SQL Builder. For more information about using the SQL Query Builder to visually build queries, see the Eclipse documentation. |
| Fetch | No | Creates the output schema based on the SQL query. If the SQL query does not conform to the Snowflake syntax, a compilation error occurs on clicking the Fetch button. |
| Statement | Yes | The SQL SELECT statement to be performed on the database. You can use an SQL Builder wizard to build the query for the Snowflake database. |
| Prepared Statement | Yes |
The Prepared Statement contains the Field Name and the Data Type fields. You can provide the value for all the fields defined in the Prepared Statement table that are displayed on the Input tab of the activity. Each prepared statement corresponds to the question mark in the same position in the SQL statement. That is, the first prepared statement in the list corresponds to the first question mark, the second prepared statement in the list corresponds to the second question mark, and so on. Ensure that the parameters in this field correctly correspond to the statement. Note: The field names added in the Prepared Statement field must be compliant with the XML element naming standard. For invalid names, an error occurs when you run the application.
|
| Parameter | Yes | Displays the fields that must be part of the WHERE clause of a query SQL statement. |
Advanced
This tab has the following fields:
| Field | Module Property? | Visual Diff? | Description |
|---|---|---|---|
| Override Database Name | Yes | Yes | Overrides the Database name specified in snowflakejdbcResource. |
| Override Schema Name | Yes | Yes | Overrides the Schema name specified in snowflakejdbcResource. |
| Interpret Empty String as NULL | Yes | Yes | If this checkbox is selected, the empty string is interpreted as a NULL value. |
Input
All the fields in the SQL Builder tab that have Parameter column selected are a part of the Input tab. The Input tab displays the input schema of the activity as a tree structure. The information in the schema depends on the fields selected on the SQL Builder tab.
Output
All the fields in the SQL Builder tab that have the Selected column selected are a part of the Output tab. Output of Snowflake Query activity holds multiple records. The Output tab displays the output schema of the activity as a tree structure. The output is read-only. The information in the schema depends on the fields selected on the SQL Builder tab.