🗄️Amazon Redshift
Also known as Redshift, AWS Redshift, Redshift Serverless
Amazon's warehouse in the cloud. Each query is split up and run on many nodes.
Think of it like
It is like a team of clerks who each hold part of the files. They all search at once.
Example
Why it matters
Definition
Example code
sql
COPY sales
FROM 's3://acme-lake/sales/2026/'
IAM_ROLE 'arn:aws:iam::123456789012:role/RedshiftLoad'
FORMAT AS PARQUET;Common mistake
Key takeaways
- 1Columns on many nodes. Each node scans its own slice.
- 2Cluster or serverless. Size it yourself, or let AWS do it.
- 3Close to S3. Bulk loads come from files.