HELP::COPY DATA::APPEND MODE

Question

In the following screenshot of the Copy data settings UI, the info bubble that appears upon hovering on the Table action ---> Append radio button says:

'Append new values to existing table'

QUESTION:

Does this mean that the Copy data activity is performing an implicit incremental copy? Copy only values that are new, thus it checks the existing table in the lakehouse and copies only those values from source that are not yet in the lakehouse? Or not?

element115 · Accepted Answer

Using the SQL endpoint, I answered my own question:&nbsp; Append mode creates duplicate rows.&nbsp; So incremental load needs to be implemented by the user.

Forum Discussion

HELP::COPY DATA::APPEND MODE

2 Replies

Related content

Appending Data

Append Queries 3 different data sources

Append Table action in Data pipeline duplicates all data rows instead of appending the new rows

Unpivot data before expand/append

Append Data