Overview

Not use for OLTP. Used for OLAP.
Two modes: Provisioned and Serverless.

Redshift vs athena

Redshift is faster because of indexes.
Athena is serverless but all the data stays in S3.

Snapshots and DR

MultiAZ available for some clusters.
Snapshots are stored in the S3.
Can configure snapshots to automatically stored into other region.(Good for DR)

Ingesting Data into Redshift

Using Kinesis Firehose, S3 and EC2 using (JDBC driver).

Spectrum

Analyze data from S3 without loading S3 data into the Redshift.
Redshift spectrum will launch worker nodes and they will analyze the data and then, store the result back in the redshift.