HELP::COPY DATA::APPEND MODE

[Element115]

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 solution]

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

[Anonymous]

Glad to know you were able to find answer for your query.