AWS Step Function helped me clone and filter live db to reporting db every hour
What do you like best?
The ability to run multiple AWS functions into a series of steps or flow so the step functions can make a sort of like a mini-application. I used it to replica live database into the analytics database for an hourly update of analytics database and it was really easy to write a couple of lambda functions each of which did a different step job and then using step functions to align them to run in a flow and notify me in case of any failure.
What do you dislike?
The step functions console could be more user friendly to include step by step guide of creating step-functions rapidly. That would help me create and use a new step function every day instead of taking time and motivation to create a step function due to the efforts required.
Recommendations to others considering the product:
Start with the sample step function provided by AWS Step functions console to modify it and create your own by tweaking it according to your desire. this will save you a lot of time and effort.
What problems are you solving with the product? What benefits have you realized?
I needed to clone a production database to an analytics database with a different instance type, filter confidential information out of it, changing its password (since it was a prod clone it would have a prod password so I used analytics DB password) and renamed it and then updating route53 records to update the CNAME value to analytics DB endpoint. Thus step-functions helped me write different lambda functions and performed these steps in a series of steps with wait times which could be incorporated like creating a DB took 3-7 mins so I incorporated wait time of 8-10 mins to be safe etc.