Skip to content
SPECIFICTION
Get listed

Amazon Redshift

aws.amazon.com

From $0.54/mo Free trial WebAPI
Visit aws.amazon.com
Spec score 8.3 #6 of 29 in Cloud Analytics Solutions

What it is

Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes. It offers provisioned and serverless deployments, with options AWS says can scale to petabytes and support thousands of concurrent users. Redshift runs read-only SQL queries on 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 connects with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka. Listed integrations include QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker. The Data API supports AWS SDK languages including Python, Go, Java, Node.js, PHP, Ruby, and C++. Security includes encryption, row- and column-level controls, and dynamic masking. It is paid, has no free plan, offers a free trial, and starts at $0.54 per month for Provisioned or $1.50 per month for Serverless.

Spec sheet

What it does
Amazon Redshift is a cloud data warehouse for SQL analytics across data warehouses and data lakes.Read 29 Sep 2026 · aws.amazon.com
Deployment
It offers provisioned and serverless deployment options.Read 29 Sep 2026 · aws.amazon.com
Free plan
NoRead 20 Sep 2026 · aws.amazon.com
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++.Read 29 Sep 2026 · aws.amazon.com
Security
Redshift supports encryption in transit and at rest, row- and column-level access controls, and dynamic data masking.Read 29 Sep 2026 · aws.amazon.com
Availability
AWS states that a Multi-AZ Redshift data warehouse offers a 99.99% SLA.Read 29 Sep 2026 · aws.amazon.com
BI and ETL integrations
AWS lists QuickSight, Tableau, Microsoft Power BI, Alteryx, Jupyter Notebook, Informatica, dbt, MicroStrategy, and Looker among compatible tools.Read 29 Sep 2026 · aws.amazon.com
Data ingestion
Zero-ETL integrations connect Redshift with Amazon Aurora, Amazon RDS, Amazon DynamoDB, and enterprise applications.Read 29 Sep 2026 · aws.amazon.com
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.Read 29 Sep 2026 · aws.amazon.com
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.Read 29 Sep 2026 · aws.amazon.com
Identity and auditing
Redshift integrates with AWS IAM Identity Center for single sign-on and AWS CloudTrail for auditing API calls.Read 29 Sep 2026 · aws.amazon.com
Intended workloads
AWS describes use cases including dashboarding, application development, data sharing, and ETL jobs.Read 29 Sep 2026 · aws.amazon.com
Scale
AWS says Redshift options scale to petabytes of data and support thousands of concurrent users.Read 29 Sep 2026 · aws.amazon.com
Streaming
Streaming ingestion can connect with Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka.Read 29 Sep 2026 · aws.amazon.com

Plans and prices

Provisioned $0.54 a month 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 Read 20 Sep 2026 · aws.amazon.com
Serverless $1.50 a month 60-second minimum charge 4-1024 RPUs Read 20 Sep 2026 · aws.amazon.com
Provisioned on-demand $0.54 a month 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 Read 29 Sep 2026 · aws.amazon.com
Redshift Serverless on-demand $1.50 a month 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 Read 29 Sep 2026 · aws.amazon.com

Every Amazon Redshift plan and price →

Strong points and limits

Strong points

  • Provisioned and serverless deployment options
  • Queries Iceberg, Hudi, and Delta Lake tables
  • Zero-ETL and streaming ingestion integrations
  • Encryption and row-level access controls
  • Free trial available

Limits

  • No free plan
  • Paid starting rates apply
  • Storage and other usage may bill separately
  • TCP-style platform details require AWS context

Who it suits

It suits teams running SQL analytics, dashboards, application workloads, data sharing, or ETL in the cloud. It also fits organizations needing data-lake queries, streaming ingestion, and AWS-connected tooling.

Verdict

Redshift combines warehouse analytics with data-lake querying, ingestion integrations, and separate compute and storage. Its paid model and AWS-oriented deployment make pricing and architecture details important before adoption.

Where Specifiction places it

Alternatives to Amazon RedshiftAll alternatives →

Hex From $36/mo · Free plan 8.2 Visit