Forum Discussion

RStelzig's avatar
RStelzig
New Contributor
3 years ago

Is it possible to perform an upsert to Postgres in SnapLogic?

Hi Everyone, Is there an option to configure an existing Postgres snap to perform an upsert to a given table? I am building a pipeline to create a daily feed to a postgres database and would like...
script
rriley99's avatar
rriley99
New Contributor III
2 years ago
Copy LinkReport

I have the same question, did you find a solution?

  • RStelzig's avatar
    RStelzig
    New Contributor
    2 years ago
    Copy LinkReport

    Hi rriley99 ,

    I did find a solution that I have been using for almost a year without error. It's similar to alchemiz  suggestion below which I haven't tried yet but will definitely check out in the future.

    I am using a slightly different approach on the scripting as I am using a staging table in my database.  In the Postgres - Execute Snap I am using the following:

    Hope that is helpful to you!

    • rriley99's avatar
      rriley99
      New Contributor III
      2 years ago
      Copy LinkReport

      This was exactly what I was going to try when I got to that stage. I will write back once I get there!