The Snowflake Query Activity
General
Use this activity to run the query SQL statements on the Snowflake data warehouse.
The General tab contains the following fields.
| Field | Module Property | Description |
|---|---|---|
| Name | No | Specify the name to be displayed as the label for the activity in the process. |
| Snowflake Connection Resource | Yes | Click
 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 | Click
 to select an entity. The entities downloaded in Snowflake JDBC Connection shared resource's
Schema tab is available for selection.
|
| Maximum Rows | Yes | The maximum number of rows to retrieve. To retrieve all rows, specify 0. The default value is 100. |
| Time Out | Yes | Defines activity timeout in seconds. The default value is 100 seconds. |
SQL Builder
The SQL Builder tab displays the metadata of the entity selected in the General tab.
| Field | Editable | Description |
|---|---|---|
| Field Name | No | Displays name of the column. |
| Data Type | No | Displays the data type of the column. |
| Primary Key | No | Displays if the column is a primary key. |
| Not Null | No | Displays if the column accepts null value. |
| Dimension | No | Displays the dimension of the column. |
| Selected | Yes | Displays the fields that must be part of the SELECT query of an SQL statement. By default, the Selected column is selected for all the fields. |
| Parameter | Yes | Displays the fields that must be part of the WHERE clause of a query SQL statement. |
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.