Scope

AZ scope

Features

• Data warehouse for VERY LARGE amounts of data
• MPP (Massively parallel processing)
• sql analytics on exabytes of data for business insights - complex BI workloads
• provisioned and serverless
• managed storage - scale storage and compute needs independently
• Replication to S3
• 3 9s SLA
• redshift spectrum to query data lake in S3
• data exchange to share/use data in standard formats easily with 3rd parties
• manual scaling options
• increase query concurrency = Concurrency Scaling - no downtime
• increase query throughput, add nodes = Elastic resize - 4 to 8 mins
• Cloud offering based on ParAccel’s solution

Redshift Spectrum

Query data in S3
Faster than Athena?

Refer

• https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/