0

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.

New contributor
gibbz00 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

put on hold as off-topic by womble May 16 at 2:21

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

1

Have a look at Data Migration Service. I'm not saying it is what you need, but it might help. You're probably going to have to roll your own.

New contributor
bgdnlp is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Thank you. I will research this tool. – gibbz00 May 15 at 22:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.