Amazon Redshift
Amazon Redshift is AWS's fully managed, petabyte-scale cloud data warehouse.
Our verdict
Who it's for
Petabyte-scale data warehouse on AWS
Who should look elsewhere
AWS lock-in
Pros
- +Deep AWS integration
- +Mature and proven
- +Serverless option
- +Cost-effective for AWS users
- +Strong SQL support
Cons
- −AWS lock-in
- −Complex pricing
- −Cluster management (provisioned)
- −Slower than newer alternatives
Key features
- ✓Columnar storage
- ✓Massively parallel processing
- ✓Redshift Serverless
- ✓ML integration (SageMaker)
- ✓Spectrum (query S3)
- ✓Concurrency scaling
- ✓Automatic backups
- ✓Encryption
Pricing
| Plan | Price | Billing | Notes |
|---|---|---|---|
| Free Trial | $0 | month | 750 DC2.Large hours/month; Try before you buy; Full features |
| Provisioned | $0.25 | month | Dedicated clusters; Reserved pricing available; Full control |
| Serverless | — | month | Auto-scaling; No cluster management; Pay for usage only |