This post describes an easy way of importing a CSV-file saved in Amazon S3 to a table in Amazon Aurora.
Technologies used in this post:
- Amazon Aurora is a cloud-based relation database which is compatible with both MySQL and PostgreSQL
- Amazon S3 is a cloud-based object storage
To get started we need to download a sample CSV file. I this case I will use this dataset: https://www.stats.govt.nz/assets/Uploads/Births-by-statistical-area-2-and-area-unit-for-comparison.csv
First, you need to upload this file to an S3 Bucket