On this page
Table of Contents | ||||
---|---|---|---|---|
|
Snap type: | Read | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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.
| |||||||||||||||
Prerequisites: | None | |||||||||||||||
Support and limitations: | Works in Ultra Task Pipelines. | |||||||||||||||
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 information on setting up this type of account. | |||||||||||||||
Views: |
| |||||||||||||||
Settings | ||||||||||||||||
Label | Required.The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | |||||||||||||||
Schema name | The database schema name. Selecting a schema filters the Table name list to show only those tables within the selected schema. The property is suggestible and will retrieve available database schemas during suggest values.
Example: myschema Default value: [None] | |||||||||||||||
Table name | Required. The name of the table to execute the update operation on.
Example: people Default value: [None] | |||||||||||||||
Update condition | Required.Condition to execute an update on.
Examples:
Default value: [None] | |||||||||||||||
Number of retries | Specifies the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response. Example: 3 Default value: 0
| |||||||||||||||
Retry interval (seconds) | Specifies the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. Example: 10 Default value: 1 | |||||||||||||||
|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|