Amazon Redshift
Free tier availableAWS cloud data warehouse for analytics at scale
📖 Overview
Amazon Redshift was the first cloud data warehouse, launching in 2012 and kickstarting the modern data stack era. It's a fully managed, petabyte-scale warehouse deeply integrated with AWS services. Redshift Serverless now offers on-demand pricing.
✨ Key Features
- ✓ Columnar Storage: MPP architecture for analytics
- ✓ Redshift Serverless: Pay-per-use option
- ✓ Spectrum: Query S3 data directly
- ✓ ML Integration: Built-in ML functions
- ✓ Data Sharing: Share data across accounts
- ✓ AQUA: Advanced query accelerator
💰 Pricing
Model
paid
Starting Price
$0.25/hour
✓ Free tier available
🏢 Enterprise plans available
👍 Pros
- + Deep AWS ecosystem integration
- + Mature and battle-tested
- + Cost-effective for steady workloads
- + Serverless option available
- + Strong security features
👎 Cons
- − Requires more tuning than competitors
- − Vacuum/analyze maintenance
- − Concurrency can be limited
- − Less modern than Snowflake/Databricks
- − Pricing complexity
🎯 Best For
AWS-native organizations with steady, predictable workloads. Good value when you can commit to reserved instances.
🔗 Works With
📁 More Data Warehouses Tools
BigQuery
Google's serverless, highly scalable data warehouse
ClickHouse
Blazing fast open-source OLAP database
Databricks
Unified analytics platform for data engineering and AI
DuckDB
Fast in-process analytical database