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

ravimohan911
ravimohan911 Montréal ⚪️

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

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    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.


    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"