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

ravimohan911 · 2021-05-14T15:06:28+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Connectors

Dataset

Scheduler

Schema

Accepted answers

All comments

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of