0 ×

Amazon DynamoDB Batch Get

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

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

The command sent to DynamoDB by this node is BatchGet, with a single batch retrieving at most 100 items.

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 retrieved, the node fails and you have to increase the provisioned read capacity units on the table.

More information can be found in the DynamoDB documentation.

Options

Standard Settings

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 retrieve in a single batch (max. 100, min. 1).
Hash Key Column
The column in the input KNIME table containing the hash key of the items to be retrieved.
Range Key Column (*)
The column in the input KNIME table containing the range key of the items to be retrieved.
Publish consumed capacity units as flow variable
If checked, the total capacity units used by the operation are published as a flow variable named "batchGetConsumedCapacity".

Projection

Projection (*)
A projection expression determining which attributes to retrieve. See the DynamoDB documentation.
Name mapping
Placeholder names and values for attribute names in the projection expression that do not conform to the norm for attribute names or are reserved keywords.

Input Ports

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

Output Ports

Icon
Credentials for an AWS account
Icon
KNIME data table with retrieved items

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.