Icon

06_​Amazon_​S3_​meets_​DynamoDB

Amazon S3 meets DynamoDB
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

Nodes

Extensions

Links