0 ×

Amazon DynamoDB Batch Delete

KNIME Amazon DynamoDB Nodes version 4.3.0.v202011231544 by KNIME AG, Zurich, Switzerland

This nodes deletes items in DynamoDB that match a given hash and optional range key in a KNIME table.

The command sent to DynamoDB by this node is BatchWriteItem, with a single batch deleting at most 25 items, so deleting a large amount of data may take a while. The individual delete operations on item level are atomic, but the operation is not atomic on batch or even node execution level. That means if the node fails in-between, some of the items may have been deleted and others not.

If DynamoDB throttles the requests due to insufficient provisioned capacity units, unprocessed items are included in the next request. Additionally this node employs exponential backoff if throttling occurs. Each time a request cannot be completed fully, the next request is sent after a waiting time of 2^nRetry * 100 milliseconds. Once a request can be executed completely, the retry counter is reset. However, if no item can be deleted, the node fails and you have to increase the provisioned write capacity units on the table.

More information can be found in the DynamoDB documentation.

Options

Region
The region the table is in.
Table Name
The table to access.
Custom Endpoint (*)
A custom endpoint if the default AWS endpoint should not be used, e.g. for DynamoDB Local.
Batch Size
The number of items to delete in a single batch (max. 25, min. 1).
Hash Key Column
The column in the input KNIME table containing the hash key of the items to be deleted.
Range Key Column (*)
The column in the input KNIME table containing the range key of the items to be deleted.
Publish consumed capacity units as flow variable
If checked, the total capacity units used by the operation are published as a flow variable named "batchDeleteConsumedCapacity".

Input Ports

Icon
Credentials for an AWS account
Icon
KNIME data table with keys of items to be deleted

Output Ports

Icon
Credentials for an AWS account

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME Amazon DynamoDB Nodes from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.