Use Aurora Postgresql as Datamart for Redshift
A customer is using Redshift in eu-west-3 and looking to use Aurora Postgresql as a DataMart downstream.
They asked me if Aurora works well for such use cases.
Do any of you have any experience or warning for such OLAP uses cases?
This can work well if the Aurora database has aggregated data that is optimized for specific query patterns and high concurrency. See the "Low Latency Hybrid Warehousing" section under Architectures for Scaling at https://github.com/aws-samples/aws-dbs-refarch-edw.
Before going down this path, it is important to evaluate why they feel a separate datamart is needed to make sure we propose the right solution.
Use Aurora Postgresql as Datamart for RedshiftAccepted Answerasked 3 years ago
Aurora PostgreSQL Replica Pricingasked 2 years ago
Aurora PostgreSQL aws_s3.query_export_to_s3 compressionasked a month ago
Tracking changes in data in Aurora PostgreSQLAccepted Answerasked 2 years ago
Babelfish backup and recovery optionsasked 9 days ago
Changes to connection handling with Aurora Postgres?Accepted Answerasked 3 years ago
PostGIS and Aurora compatibility: experience feedbackAccepted AnswerEXPERTasked 3 years ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago
Major Version Upgrade Aurora PostgreSQL 11asked 2 years ago
Choosing RDS PostgreSQL over Aurora PostgreSQLasked a month ago