Overview

Use this Snap to create copies of the input SQL query from the upstream Snap as multiple streams. You can use this Snap to create multiple copies of the same query if you want to perform different operations upon it. A preview of the incoming SQL query's output is also passed to the output of this Snap's output if you selected the Get preview data check box in the upstream Snap.

Prerequisites

None.

Limitation

Known Issues

Snap Input and Output

Input/Output	Type of View	Number of Views	Examples of Upstream and Downstream Snaps	Description

Input/Output	Type of View	Number of Views	Examples of Upstream and Downstream Snaps	Description
Input	Document	Min: 1 Max: 1	ELT Select ELT Aggregate	The SQL query to replicate.
Output	Document	Min: 2 Max: No limit	ELT Join ELT Merge Into	Multiple copies of the input SQL query and the optional preview data (if present).

Snap Settings

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.

Parameter Name	Data Type	Description	Default Value	Example

Parameter Name

Data Type

Description

Default Value

Example

Label

String

ELT Copy

Select Copy

Troubleshooting