AWS Redshift sandbox
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 amd 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
Redshift Spectrum
Query data in S3
Faster than Athena?