There is a list of tables that are copied from Aurora to a S3 bucket in csv format.
For every S3 PUT event a lambda function is triggered, which processes the corresponding csv file.
If I have 50 csv files, how could I track that all of them have been successfully processed?
The conceptual solution would be having a list of the 50 csv files, each of them associated with a lambda execution id, and when every function finishes it updates the corresponding entry in that file.
When all files are processed correctly a trigger is fired and sends an SNS message.
But I don't really know which tools or what would be the best way to implement a solution like this.
Thanks for your time.