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...
database
alchemiz's avatar
alchemiz
Contributor III
2 years ago
Copy LinkReport

Hi RStelzig ,

Good day, you can create a sql script that will handle update and insert then set it in the PostgresSQL - Execute snap.

Warning this approach might be a little error-prone as it will try to concatenate a mix of data types e.g. field type is a String type where in the script you need to enclosed it with single quote e.g. 'this is a string value' 


Thanks,
EmEm