High Performance Data Warehouse
Rating: 9 out of 10
January 03, 2025
AV
Vetted Review
Verified User
5 years of experience
- Fast data retrieval from the table with complex joins via columnar storage and advanced query optimization techniques like parallel execution
- Great reliable integration with AWS MSK using Amazon Redshift Streaming a low-latency streaming ingestion, AWS Glue and S3
- Concurrency scaling and work load management - helps in segregating the load distribution based on roles
- Decoupled storage and compute using RA3 instance type
- Distribute cluster using Amazon Redshift data sharing i.e centralised write cluster with multiple readonly cluster
Cons
- Data governance can be better
- Data catalog and data discovery
- Data lineage