Amazon DynamoDB Query

This node queries DynamoDB and returns the matching attributes as KNIME table. Important: the columns and their types of the KNIME output table are determined from the first batch of items retrieved from DynamoDB. One batch has a maximum size of 1MB. If an item in a later batch, i.e. after loading 1MB, has an attribute that did not occur before, this attribute is not written to the output table.

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.
Hash Key
The hash key of the items to retrieve.
Range Key
A filter on the table's range key.
Index name (*)
The name of the index to use or empty if no index should be queried.
Consistent Read
Whether consistent read should be enforced (costs twice the throughput capacity units).
Limit
The maximum number of items to retrieve.
Publish consumed capacity units as flow variable
If checked, the total capacity units used by the operation are published as a flow variable named "queryConsumedCapacity".

Filter & Projection

Filter
A filter expression (see the DynamoDB documentation)
Projection
The attributes to load from DynamoDB.
Name Mapping
Mapping for name placeholders in the filter and projection expressions. Necessary if the attribute names are reserved keywords.
Value Mapping
Mapping for value placeholders in the filter and projection expressions.

Input Ports

Icon
Credentials for an AWS account

Output Ports

Icon
Credentials for an AWS account
Icon
KNIME data table with query results

Views

This node has no views

Workflows

Links

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.