I have a situation where data is getting loaded into staging tables of Aurora MySQL from AWS S3 using Lambda function on a daily basis. Now, I need to schedule a job in Aurora DB which will trigger a SQL Procedure (having some transformation logic) to load the data from staging tables to target tables.
Can this be achieved in AWS Aurora Database? Does it needs any help from any other AWS Services?