fernandito77777/AWSDataAnalyticsPostgreWorkshop

Workshop Database RDS Postgre Integration and offloading to Data Lake, and visualize the data to QuickSight

AWS Data Analytics Postgre Workshop

Architecture

Agenda

1. Setup Database and Datalake
2. Transfer data from RDS Database Postgre to Datalake S3
3. Catalog the data with glue crawler and data catalog
4. Ad Hoc Query on Datalake with Athena
5. Visualize data with Quicksight

Note

• The region will be on ap-southeast-1 (Singapore)
• The instruction is for Mac/Linux user. Please download PuTTY for Windows user.
• In first step, please refer to this link to connect your EC2 instance