Input/Output	Type of View	Number of Views	Examples of Upstream and Downstream Snaps	Description
Input	Document	Min: 1 Max: 1	ELT Insert Select ELT Merge Into ELT Copy	The SQL query that resolves to a document containing the list of arguments for the COALESCE operation.
Output	Document	Min: 1 Max: 1	ELT Select ELT Filter ELT Join ELT Insert Select	The modified SQL query with the COALESCE operation included.

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