Skip to content
BENIBIX Learn

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

A shop on AWS keeps its order files in S3. Each night, one COPY command loads them into Redshift.

Why it matters

For teams already on AWS, it sits next to their data and their access rules.

Definition

Amazon Redshift is the data warehouse on AWS. It stores tables by column and spreads them over many nodes. Each node scans its own part, and the results are joined at the end. You can run it as a cluster you size yourself, or as Redshift Serverless. It loads data easily from Amazon S3.

Example code

sql
COPY sales
FROM 's3://acme-lake/sales/2026/'
IAM_ROLE 'arn:aws:iam::123456789012:role/RedshiftLoad'
FORMAT AS PARQUET;
Load a folder of Parquet files from S3. They all go into one table.

Common mistake

Loading rows one INSERT at a time. COPY from files is many times faster.

Key takeaways

  1. 1
    Columns on many nodes. Each node scans its own slice.
  2. 2
    Cluster or serverless. Size it yourself, or let AWS do it.
  3. 3
    Close to S3. Bulk loads come from files.