# AWS Redshift

> Amazon Redshift is a managed, columnar data warehouse for large-scale SQL analytics, available as provisioned clusters or serverless.

- Source: https://www.itwonderlab.com/aws-redshift/
- Published: 2026-07-10
- Updated: 2026-07-10
- Author: Javier Ruiz Jiménez (https://www.javierruizjimenez.com/)
- Site: IT Wonder Lab (https://www.itwonderlab.com/)

---

**Amazon Redshift** is a petabyte-scale data warehouse based on columnar storage and massively parallel processing, compatible with PostgreSQL clients. It queries data loaded into the cluster and also data in [S3](https://www.itwonderlab.com/aws-s3/) with Redshift Spectrum. Choose **provisioned** clusters for steady workloads or **Redshift Serverless** for variable ones. For transactional workloads use [RDS](https://www.itwonderlab.com/aws-rds/) or [Aurora](https://www.itwonderlab.com/aws-aurora/).

With Terraform: `aws_redshift_cluster`, `aws_redshiftserverless_namespace` and `aws_redshiftserverless_workgroup`.