Amazon Redshift is the AWS cloud data warehouse that data engineers reach for when an analytical workload outgrows a regular OLTP database (Postgres, MySQL) and needs to scan billions of rows in seconds. The mental model that holds the whole product together is four primitives: columnar storage plus massively parallel processing (MPP) for read-heavy analytics, distribution styles ( EVEN , KEY , ALL ) and sort keys for join and filter performance, the COPY command plus the leader/compute-node architecture for loading and executing queries, and Redshift Spectrum plus the VACUUM and ANALYZE maintenance commands for querying data directly in S3 and keeping the warehouse fast over time . Master those four and you can answer almost every Redshift interview question without memorizing AWS marketing.…