Automatic report schedule from dynamodb table

Question

Hi All
A few datas are stored in dynamodb table and I would like to get an automated report in my email based on the filters (like a day/24hours interval). Now I am exporting the data manually on a daily basis

Can someone guide me th proces? I think we can achieve it using a lambda function, streams and sns. Please advisce.

Regards
Ash

Answer

If you are looking to run a cron job to run a DynamoDB query and send out a report, you can look into using EventBridge. [EventBridge ](https://docs.aws.amazon.com/eventbridge/latest/userguide/eb-create-rule-schedule.html)allows you to create a cron rule where you can set the cron expression. So, the architecture looks like this: [EventBridge rule](https://docs.aws.amazon.com/eventbridge/latest/userguide/eb-create-rule-schedule.html) -> [Lambda ](https://docs.aws.amazon.com/lambda/latest/dg/welcome.html)(DDB query from AWS SDK and send a message to an SNS topic - where your email is subscribed to).

Automatic report schedule from dynamodb table

Relevant content