Use Aurora Postgresql as Datamart for Redshift
0
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?
Thanks
asked 3 years ago3 views
1 Answers
0
Accepted Answer
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.
answered 3 years ago
Relevant questions
Use Aurora Postgresql as Datamart for Redshift
Accepted Answerasked 3 years agoAurora PostgreSQL Replica Pricing
asked 2 years agoAurora PostgreSQL aws_s3.query_export_to_s3 compression
asked a month agoTracking changes in data in Aurora PostgreSQL
Accepted Answerasked 2 years agoBabelfish backup and recovery options
asked 9 days agoChanges to connection handling with Aurora Postgres?
Accepted Answerasked 3 years agoPostGIS and Aurora compatibility: experience feedback
Accepted AnswerMove RDS postgresql database to Aurora Serverless
Accepted Answerasked 3 years agoMajor Version Upgrade Aurora PostgreSQL 11
asked 2 years agoChoosing RDS PostgreSQL over Aurora PostgreSQL
asked a month ago