Creating an OLAP data warehouse from an OLTP AWS RDS

by gibbz00   Last Updated May 15, 2019 18:00 PM

I have an OLTP AWS RDS(in postgresql and very normalized) that powers an application. I am trying to create a separate data warehouse(OLAP use case) also in AWS RDS(postgresql) using a star shchema. I am not considering redshift as it is more expensive and the amount of data does not warrant it. As an AWS newbie, my question is are there certain tool within the AWS stack that will allow me to build a data warehouse type RDS based of off an OLTP RDS? Any suggestions regarding data copying/data syncing between two RDSs etc. is of great help.



Related Questions


Latency of a disc access

Updated February 12, 2018 17:00 PM


How to mirror AWS EC2-Instance data?

Updated April 20, 2015 08:00 AM