Versions Compared

Old Version 10

changes.mady.by.user Anand Vedam

Saved on

compared with

New Version Current

changes.mady.by.user Gouri Bhagchandani

Saved on

Key

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

In this article

Table of Contents
maxLevel2
absoluteUrltrue

Multiexcerpt include
templateData[]
MultiExcerptNameME_OE_ELT_Snap_Accounts
addpanelfalse
PageWithExcerptELT Aggregate

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.

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

Multiexcerpt include macro
nameME_ELT_GBQ_StandardSQL_UOI
pageELT Copy

Known Issues

Multiexcerpt include macro
nameME_ELT_KI_Underscore_Refs
pageELT Snap Pack

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
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

Info
titleSQL 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 NameData TypeDescriptionDefault ValueExample 
LabelString
Insert excerpt
File Writer
File Writer
nopaneltrue


ELT UnionCombine Employee Records
Eliminate duplicatesCheck boxSelect to use the UNION DISTINCT operator instead of the UNION ALL operator.Not selectedSelected
Get preview dataCheck box
Multiexcerpt include macro
namegetpreviewdata
pageELT Intersect
Not selectedSelected

Troubleshooting

None.

Examples

Multiexcerpt include macro
nameunioninsertselect
pageELT Insert-Select

Download this Pipeline.

Downloads

Note
titleImportant Steps to Successfully Reuse Pipelines
  1. Download and import the Pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide Pipeline parameters as applicable.

Attachments
patterns*.slp, *.zip


Insert excerpt
ELT Snap Pack
ELT Snap Pack
nopaneltrue

See Also

SnapLogic Product Glossary