Forum Discussion
Copy data activity not overwriting
After spending 2 hours trying to understand why my ID has duplicates, I found out that records are duplicated in my LAKEHOUSE copy pipeline which I used the copy assitant to generate. Then I tried to use both append and overwrite to see if that fixes the issues, and it didn't.
Thank you for providing this workaround for what is clearly a bug! I wonder how anyone would be able to know this!
I have tried it, and I am not sure why, but after adding overwrite to dynamic content, it threw an error.
I ended up creating a notebook to purge tables. Probably that is the way that it was intended to happen (still the question on why Overwrite option exits in data pipeline copy process.
During the MS Fabric Conference (It was great, and if you didn't join one of these yet, please make sure you do!), I tested this with a MS Data Factory person, and the overwrite worked well! It could be something temporary that happened in August, and now in September it worked fine as expected, overwriting and not appending.
This message prompted me to retest this quickly, and it does appear that the bug has been fixed.
