Explanation:
MERGE INTO supports matching source rows to target rows and inserting only unmatched rows. This is appropriate when duplicate records must be avoided. Managed versus external status and the source format do not by themselves determine whether MERGE is needed.
No comments yet.
When should a data engineer use MERGE INTO instead of INSERT INTO?
A
When the location of the data needs to be changed
B
When the target table is an external table
C
When the source is not a Delta table
D
When the target table cannot contain duplicate records