Build an ETL job service by fetching data from a public API endpoint and dumping it into an AWS Redshift database.
Published on Feb 20th, 2018 at https://serverless.com/blog/etl-job-processing-with-serverless-lambda-and-redshift/
One of the big use cases of using serverless is ETL job processing: dumping data into a database, and possibily visualizing the data.
In this post, I'll go over the process step by step. We'll build a serverless ETL job service that will fetch data from a public API endpoint and dump it into an AWS Redshift database. The service will be scheduled to run every hour, and we'll visualize the data using Chart.io.