Amazon Redshift Review, Pricing & Features

Amazon Redshift is AWS's cloud data warehouse for SQL analytics and AI/ML. Serverless pricing from $0.375/RPU-hour, with a $300 trial credit.

Category
Databases
Pricing
Usage-based, from $0.375 per RPU-hour (Serverless)
Verified
Not yet
Last updated
July 18, 2026
Founded
2013
Headquarters
Seattle, Washington, USA
Web AppFree TrialAPIAI

Overview

Amazon Redshift is AWS's cloud data warehouse, enabling SQL analytics and AI/ML workloads across data unified from multiple sources without customers managing the underlying infrastructure. It offers both a serverless option that scales automatically and traditional provisioned clusters for workloads with predictable resource needs.

Key Features

Redshift supports a lakehouse architecture with native access to open table formats such as Apache Iceberg and Parquet, and offers zero-ETL integrations with services including Aurora, RDS, DynamoDB, Kinesis, and MSK for near-real-time data availability. It integrates with Amazon SageMaker for ML model development and Amazon Bedrock for generative AI use cases, including natural-language SQL generation. Security features include row- and column-level permissions and network isolation. AWS states its RG (Graviton-based) instances deliver roughly 2.4x faster performance than prior-generation RA3 instances at about 30% lower per-vCPU cost.

Pricing Overview

Redshift uses usage-based pricing. Serverless is billed per Redshift Processing Unit (RPU) starting at $0.375 per RPU-hour with per-second billing and no charges during idle periods; optional reservations can reduce serverless costs by up to 45% for 3-year commitments. Provisioned on-demand instances start around $0.543 per hour, with managed storage billed separately (around $0.024/GB-month in US East). New Redshift Serverless users receive a $300 credit valid for 90 days.

Key Features

Pros & Cons

Pros

  • Usage-based pricing avoids upfront infrastructure investment
  • Serverless option removes the need to manage cluster capacity
  • Deep native integrations with the AWS data and AI ecosystem (S3, SageMaker, Bedrock)
  • Zero-ETL integrations reduce pipeline engineering for near-real-time analytics

Cons

  • Usage-based billing can be harder to predict/budget than flat-rate pricing
  • Deepest value is realized within the AWS ecosystem
  • Provisioned cluster tuning and RPU sizing require some AWS data warehousing expertise

Pricing

Frequently Asked Questions

How is Amazon Redshift priced?

Redshift uses usage-based pricing. Serverless starts at $0.375 per RPU-hour with per-second billing; provisioned on-demand instances start around $0.543/hour, with storage billed separately.

Is there a free trial for Amazon Redshift?

New Redshift Serverless users get a $300 credit valid for 90 days; provisioned clusters may offer a two-month free trial in regions without Serverless.

Does Redshift support open table formats?

Yes, it natively supports open formats like Apache Iceberg and Parquet as part of its lakehouse architecture.

Can Redshift be used for AI/ML workloads?

Yes, it integrates with Amazon SageMaker for ML development and Amazon Bedrock for generative AI, including natural-language SQL generation.

Comparisons

Related Tools