0 ×

06_​Amazon_​S3_​meets_​DynamoDB

Workflow

Amazon S3 meets DynamoDB

This workflow demonstrates how a small dataset uploaded to S3 can be used as a basis for DynamoDB table creation and manipulation, all using KNIME nodes.

It requires the following extensions:

KNIME Amazon Cloud Connectors
KNIME Amazon S3 Connector
KNIME Amazon DynamoDB Nodes

AmazonS3DynamoDB
Provide AmazonCredentials Write to and read from Excel files in Amazon S3 Create and load DynamoDB table Explore DynamoDB node functionality This workflow demonstrates how a small dataset uploaded to S3 can be used as a basis for DynamoDB table creation and manipulation, all using KNIME nodes. Provide keys, role, regionTable and index informationRemove adult table entirelyList all knowntables in accountSubset :only femaleswith UserId > 500Create adult table withhash and range keysUpload Excel sheet from S3 tonew tableReturn only matching recordsfrom input table belowDelete only matching recordsHash and rangeselectionsReturn resultsas KNIME tableRead complete excel file residing in S3Write directly to S3 - SET YOUR PATH HEREAmazonAuthentication Amazon S3 Connector Amazon DynamoDBDescribe Table Amazon DynamoDBDelete Table Amazon DynamoDBList Tables AmazonDynamoDB Query Amazon DynamoDBCreate Table Amazon DynamoDBBatch Put Amazon DynamoDBBatch Get Amazon DynamoDBBatch Delete Table Creator AmazonDynamoDB Scan Excel Reader Excel Writer Prepare the filefor upload to S3 Provide AmazonCredentials Write to and read from Excel files in Amazon S3 Create and load DynamoDB table Explore DynamoDB node functionality This workflow demonstrates how a small dataset uploaded to S3 can be used as a basis for DynamoDB table creation and manipulation, all using KNIME nodes. Provide keys, role, regionTable and index informationRemove adult table entirelyList all knowntables in accountSubset :only femaleswith UserId > 500Create adult table withhash and range keysUpload Excel sheet from S3 tonew tableReturn only matching recordsfrom input table belowDelete only matching recordsHash and rangeselectionsReturn resultsas KNIME tableRead complete excel file residing in S3Write directly to S3 - SET YOUR PATH HEREAmazonAuthentication Amazon S3 Connector Amazon DynamoDBDescribe Table Amazon DynamoDBDelete Table Amazon DynamoDBList Tables AmazonDynamoDB Query Amazon DynamoDBCreate Table Amazon DynamoDBBatch Put Amazon DynamoDBBatch Get Amazon DynamoDBBatch Delete Table Creator AmazonDynamoDB Scan Excel Reader Excel Writer Prepare the filefor upload to S3

Download

Get this workflow from the following link: Download

Nodes

06_​Amazon_​S3_​meets_​DynamoDB consists of the following 18 nodes(s):

Plugins

06_​Amazon_​S3_​meets_​DynamoDB contains nodes provided by the following 6 plugin(s):