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

Amazon Redshift pros and cons

3.9 out of 5
1,551 followers
Post review

Pros & Cons summary

Buyer's Guide

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

Prominent pros & cons

PROS

Amazon Redshift offers excellent performance, data compression, and scalability, making it suitable for handling large amounts of data efficiently.
Its integration with other AWS services and the ability to easily migrate from other databases enhance its flexibility and utility.
The scalability of Amazon Redshift allows it to grow with the user's needs and enables easy scaling up or down.
Its ability to perform fast data processing and manage large data sets is highly valued by users.
Amazon Redshift provides a cost-effective solution for data warehousing with efficient management and administration features.

CONS

Amazon Redshift needs improvement in compatibility with other products like Microsoft and Google.
Migrating data from other data sources is challenging when dealing with multibyte character sets.
Data ingestion and update processes are time-consuming.
The speed and portability of Amazon Redshift need enhancement.
Running parallel queries results in poor performance requiring attention.
 

Amazon Redshift Pros review quotes

Tamás Srancsik - PeerSpot reviewer
Sep 7, 2023
The solution has very competitive pricing.
LS
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.
reviewer2179353 - PeerSpot reviewer
May 9, 2023
Redshift has an advantage when it comes to administration, making it easier to manage and collaborate.
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
823,875 professionals have used our research since 2012.
BR
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.
SN
Jun 21, 2020
The most valuable feature is the scalability, as it grows according to our needs.
TD
Jul 19, 2020
I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.
MandarGarge - PeerSpot reviewer
Jun 29, 2022
It's scalable because it's on the cloud.
Syed Zakaulla - PeerSpot reviewer
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.
Venkata Maniteja Alapati - PeerSpot reviewer
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.
GV
Jun 13, 2024
With the APIs that are available, it can be easily integrated with other tools.
 

Amazon Redshift Cons review quotes

Tamás Srancsik - PeerSpot reviewer
Sep 7, 2023
It would be good to see Redshift as a serverless offering.
LS
Dec 28, 2022
For people who struggle with IAM or role-based management, the setup isn't easy.
reviewer2179353 - PeerSpot reviewer
May 9, 2023
Amazon Redshift does not have the capability to dynamically increase the VM file.
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
823,875 professionals have used our research since 2012.
BR
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.
SN
Jun 21, 2020
The OLAP slide and dice features need to be improved.
TD
Jul 19, 2020
There are too many limitations with respect to concurrency.
MandarGarge - PeerSpot reviewer
Jun 29, 2022
I would like to improve the pricing and the simplicity of using this solution.
Syed Zakaulla - PeerSpot reviewer
Feb 13, 2023
If you require a highly scalable solution, I would not recommend Amazon Redshift.
Venkata Maniteja Alapati - PeerSpot reviewer
Apr 4, 2024
When working with third-party services requires additional integrations and configurations, which can sometimes add more cost.
GV
Jun 13, 2024
It is not easy to deal with queries in Amazon Redshift and see the same data.