Versions Compared

Old Version 2

changes.mady.by.user Aparna Tayi

Saved on

compared with

New Version 3

changes.mady.by.user Aparna Tayi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Snap type:

Write


Description:

This Snap deletes an item or a bunch of items (based on batch size) from an existing table in AWS DynamoDB. 


  • Expected upstream Snaps: Any Snap that provides a document output view, such as Structure or a JSON Generator Snap. 
  • Expected downstream Snaps: Any Snap that has a document input view, such as Filter or Data or JSON Formatter.
  • Expected input: The table's key schema is suggested on input view. The values for the record keys are passed from the input view. 
  • Expected output: This Snap returns an HTTP response code 200 on success. 

 
Note: The delete operation performed by this Snap is Idempotent, that means even when the given input records do not exist, the Snap still gives an HTTP 200 response.

Prerequisites:

[None]


Support and limitations:
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:
InputThis Snap has exactly one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.

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 delete the data from. This property is suggestible, that shows the list of the tables in the database.
Example: Thread
Default value: [None]

Delete condition


Specifies a condition to be used on non-key attributes for performing the delete operation.

Note: 
Note

Applicable only when batch size is 1.

Default value: [None]  


Batch size

 

Specifies the number of records to be deleted in a single request.

Default value:1


Output deleted records

 

Specifies whether or not to display the original records in the output view. 
Default value: Not selected  

Expression attribute values

This property is used to specify the placeholders to be used in delete condition property above. Refer here for more information.

Example:

 Attribute TypeValue
 :val1 SAmazon DynamoDB


  • Attribute name must always begin with a colon(:val1)
  • Type will be S for string, N for number and so on
  • The Value is the actual literal to be used in the delete condition 

Scenario:

Suppose, a table T1 has two columns A1 and A2 where A1 is a key- attribute and A2 is a non-key attribute. A record having value for A2 as 'Snap' needs to be deleted. We cannot enter A2=Snap in the delete condition directly , instead assign a placeholder for the value and hence, we define an Attribute :v1 of Type S, and Value as Snap. We will then give A2=:v1 in the delete condition.


 Attribute TypeValue
 :v1 SSnap

Execute during preview


This property enables you to execute the Snap during the Save operation so that the output view can produce the preview data.  

Default value: Not selected


...