Sign in to save your place.
AWS's cloud data warehouse that powers analytics for thousands of companies. Let's understand what it is and why it matters.
Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse by AWS. It's designed for running complex analytical queries on massive datasets — think billions of rows analyzed in seconds.
Imagine you have a super-powerful calculator that lives in Amazon's cloud. You can send it millions of math problems at once, and it solves them all in seconds. You don't need to buy the calculator — you just rent it by the hour. That's Redshift!
Unlike your laptop's database that struggles with millions of rows, Redshift can handle trillions of rows because it splits the work across many computers working together.
| Feature | PostgreSQL | Redshift | Snowflake |
|---|---|---|---|
| Type | OLTP (transactions) | OLAP (analytics) | OLAP (analytics) |
| Storage | Row-based | Columnar | Columnar |
| Scale | Single server | Multi-node cluster | Elastic cloud |
| Pricing | Self-hosted | Per-node/hour or Serverless | Per-credit |
| Best For | App backends | AWS-centric analytics | Multi-cloud analytics |
| SQL | Standard PostgreSQL | PostgreSQL-compatible | ANSI SQL |
Redshift is based on PostgreSQL 8.0, so if you know PostgreSQL, you already know ~80% of Redshift SQL! But Redshift adds columnar storage, MPP (Massively Parallel Processing), and deep AWS integration.
Imagine you need to count all the red balls in a warehouse with 1 million balls. PostgreSQL sends ONE person to count them all — takes hours.
Redshift sends a TEAM of 100 workers, each counting their section simultaneously. Done in minutes! That's MPP — splitting work across multiple "nodes" (computers).
Redshift uses which type of storage?
A new warehouse is Redshift Serverless or an RA3 cluster. DC2 is a previous generation. The setup lesson is where that choice is made. Zero-ETL, data sharing, AUTO table design, automatic WLM, Spectrum, and Iceberg each have limits. The later lessons name the limit instead of treating the feature as always on.
Try this. Write one sentence: Serverless or RA3, and why you are not choosing DC2.
What should a new Redshift warehouse use?