DynamoDB Update
On this Page
Snap type: | Write | |||||||
---|---|---|---|---|---|---|---|---|
Description: | This Snap provides the ability to update the data in DynamoDB table. The table becomes suggestible once the account is defined.
| |||||||
Prerequisites: | None | |||||||
Support and limitations: | Works in Ultra Tasks. | |||||||
Account: | This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See DynamoDB Account 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. | |||||||
Table name | Required. The name of the table to write the data into. This property is suggestible, which shows the list of the tables in db. | |||||||
Update expression | An expression that defines one or more attributes to be updated. | |||||||
Conditional expression | A condition that must be satisfied in order for the update to succeed. | |||||||
Expression attribute values | Specify the placeholders for the Expression Attribute Names and/or Expression Attribute Values. DynamoDB reserves certain words and they are called reserved words. You must not use reserved words as attribute names in expressions. If you must write an expression that contains a word that conflicts with a DynamoDB reserved word, then you can define an expression attribute name to use in the place of the reserved word. For more information, see Expression Attribute Names. Similarly, you cannot use certain values as attribute values in expressions and instead must define an expression attribute name. For more information, see Expression Attribute Values. Click + to enter:
Example If your table contains a column named UUID (a reserved word) and you want to update a value in the UUID column, then you must assign a placeholder for the column name because you cannot use a reserved word directly in your expression. We can define the Attribute #u, leave the Type blank, and enter the value as UUID. In the Snap Update expression condition, we enter Set #u=:val1. :val1 is the placeholder for the value in the table which is defined as Attribute :val1 of Type B with Value dGhpcyB0ZXh0I.
| |||||||
Snap execution | Select one of the three modes in which the Snap executes. Available options are:
|
Examples
The following image shows a sample pipeline:
The following image shows the mappings of the Mapper Snap that feeds into the DynamoDB Update Snap:
Snap Pack History
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.