Amazon Redshift

B tier on Database SoftwareScore 7.3 · #34 of 74

Android app: Not listed
Free plan: Trial only
Paid plans from: $0.54/mo
Runs on: api, Web

aws.amazon.com

Summary

Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. It offers provisioned and serverless deployment options, with scaling options for petabytes of data and thousands of concurrent users. Redshift can run read-only SQL queries on Apache Iceberg, Apache Hudi, and Delta Lake tables, as well as open file formats in Amazon S3. Zero-ETL integrations connect it with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications; streaming ingestion can connect with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka. Compatible tools listed by AWS include QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker. Security features include encryption in transit and at rest, row- and column-level access controls, and dynamic data masking. The Redshift Data API supports languages and platforms covered by the AWS SDK. Pricing is paid, with no free plan and a free trial. Listed starting rates include $0.54 per month for Provisioned and $1.50 per month for Serverless.

Who it is for

Redshift suits teams running SQL analytics, dashboards, application development, data sharing, and ETL jobs. It may also suit organizations that need data lake queries, streaming ingestion, or separate storage and compute.

What is good

Provisioned and serverless deployment options.
Queries supported open table and file formats.
Zero-ETL and streaming ingestion integrations.
Encryption, access controls, and dynamic data masking.
Data API supports multiple AWS SDK languages.

What to know first

No free plan is listed.
Storage and other usage may be billed separately.
Serverless has a 60-second minimum charge.

Verdict

Amazon Redshift combines warehouse analytics with data lake querying, ingestion, and BI integrations. Review the billing terms for the selected deployment, since storage and other usage may add charges.

Amazon Redshift plans and pricing

All plans

Provisioned $0.54/mo On-demand pricing; partial hours are billed in one-second increments Provisioned cluster capacity · On-demand hourly billing · Managed storage billed separately for RG and RA3 nodes aws.amazon.com · 20 Sept 2026

Serverless $1.50/mo 60-second minimum charge 4-1024 RPUs aws.amazon.com · 20 Sept 2026

Provisioned on-demand $0.54/mo Hourly; no commitments; actual cost depends on node type and number of nodes. Starts at stated rate · storage and other usage may be billed separately aws.amazon.com · 29 Sept 2026

Redshift Serverless on-demand $1.50/mo RPU-hours billed per second, with a 60-second minimum charge; no compute charge during idle periods. Starts at stated rate · storage and other usage may be billed separately aws.amazon.com · 29 Sept 2026

Compared on database software

Free plan: Noaws.amazon.com
Deployment model: cloudaws.amazon.com

Facts

What it does: Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes.aws.amazon.com · 29 Sept 2026
Deployment: It offers provisioned and serverless deployment options.aws.amazon.com · 29 Sept 2026
Scale: AWS says Redshift options scale to petabytes of data and support thousands of concurrent users.aws.amazon.com · 29 Sept 2026
Data lake queries: Redshift supports read-only SQL queries on Apache Iceberg, Apache Hudi, and Delta Lake tables and open file formats in Amazon S3.aws.amazon.com · 29 Sept 2026
Data ingestion: Zero-ETL integrations connect Redshift with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications.aws.amazon.com · 29 Sept 2026
Streaming: Streaming ingestion can connect with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka.aws.amazon.com · 29 Sept 2026
BI and ETL integrations: AWS lists QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker among compatible tools.aws.amazon.com · 29 Sept 2026
API: The Redshift Data API supports programming languages and platforms supported by the AWS SDK, including Python, Go, Java, Node.js, PHP, Ruby, and C++.aws.amazon.com · 29 Sept 2026
Security: Redshift supports encryption in transit and at rest, row- and column-level access controls, and dynamic data masking.aws.amazon.com · 29 Sept 2026
Identity and auditing: Redshift integrates with AWS IAM Identity Center for single sign-on and AWS CloudTrail for auditing API calls.aws.amazon.com · 29 Sept 2026
Availability: AWS states that a Multi-AZ Redshift data warehouse offers a 99.99% SLA.aws.amazon.com · 29 Sept 2026
Intended workloads: AWS describes use cases including dashboarding, application development, data sharing, and ETL jobs.aws.amazon.com · 29 Sept 2026