How do I create a Merge Key for Azure Synapse SQL Connector?
ravimohan911
Montréal ⚪️
in Connectors
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?
0
Answers
-
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.
0 -
@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.
0
