Input/Output	Type of View	Number of Views	Examples of Upstream and Downstream Snaps	Description
Input	Document	Min: 1 Max: 1	ELT Select ELT Filter ELT Transform	A document containing the SQL query that yields the data required to perform the conditional (unary or binary) operations.
Output	Document	Min: 1 Max: 1	ELT Select ELT Filter ELT Transform ELT Insert Select	A document containing the incremental SQL query that includes the conditional functions defined in the Snap.

Snap Settings

Noteinfo

Click the = (Expression) button in the Snap's configuration, if available, to define the corresponding field value using expression language and Pipeline parameters.
- You can use the SQL Expressions and Functions supported for ELT for this purpose. This list is common to all target CDWs supported. You can also use other expressions/functions that your target CDW supports.
Field names marked with an asterisk ( * ) in the table below are mandatory.

...

Versions Compared