|Parameter Name||Data Type||Description||Default Value||Example|
|ELT Intersect||Common Records|
|Get preview data||Checkbox|
|Retain duplicates (Databricks Lakehouse Platform only)||Checkbox||When |
Select this checkbox (when your target database is Databricks Lakehouse Platform, select this checkbox
) 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.
Let us connect the Snaps (that produce these two datasets) to the two input views of the ELT Intersect Snap. Notice that we have selected the Retain Duplicates (Databricks Lakehouse Platform only) check box to make sure ensure that the Snap includes duplicate matching records in its output view.