Versions Compared

Key

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

...

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 2
  • Max: No limit
  • ELT Select
  • ELT Aggregate
Multiple SQL queries.
Output

Document

  • Min: 1
  • Max: 1
  • ELT Unique
  • ELT Insert-Select
The incoming SQL queries with the MINUS operator included. 

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
Excerpt Include
File Writer
File Writer
nopaneltrue
ELT MinusExclude Common Records
Get preview dataCheckbox

Multiexcerpt include macro
namegetpreviewdata
pageELT Intersect

Info

In Azure Synapse and BigQuery, this Snap uses EXCEPT operation unlike in Redshift and Snowflake, wherein the Snap uses MINUS operation.


Output preview in Azure Synapse


Not selectedSelected
Retain duplicates (Databricks Lakehouse Platform only)CheckboxIf your target database is a Databricks Lakehouse Platform instance, select this checkbox to indicate that the Snap can include duplicate entries in its output. Else (by default), the Snap retrieves only unique records from the MINUS/EXCEPT operation result.Not selectedSelected

...