In this article
Table of Contents | ||||
---|---|---|---|---|
|
...
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| Multiple SQL queries. |
Output | Document |
|
| The incoming SQL queries with the MINUS operator included. |
Snap Settings
Info | ||
---|---|---|
| ||
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 Minus | Exclude Common Records | ||||||||||
Get preview data | Checkbox |
| Not selected | Selected | ||||||||||
Retain duplicates (Databricks Lakehouse Platform only) | Checkbox | If 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 selected | Selected |
...