This question is more of an architectural question about how best to build an ETL pipeline. At present, I have an AWS Lambda that is pinged via SQS. But processing data can take a little more than 15 minutes (runtime limit of AWS) and using the sam build for deployment results in a .zip larger than 250MB, therefore it throws an error. Therefore an alternative to AWS Lambda is needed. The alternatives what I'm seeing so far are:
SQS -> ECS (Fargate) SQS -> Lambda -> ECS (Fargate)
I don't find any hints to the pro/cons of both options, and what is generally a preferred option. Any tips on how to approach this?