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 Merge Into
  • ELT Insert-Select
The incoming SQL queries joined with the INTERSECT operator. 

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 IntersectCommon Records
Get preview dataCheckbox

Multiexcerpt macro

Select this checkbox to include a preview of the query's output. The Snap performs limited execution and generates a data preview during Pipeline validation.

In case of ELT Pipelines, only the SQL query flows through the Snaps but not the actual source data. Hence, the preview data for a Snap is the result of executing the SQL query that the Snap has generated in the Pipeline.

The number of records displayed in the preview (upon validation) is the smaller of the following:

  • Number of records available upon execution of the SQL query generated by the Snap.

  • The value set in the Preview Data Count setting (default is 50 records).

Rendering Complex Data Types in Databricks Lakehouse Platform

Based on the data types of the fields in the input schema, the Snap renders the complex data types like map and struct as object data type and array as an array data type. It renders all other incoming data types as-is except for the values in binary fields are displayed as a base64 encoded string and as string data type.

Not selectedSelected
Retain duplicates (Databricks Lakehouse Platform only)Checkbox

Select this checkbox (when your target database is Databricks Lakehouse Platform) to include duplicate records/values, if any, that match the intersection criteria in the output data set. Else, the Snap does not retain any existing duplicate entries in the output.


This setting is ignored in case of all other supported target databases/CDWs except Databricks Lakehouse Platform.

Not selectedSelected