Amazon sns topic sqs labmda

Question

I already find out how to publish message to SNS topic and subscription are mobile notification.

But I also want every message save to a database. How could I do this with?

Because I know that you can subscribe sqs queue also to the same topic. But I don't only want save the message, but also who receive the message.

Please could anyone help me what is logical to do?

Thanks! :)

Answer 1

If you already have an SNS topic set up you could set up a Lambda Function as a trigger for it. SNS to Lambda. Tutorial

This lambda could then be set up relatively easily to post data to a dynamodb table Lambda to Dynamo. This way you wont have to set up any SQS Queues and the Lambda can be used to format and organize the data before it gets sent to Dynamo (if needed).