Import from AWS S3

I am trying to figure out a good way to import data from an S3 bucket without any manual steps. Has anyone done this before?

Is it possible to run ETL externally, say from a lambda function, and have it point to your database location? Specifically, the lambda function would be running