Versions Compared

Old Version 16

changes.mady.by.user Shilpa

Saved on

compared with

New Version 17

changes.mady.by.user Shilpa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

  • Field names marked with an asterisk ( * ) are mandatory.

  • Suggestion icon (blue star) - Suggestible fields and suggestions will be populated based on the account settings.

  • Click the = (Expression) button in the Snap's configuration, if available, to define the corresponding field value using expression language and Pipeline parameters. 

Info

SQL Functions and Expressions for ELT

You can use the SQL Expressions and Functions supported for ELT to define your Snap or Account settings with the Expression symbol = enabled, where available. This list is common to all target CDWs supported. You can also use other expressions/functions that your target CDW supports.

Field Name

Type

Description

Label*

String

The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Default Value: ELT Router for Quantity
Example: ELT RS Account

Get preview data

Checkbox

Multiexcerpt include macro
namegetpreviewdata
pageELT Intersect

Routes

Specify your conditional SQL expressions and assign them to an output view using this fieldset. Click (blue star) to add a new row. Ensure that you specify each condition in a separate row.

This fieldset consists of the following fields:

  • Conditional SQL Expression

  • Output view name

Conditional SQL Expression*

String

The Snap evaluates the expression. If the expression is true, then the input SQL is routed to the corresponding output view.

If none of the expressions meet the given conditions, then the Pipeline fails.

Default Value: None.
Example: QTY >1

Output view name

Dropdown

Select the output view that you want to route the SQL query to.

Evaluate filter condition before forwarding

Checkbox

The given input SQL will be evaluated along with the filter condition to determine if the filter condition is being satisfied.

  • If the filter condition is satisfied, then the Snap forwards the input SQL, along with filter condition, to the output view.

  • If filter condition is not satisfied, nothing will be passed and all downstream logic will be non-operational.

...

In the following example, ELT select with has the target table with the monthly sales details of the employees is connected to the ELT Router Snap to route sales details of the each employee in a different output.

...