How do I create a Merge Key for Azure Synapse SQL Connector?

We have a large dataset that we update daily, we want to change from the "Replace" update setting to the "Merge" setting. It asks for a "Merge Key Location" - the input field just continuously tries to load something

How do we switch to the Merge update method?

Answers