# Amazon Redshift

> Amazon's warehouse in the cloud. Each query is split up and run on many nodes.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Redshift, AWS Redshift, Redshift Serverless

## Think of it like

It is like a team of clerks who each hold part of the files. They all search at once.

## 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

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

## 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.

## Why it matters

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

## Common mistake

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

## Three principles

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

## Related terms

- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Snowflake](https://learn.benibix.com/term/data/snowflake)
- [Google BigQuery](https://learn.benibix.com/term/data/bigquery)
- [Amazon Web Services (AWS)](https://learn.benibix.com/term/infrastructure/amazon-web-services)
- [Columnar Storage](https://learn.benibix.com/term/data/columnar-storage)

---

Source: https://learn.benibix.com/term/data/amazon-redshift
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
