data flow sink setting

Question

In the data flow, sink activity, Delta is the "Inline dataset type"
In the settings tab of this sink activity, I see allow insert and allow upsert
What is the differnece between the two interms of the insert?
Allow insert --> allows insert
Allow upsert --> allows insert as well as update

Does this mean the two are almost the same except the update?

Answer 1

Hello @arkiboys ,
Thanks for the ask and using Microsoft Q&A platform .
I think your understanding a fairly close , Merge as they call the UPSERT and if you plan to implement both UPDATE & INSERT , UPSERT is the way to go . But In many business sceanrio if the ask is to use INSERT or UPDATE only , can use either of these .

Please do let me know how it goes .
Thanks
Himanshu

-------------------------------------------------------------------------------------------------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators