Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Amazon Redshift

aws.amazon.com

  • Free trial
  • Web
  • API
6.8 Club score Visit aws.amazon.com

What Amazon Redshift is

Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. It offers provisioned and serverless deployment, with AWS describing options that scale to petabytes of data and thousands of concurrent users. Redshift can run read-only SQL queries against Apache Iceberg, Apache Hudi, and Delta Lake tables, plus open file formats in Amazon S3. Zero-ETL integrations connect with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications. Streaming ingestion supports Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka. AWS lists compatibility with QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker. The Redshift Data API supports languages covered by the AWS SDK, including Python, Go, Java, Node.js, PHP, Ruby, and C++. Security includes encryption in transit and at rest, row- and column-level controls, dynamic masking, IAM Identity Center single sign-on, and CloudTrail auditing. A Multi-AZ warehouse has a stated 99.99% SLA. Provisioned starts at $0.54 a month and Serverless at $1.50 a month; there is no free plan, but a free trial is listed.

Who it suits

It suits teams running SQL analytics, dashboards, application development, data sharing, ETL jobs, or data-lake queries in the cloud. Developers can use its Data API and listed integrations.

Good to know, and what to watch

  • Provisioned and serverless deployment options
  • Queries multiple open data-lake table formats
  • Zero-ETL integrations with AWS services
  • Streaming ingestion from listed data streams
  • Supports encryption and fine-grained access controls
  • No free plan
  • Storage and other usage may be billed separately
  • Serverless has a 60-second minimum charge

Provisioned

$0.54/mo

Serverless

$1.50/mo

Provisioned on-demand

$0.54/mo

Redshift Serverless on-demand

$1.50/mo

The verdict

Amazon Redshift combines warehouse and data-lake analytics with provisioned or serverless operation. Its integrations, security controls, streaming options, and Data API support varied cloud workloads.

What the maker publishes

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++. source
Availability
AWS states that a Multi-AZ Redshift data warehouse offers a 99.99% SLA. source
BI and ETL integrations
AWS lists QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker among compatible tools. source
Data ingestion
Zero-ETL integrations connect Redshift with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications. source
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. source
Deployment
It offers provisioned and serverless deployment options. source
Free plan
No source
Free trial
The pricing page says first-time Redshift Serverless users are eligible for a $300 credit that expires after 90 days; in regions without Serverless, provisioned clusters have a two-month trial, subject to stated usage limits. source
Identity and auditing
Redshift integrates with AWS IAM Identity Center for single sign-on and AWS CloudTrail for auditing API calls. source
Intended workloads
AWS describes use cases including dashboarding, application development, data sharing, and ETL jobs. source
Scale
AWS says Redshift options scale to petabytes of data and support thousands of concurrent users. source
Security
Redshift supports encryption in transit and at rest, row- and column-level access controls, and dynamic data masking. source
Streaming
Streaming ingestion can connect with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka. source
What it does
Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. source

Checked against the maker's pages on 29 Sept 2026.