Forum Discussion
HamidBee
Power Participant
Power ParticipantWhen to Use Pre-Copy Script vs. Source Query in Copy Activity?
Hello everyone, I’m trying to get a better understanding of the Pre-Copy Script option in Microsoft Fabric's Copy Activity. Given that we already have the option to use a query to p...
The difference between the query and the pre-copy script is that the query is performed on the source, while the pre-copy script is performed on the destination. You can use both within the same activity. You could for example delete all the records from the destination before you write new rows from the source to the destination that you've selected with your query.
KGU_16031986
Advocate I
Advocate IPrecopy command and coppy command on the destination runs in a same session or in two sessions?
Are there any chances we loose data when pre-copy success and copy command fail ?