In this article

Overview

Use this Snap to combine the incoming SQL queries and add a UNION ALL or UNION DISTINCT SQL operator between them. The UNION ALL SQL operator is used to combine the result of two or more SQL SELECT statements. The UNION DISTINCT SQL operator does the same and removes duplicate rows.

This Snap also allows you to preview the result of the output query. You can validate the modified query using this preview functionality.

SnapLogic Documentation > ELT Union > ELTUnion_SnapConfiguration.png

Provide a functional overview of the Snap. Do not mention anything about the Snap's internal technology or techniques. The user should be able to understand what the Snap. Include a screenshot of a well-configured Snap 600px.

Prerequisites

Two or more SQL SELECT queries.
The source tables in the SQL SELECT statements must have the same number of columns.
The column data types of each of the source tables also need to match.

Limitation

Known Issues

Snap Input and Output

Type of view: Document/Binary/Both. Get number of views from the Views tab in the Snap. List at least three compatible Snaps in each category. Provide a brief of the input/output required. If the input/output is optional then preface the description with "Optional." For example, "Transaction data complying with the Orderful schema as a JSON document."

Input/Output	Type of View	Number of Views	Examples of Upstream and Downstream Snaps	Description
Input	Document	Min: 2 Max: No limit	ELT Select ELT Intersect ELT Copy	The SQL SELECT statements that you want to combine with a UNION DISTINCT or UNION ALL operator.
Output	Document	Min: 1 Max: 1	ELT Insert-Select ELT Limit	The modified SQL query with a UNION DISTINCT or UNION ALL operator.

Snap Settings

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
Label	String		ELT Union	Combine Employee Records
Eliminate duplicates	Check box	Select to use the UNION DISTINCT operator instead of the UNION ALL operator.	Not selected	Selected
Get preview data	Check box		Not selected	Selected

Troubleshooting

None.

Examples

Download this Pipeline.

Downloads

Download and import the Pipeline into SnapLogic.
Configure Snap accounts as applicable.
Provide Pipeline parameters as applicable.

Edit the Excerpt Include macro below to link to the Snap Pack page for this Snap page. Ensure that the heading Snap Pack History is not within the Snap Pack's history Excerpt.