Which command can be used to write data into a Delta table while avoiding the writing of duplicate records?
Which command can be used to write data into a Delta table while avoiding the writing of duplicate records?
MERGE is the correct command to use for writing data into a Delta table while avoiding the writing of duplicate records. Unlike INSERT or APPEND, which simply add records to the table, MERGE allows you to specify conditions for updating existing records and inserting new records, ensuring no duplicates are written.
Repeated, correct.