How do I integrate Amazon SQS with Dynamodb

amazon-web-services amazon-dynamodb amazon-sqs amazon-ses
ramprasathrajendran picture ramprasathrajendran · Aug 5, 2013 · Viewed 11.2k times · Source

Is it possible to auto send/push the messages in Amazon SQS to DynamoDB? I wish to send my messages to SQS and for period of time I want to send this to DynamoDB. Another service should fetch the DynamoDB table and send it as email using SES.

Kindly help me out to achieve this. I will be using it for the User notification purpose from a Social networking site.

Thanks.

Answer

prestomation picture prestomation · Aug 5, 2013

There is no AWS mechanism to automatically publish SQS messages to DynamoDB; but you can use an AWS Lambda event source mapping to automatically pull SQS messages and invoke a Lambda function, and it's pretty straightforward to write a Lambda function that writes those messages to DynamoDB. (Here's an example using Node.js: https://docs.aws.amazon.com/sdk-for-javascript/v2/developer-guide/dynamodb-example-table-read-write.html.)

Related questions

DynamoDB vs MongoDB NoSQL

I'm trying to figure it out what can I use for a future project, we plan to store from about 500k records per month in the first year and maybe more for the next years this is a vertical application …

Read More
What is the recommended way to delete a large number of items from DynamoDB?

I'm writing a simple logging service in DynamoDB. I have a logs table that is keyed by a user_id hash and a timestamp (Unix epoch int) range. When a user of the service terminates their account, I need to …

Read More
Querying DynamoDB by date

I'm coming from a relational database background and trying to work with amazon's DynamoDB I have a table with a hash key "DataID" and a range "CreatedAt" and a bunch of items in it. I'm trying to get all the …

Read More