Try our new research platform with insights from 80,000+ expert users

Amazon Redshift pros and cons

Vendor: Amazon Web Services (AWS)

3.9 out of 5

71 reviews
86% willing to recommend

1,158 followers

Pros & Cons summary

Amazon Redshift offers strong performance, data compression, and scalability for significant data handling. Integration with AWS services like S3 enhances data management, while advanced analytics and query efficiencies suit large datasets. Competitive pricing and easy setup boost its appeal. However, query compilation time and handling unstructured data need improvement. Multibyte character set migration and integration costs present challenges, along with concerns about node stability.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Amazon Redshift offers exceptional performance, scalability, and data compression capabilities, making it ideal for handling large datasets and complex queries.

The ability to integrate seamlessly with other AWS services and tools is a significant advantage, allowing users to leverage the entire AWS ecosystem effortlessly.

Machine learning capabilities and real-time analytics features in Amazon Redshift enable on-the-fly data analysis, adding value to data warehousing and business intelligence applications.

Amazon Redshift provides easy data migration from other databases, supported by dedicated migration tools that facilitate smooth transitions and automatic script conversion.

With its flexible and efficient data management abilities, Amazon Redshift supports parallel processing and can handle extensive data volumes, offering robust cluster and spectrum features.

CONS

Amazon Redshift's query compilation time requires significant improvement, particularly for dynamically generated queries.

Data migration challenges may arise, especially when dealing with multibyte character sets, and handling unstructured data has been found to be cumbersome and slow.

The pricing structure of Amazon Redshift is considered high compared to competitors, with customer support also cited for being costly and less responsive.

Handling concurrent queries results in poor performance, and there is a need for enhanced flexibility in processing different data formats effectively.

Amazon Redshift lacks features like a pivot function, cloning capabilities, and more comprehensive integration with non-AWS services, making it less competitive in certain scenarios.

Amazon Redshift Pros review quotes

Tamás Srancsik

Data Analyst Lead at Vectornator

Sep 7, 2023

The solution has very competitive pricing.

Read full review

LS

IoT Consultant at a computer software company with 1,001-5,000 employees

Dec 28, 2022

The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services.

Read full review

reviewer2179353

Soullution Architech at a tech services company with 51-200 employees

May 9, 2023

Redshift has an advantage when it comes to administration, making it easier to manage and collaborate.

Read full review

Amazon Redshift

Free Report: Amazon Redshift Reviews and More

Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.

860,592 professionals have used our research since 2012.

BR

BarathwajRamamoorthy

Senior Director Data Architecture at Managed Markets Insight & Technology, LLC

Jul 27, 2023

Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift.

Read full review

SN

Chief Executive Officer at Ampcome

Jun 21, 2020

The most valuable feature is the scalability, as it grows according to our needs.

Read full review

TD

Thomas Dallemagne

Cloud & Data - practice leader at Micropole Belgium

Jul 19, 2020

I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.

Read full review

V.P. Digital Transformation at e-Zest Solutions

Jun 29, 2022

It's scalable because it's on the cloud.

Read full review

Project Manager at Softway

Feb 13, 2023

Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have.

Read full review

Venkata Maniteja Alapati

Senior Director of Product Management at Sprinklr

Apr 4, 2024

Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly.

Read full review

GV

Girubakaran Velusamy

Data Engineer at GISbiz

Jun 13, 2024

With the APIs that are available, it can be easily integrated with other tools.

Read full review

Show 10 more reviews (out of 62)

Amazon Redshift Cons review quotes

Tamás Srancsik

Data Analyst Lead at Vectornator

Sep 7, 2023

It would be good to see Redshift as a serverless offering.

Read full review

LS

IoT Consultant at a computer software company with 1,001-5,000 employees

Dec 28, 2022

For people who struggle with IAM or role-based management, the setup isn't easy.

Read full review

reviewer2179353

Soullution Architech at a tech services company with 51-200 employees

May 9, 2023

Amazon Redshift does not have the capability to dynamically increase the VM file.

Read full review

Amazon Redshift

Free Report: Amazon Redshift Reviews and More

Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.

860,592 professionals have used our research since 2012.

BR

BarathwajRamamoorthy

Senior Director Data Architecture at Managed Markets Insight & Technology, LLC

Jul 27, 2023

One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum.

Read full review

SN

Chief Executive Officer at Ampcome

Jun 21, 2020

The OLAP slide and dice features need to be improved.

Read full review

TD

Thomas Dallemagne

Cloud & Data - practice leader at Micropole Belgium

Jul 19, 2020

There are too many limitations with respect to concurrency.

Read full review

V.P. Digital Transformation at e-Zest Solutions

Jun 29, 2022

I would like to improve the pricing and the simplicity of using this solution.

Read full review

Project Manager at Softway

Feb 13, 2023

If you require a highly scalable solution, I would not recommend Amazon Redshift.

Read full review

Venkata Maniteja Alapati

Senior Director of Product Management at Sprinklr

Apr 4, 2024

When working with third-party services requires additional integrations and configurations, which can sometimes add more cost.

Read full review

GV

Girubakaran Velusamy

Data Engineer at GISbiz

Jun 13, 2024

It is not easy to deal with queries in Amazon Redshift and see the same data.

Read full review

Show 10 more reviews (out of 62)

Product Categories

Product Categories

Cloud Data Warehouse

Popular Comparisons

Popular Comparisons

Azure Data Factory vs Amazon Redshift

Teradata vs Amazon Redshift

Snowflake vs Amazon Redshift

OpenText Analytics Database (Vertica) vs Amazon Redshift

Microsoft Azure Synapse Analytics vs Amazon Redshift

Dremio vs Amazon Redshift

Oracle Autonomous Data Warehouse vs Amazon Redshift

Amazon EMR vs Amazon Redshift

AWS Lake Formation vs Amazon Redshift

SAP Business Warehouse vs Amazon Redshift

IBM Db2 Warehouse on Cloud vs Amazon Redshift

Yellowbrick Data Warehouse vs Amazon Redshift

Firebolt vs Amazon Redshift

See all alternatives

Product Categories

Product Categories

Cloud Data Warehouse

Popular Comparisons

Popular Comparisons

Azure Data Factory vs Amazon Redshift

Teradata vs Amazon Redshift

Snowflake vs Amazon Redshift

OpenText Analytics Database (Vertica) vs Amazon Redshift

Microsoft Azure Synapse Analytics vs Amazon Redshift

Dremio vs Amazon Redshift

Oracle Autonomous Data Warehouse vs Amazon Redshift

Amazon EMR vs Amazon Redshift

AWS Lake Formation vs Amazon Redshift

SAP Business Warehouse vs Amazon Redshift

IBM Db2 Warehouse on Cloud vs Amazon Redshift

Yellowbrick Data Warehouse vs Amazon Redshift

Firebolt vs Amazon Redshift

See all alternatives

Related questions

18

Which ETL or Data Integration tool goes the best with Amazon Redshift?

22

What is the major difference between AWS Redshift and Snowflake?

13

What is the biggest difference between Amazon Redshift and Vertica

32

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?

20

What are the challenges faced during migrating from Netezza to AWS Redshift?

18

Which ETL or Data Integration tool goes the best with Amazon Redshift?

138

What are the main differences between Data Lake and Data Warehouse?

108

What are the benefits of having separate layers or a dedicated schema for each layer in ETL?

41

What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?

9

Are there any general guidelines to allocate table space quota to different layers in ETL?