Open topic with navigation

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake 6.3.0

# Snowflake Query Activity

Use this activity to run the query SQL statements on the Snowflake data warehouse.

Note: You must use the Date and Time data type conversion functions provided by Snowflake to create a query with the Timestamp data type.

## 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.

## Fault

The Fault tab lists exceptions that are generated by this activity.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Snowflake

Copyright © 2020-2024. Cloud Software Group, Inc. All Rights Reserved.