Versions Compared


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


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


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


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

Snap Settings

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

Multiexcerpt include macro
pageELT Intersect


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