/
PostgreSQL - Update

PostgreSQL - Update

On this page

Snap type:

Write

Description:

This Snap executes a SQL update with the given properties.  Keys from the document will be used as the columns to update and their values will be the updated value in the column.

Updates will be batched up until the account's batch size property or until the structure of the update statement changes. An update statement will change if an incoming document contains different keys than a previous document. 
Prerequisites:

None

Support:Works in Ultra Tasks.
Limitations:If you want to filter by vector values, you must query vector columns using String format in the Where clause.
Account: 

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring PostgreSQL Accounts for in