PowerExchange for Snowflake User Guide

10.5
- 10.5.6
- 10.5.4
- 10.4.1
- 10.4.0

Back Next

Query Properties

Use the

Query

tab to specify the join, filter, and sort conditions.

You can configure the following query properties for Snowflake sources:

Select Distinct

Selects unique values from the source. The Data Integration Service filters out unnecessary data when you use the Snowflake data object in a mapping.

Join

The Join expression you specify in a read operation to join data from multiple sources in a Snowflake data object.

Select the sources on the

Data Object

tab and define the join condition.

You can use the native or platform expression to join specific records:

When you configure a platform expression, in the

Tables

section, you can select the outer, inner, left, and right joins to join the tables.

In the Relationship section, define the relationship for the join:

Left Field. The column on which you want to apply the join condition.

Operator. The operators that you can use to join tables. You can select one of the following operators: =, >, >=, <, <=, !=

Right Field. The value you specify to join the tables.

When you configure a native expression, select the fields and define a join query syntax in the Join text field. You must specify only the condition and not the type of join in the query. The condition you specify in the text box for the native expression is appended to the join condition.

Filter

The filter value in a read operation. The filter specifies the WHERE clause of the SELECT statement. Use a filter to reduce the number of rows that the Data Integration Service reads from the Snowflake source. When you enter a source filter, the Integration Service adds a WHERE clause to the default query.

You can use the native or platform expression to filter specific records.

Configure the platform expression, you can specify the filter using the following fields:

Left Field. The column on which you want to apply the filter condition.

Operator. The operators that you can use to filter tables. You can select one of the following operators: =, >, >=, <, <=, !=

Right Field. The value based on which you want to filter the records.

When you configure a native expression, select the fields and define a filter query syntax in the Filter text field. The condition you specify in the text box for the native expression is appended to the filter condition.

Sort

Sorts the rows queried from the Snowflake source. The Data Integration Service adds the ports to the ORDER BY clause in the default query.

Rename Saved Search

Table of Contents

PowerExchange for Snowflake User Guide

PowerExchange for Snowflake User Guide

Query Properties

Query Properties

Select Distinct

Join

Filter

Sort