With the "upsert option" , should I expect to see "0" as "Rows Written" in a copy activity result summary?
My situation is this: The source and sink table columns are not exactly the same but the Key columns to tell it how to know the write behavior are correct.
I have tested and made sure that it does actually do insert or update based on the data I give to it BUT what I don't understand is if I make ZERO changes and just keep running the pipeline , why does it not show "zero" in the Rows Written summary?
Upsert only updates the record if it is present in both source and target tables and inserts if not present in the target and present in source.
Not sure why in the above answer it was mentioned that "it is modifying all records irrespective of the changes in data." and it is not true.