A combination of AWS lambdas does event-driven file upload into the Redshift with a COPY query. This is a quick snapshot for pretty stable file upload flow. Redshift cluster has a medium load produced by various reporting tasks on it.

Here is a quick solution for a pretty common aggregation use case based on AWS Lambdas and serverless.com framework.

The Simple Aggregation Use Case

Sometimes you need to share some static content stored on Amazon S3. Here is a quick recipe.

1. Create Origin Access Identity on CloudFront Dashboard

I would like to share some details for my quick solution for air quality monitoring right close my…