Amazon Redshift
TL;DR
Amazon Redshift is AWS’s petabyte-scale cloud data warehouse: a massively parallel SQL engine with columnar storage, tight AWS integration, and usage-based pricing — rated 9/10 by data teams.
Key Facts
Free version: AWS offers a free trial for Redshift — typically 750 hours across two months on a single dc2.large node, plus the standard $300 AWS free-tier credit for new accounts.
Pricing
Starting at From about $0.25/hour per node on-demand (serverless priced per RPU-hour)
On-Demand Provisioned
- Provisioned clusters with fixed compute
- Automatic backups and snapshots
- No upfront commitment; pause to stop billing
Serverless
- Auto-scaling compute with no cluster management
- Pause and resume automatically
- Pay only while queries actually run
Reserved / Savings Plans
- Up to ~60%+ savings over on-demand
- Predictable monthly cost for steady workloads
- Same features as on-demand clusters
Additional Pricing Information
Redshift bills compute per node-hour on provisioned clusters or per RPU-hour on the serverless option, with storage priced separately per terabyte-month. Reserved Instances and Savings Plans cut costs up to 60%+ for steady workloads. A 2-month free trial and the $300 new-account credit make it easy to test before spending. Watch the bill closely — idle clusters and growing storage are the two ways costs creep up.
Details
What is Amazon Redshift?
Amazon Redshift is AWS’s answer to the enterprise data warehouse — a petabyte-scale, columnar, massively parallel SQL engine that data teams consistently rate 9 out of 10 across roughly 218 TrustRadius reviews. Its superpower is friction with the rest of AWS: S3 staging, Glue catalogs, QuickSight dashboards, Kinesis streaming, and Lambda pipelines all feed and read Redshift natively, and the MPP architecture chews through hundreds of terabytes with parallel processing and automatic columnar compression. Reviewers praise effortless scaling, fast complex queries, solid managed backup/disaster recovery, and usage-based pricing that beats on-prem hardware on day one. The grumbles are operational rather than architectural: clusters start wobbling past ~25 nodes, optimization demands vacuuming and careful sort/distribution keys, SQL and data-type coverage trail full RDBMSes, IAM permission setup is fiddly for read-only users, and the price of very large deployments plus storage growth pushes some teams toward Snowflake, BigQuery, or Databricks. Serverless Redshift answers the biggest complaint — paying for idle compute — and the two-month free trial plus $300 credit make evaluation painless. Pick it when you live in AWS and want one warehouse you can grow from gigabytes to petabytes; consider rivals if you need a multi-cloud story or bleeding-edge ML built in.
Key Features
- Massively Parallel Processing — Columnar engine that distributes queries across nodes
- Serverless Option — Auto-scaling compute billed per RPU-hour with auto-pause
- Spectrum Query — Run SQL directly on data sitting in S3, no loading required
- Automatic Compression — Column encoding chosen per column to cut storage and I/O
- Automatic Scaling — Add nodes or concurrency without downtime
- Snapshots & DR — Automated backups, cross-region replication, point-in-time restore
- Native Integrations — S3, Glue, Kinesis, Aurora, QuickSight, Lambda, EMR
- Enterprise Security — Encryption, VPC isolation, IAM, and HIPAA/PCI/SOC compliance
Who is it for?
- AWS-centric teams wanting a single warehouse that scales to petabytes
- Analytics workloads needing heavy parallel query performance
- Data engineers comfortable managing clusters and optimizing sort keys
- Organizations with steady BI and reporting loads on S3-based pipelines
- Anyone wanting to start cheap with pay-as-you-go and a free trial
Who is it NOT for?
- Teams without dedicated data engineering support
- Multi-cloud shops that need one warehouse across AWS, Azure, and GCP
- Workloads demanding advanced in-database ML and data science
- Small analytics teams drowning in complex IAM and permission setup
- Anyone sensitive to enterprise-scale compute and storage bills
The Bottom Line
Amazon Redshift is the default cloud warehouse for teams already living inside AWS: it scales to petabytes, chews through complex queries with MPP muscle, and pairs so seamlessly with S3 and Glue that it feels like an extension of your stack — at a 9/10 TrustRadius rating that the market has earned over a decade. The catch is that peak performance requires real optimization discipline and the bill demands watching, and past ~25 nodes you will need a DBA who understands Redshift’s quirks. Choose it as your AWS-native analytics engine; step up to Snowflake or BigQuery if your ambitions outgrow a single cloud.
Visit website →