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

ravimohan911

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?

MarkSnodgrass

Are you using the big integer data type? It appears that Domo has issue with that type for MySQL merges. It may be the same for Azure. See this older discussion.

https://dojo.domo.com/discussion/43995/merge-key-location-not-working

jaeW_at_Onyx

@ravimohan911 i would also recommend checking in with your CSM. UPSERT is a feature switch that has to be enabled. Depending on the age of your instance, it may or may not automatically be enabled.