# Amazon Redshift Reviews 2026. Verified Reviews, Pros & Cons | Capterra > Is Amazon Redshift the right Data Warehouse solution for you? Explore 16 verified user reviews from people in industries like yours to make a confident choice. Source: https://www.capterra.com/p/227349/Amazon-Redshift/reviews --- Amazon Redshift 4.4 (16) [View alternatives](https://www.capterra.com/p/227349/Amazon-Redshift/alternatives/) Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/) * * * Last updated March 13th, 2026 # Reviews of Amazon Redshift Ease of use 3.8 Customer Service 3.8 ## Showing most helpful reviews Showing 1-16 of 16 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use Filippo C. Senior Data Scientist Marketing and Advertising Used the software for: 2+ years ### "A must-have tool for data warehousing" October 12, 2023 5.0 Amazon Redshift helped us creating standard reports for advertising activities and proved to be a valuable data source for our visual dahsboards Pros Amazon Redshift allowed us to organize efficiently all our data, both for reporting and visualization purposes. You can use SQL syntax to query the tables and to extract all the info you need. It supports multiple datatypes with many data compression solutions to save disk space and money. The Amazon Redshift console (on the AWS dashboard) allows you to keep track of your db performances, from query execution time to disk space used, and displays also wise recommendation on how to manage properly your tables. Cons There is nothing I can complain about Amazon Redshift. Review Source VR Verified Reviewer Data Analytics Manager Logistics and Supply Chain Used the software for: 2+ years ### "Reliable and easy to set up" April 11, 2022 4.0 Redshift has given us a viable OLAP data warehouse which speeds up all of our analytical workloads. The main benefits we got are speed, ease of use, and reliability, which in turn gave us more time to work on other projects and also much better visibility of our products and business. Pros Redshift is a reliable cloud data warehouse that's easy to set up especially if your tech infra already runs on AWS. Cons Scaling out/up/down is quite limited with Redshift. The elastic resize is supposed to help on this but it's still limited to just halving/doubling your current cluster. It's not as flexible as Snowflake or BigQuery. Also, the max concurrency of 50 is quite low compared to other cloud data warehouses. Alternatives considered [Snowflake](https://www.capterra.com/p/148267/Snowflake/) Reason for choosing Amazon Redshift Redshift's pricing is straightforward and more predictable compared to other cloud data warehouses. Also, our existing tech infrastructure already runs on AWS so using Redshift gave us much better integration with our current tech stack. Switched from [Amazon RDS](https://www.capterra.com/p/192201/Amazon-RDS/)[MySQL](https://www.capterra.com/p/11482/MySQL/) Our datasets are getting larger and larger. We needed an OLAP database which was more appropriate for our reporting and analytics workloads. Review Source GD Gordon D. Head of Data Health, Wellness and Fitness Used the software for: 2+ years ### "Amazon Redshift - Average product" March 25, 2024 3.0 In my Opinion AWS redshift is an average product, the syntax and methods you have to use if you are used to using SQL server you will find to be more long winded or searching for alternatives ways. Basic items like parameters in stored procedures after a lot more complex than required. Pros It is a good tool for combining multiple data sources into one place. It is not really useful to load data in a delta approach but to fully reload the data source. Cons Its ETL process always wants you to create objects as S3 objects which most of the time is fine but you then end up storing the data twice, once in the 3s and then again in Redshift unless you code to delete the S3 files after loading. Review Source VR Verified Reviewer Software Engineer Information Technology and Services Used the software for: 6-12 months ### "Cloud data warehouse tool" January 20, 2026 5.0 Overall amazon redshift can provide the features I want and run my data analysis as a cloud dataware house tool Pros Amazon redshift is a greate cloud data warehouse tool which is highly scalable and can query large amount of data for data analysis, it also provides great dashboard capability. Cons There are some small learning curve to onboard to amazon redshift and to integrate with your external app. Review Source RS Rashad S. Sales Chemicals Used the software for: I used a free trial ### "Perfect one of you want to analyze large amounts of data quickly" November 6, 2025 4.0 Pros I liked that Redshift makes it easy to analyze large amounts of data quickly. It stores data in a way that speeds up queries, and it works well with other AWS services to help manage data and analytics. Cons I found that Redshift can be expensive when handling very large datasets and sometimes query performance can slow down if the system isn’t optimized properly. It also requires some setup and tuning to get the best results Review Source VR Verified Reviewer Data and Analytics Manager Financial Services Used the software for: Less than 6 months ### "Works well, but not modern enough" April 25, 2022 3.0 I was satisfied with Amazon Redshift. It works fairly well, but ultimately competitors had a better offer, regarding features, scailing and pricing flexibility, and that is why we moved away from it. Pros Redshift was surprisingly easy to deploy as a total begginer. Once it was up, it was always very stable and we didn't have any issues. Cons Redshift is very much behind its competitors in offering better features for administrators. Its permission structure is ancient (comparing to Snowflake roles) and you're completely on your own for taking care of safety. As expected, we don't have consumer support and no account manager has ever contacted me. Alternatives considered [Google Cloud](https://www.capterra.com/p/268690/Google-Cloud-Platform/) Reason for choosing Amazon Redshift Our company uses AWS stack, so i didn't look too much into GCP. But colleagues have said to me it would have been a better choice. Review Source VR Verified Reviewer Senior Data Engineer Telecommunications Used the software for: 1-2 years ### "Amazon Redshift - Perfect database to build enterprise data warehouses !" February 22, 2023 4.0 Overall the Redshift experience is great and it can be used build your data warehouses. Pros The Redshift provided various data connector to get data from different sources . The data distribution can be defined while creating a table , which helps the SQL query to minimize the i/o operations , which intern increases the speed of the reports . Cons The redshift data distribution in disk is difficult at times to decide when you are build large data warehouses . The rival product like snowflake make it easy for the users as all of the data distributions are being taken care internally. Review Source Craig S. Senior Platform Operations Specialist Marketing and Advertising Used the software for: 1-2 years ### "Solid, Reliable Option for Warehouse Storage" May 30, 2022 5.0 Redshift is the bedrock upon which our entire product lives. It stores the underlying data for our reporting, dashboards, etc. Pros Redshift is a great starting point for storing data if you're planning to build out a stack using other AWS products (EMR clusters, S3 for browsing, etc.). Redshift is reliable/dependable, we haven't faced uptime issues or anything like that. Easy to query against which is essential for us when pulling reports or performing QA. In previous work I've also been able to hook Redshift up directly to Tableau which has been huge in building ad-hoc reporting directly from our datastore. Cons Integrations aren't always as intuitive as with other tools, but this can be avoided with a solid internal knowledge base. Review Source Yanick T. CEO Manager Food & Beverages Used the software for: 1-2 years ### "Best Selection..." June 14, 2022 5.0 Pros What's special about Amazon Redshift is that it constantly offers new features to meet the demands of increasingly large data stores. It is undoubtedly the best solution for data storage and processing in the cloud. If you are not yet a user, I highly recommend it. Cons It takes time to get up to speed with all the features of Amazon Redshift. Review Source David W. Head of Engineering Information Technology and Services Used the software for: 2+ years ### "Possibly powerful AWS database, but not the greatest UX" April 6, 2022 4.0 Pros I like that Redshift is integrated with AWS and able to work with many AWS items, such as S3 buckets, and that it uses IAM for security. There's also a good range of AWS documentation, so in that regard, if you're an AWS environment it offers a lot of integration. Cons Redshift's UX leaves something to be desired. It has a query editor, and now a V2 query editor, but they're not awesome interfaces. Also some things you want to schedule you can only do if you create a Python-based AWS lambda rather than being able to do in Redshift itself - and even then you need to statically import a Python PostgreSQL library to connect to Redshift. It's all kind of disjointed. Review Source VR Verified Reviewer Senior Data Scientist E-Learning Used the software for: 6-12 months ### "Enter into the Dataverse" December 7, 2022 5.0 Pros The speed, reliability, and ease of use are top of mind. The setup makes it easier for developers to specify priority and rules around processes and queries, also AI-powered capabilities in the background can be an enormous aid. Cons The complexity of documentation, which is huge, and it can be challenging to find a specific answer). Review Source VR Verified Reviewer Data Architecht Internet Used the software for: 2+ years ### "Buenísimo DWH" February 20, 2023 5.0 Pros El rendimiento sin ningun tipo de duda, es potentísimo. Cons que no tenga un cliente de administración a la altura Review Source IN Iulian N. PM Information Technology and Services Used the software for: 2+ years ### "Works well, scales extremely well" August 3, 2022 5.0 Pros Easy to use, fast query speed, highly scalable, robust security and easy to upload data via AWS. Pricing is fair. Cons Table configuration process can be improved to make things easier. Review Source Ryan M. Senior Research Analyst E-Learning Used the software for: 6-12 months ### "Redshift is great but really expensive" June 22, 2022 5.0 Mostly positive once it is set up but the set up can be extremely challenging Pros I like that it was accessible across multiple devices and I like that it was possible to integrate with RStudio. That being said, sometimes my connections would just break if I didn't have the most up to date jar file and it was sometimes hard to figure out which jar file was the right one for the new version. Cons At times, my ODBC connections would just break or give weird errors and after hours of scrolling through the documentation, I am still confused Review Source VR Verified Reviewer CTO Retail Used the software for: 2+ years ### "Good DataWarehouse" November 28, 2022 4.0 Pros Redshift is a good data warehouse, if you have a good devops teams, it follows the rules of AWS so the setup good be ok. Cons Difficult to optmize, it could become quite expensive, and you need specialist if you want to use it well Review Source VR Verified Reviewer Engineer Information Technology and Services Used the software for: 6-12 months ### "ＳＱＬサーバーに慣れている運用者であれば好ましいツール" December 27, 2022 4.0 Pros 他のＡＷＳ製品だけでなく、ニッチな製品を含む多くのツールとデータのやり取りを行うことができる。 Cons ＳＱＬ言語をベースとしたコードなので、複雑なＥＴＬが必要な場合、コードが不要に長くなってしまったり、分かりにくく書かなければならない時がある。２０２２年初めにＰＩＶＯＴ関数が導入されたりと柔軟性は高まってきているものの、ループ処理など含め、やはり他のＥＴＬツールと比べると開発しづらい面がある。 Reason for choosing Amazon Redshift アウトプットを特定のＢＩツールと連携する必要があったため。 Review Source Similar Products Featured ## Related categories [Data Warehouse](https://www.capterra.com/data-warehouse-software/)[Business Intelligence](https://www.capterra.com/business-intelligence-software/)[Predictive Analytics](https://www.capterra.com/predictive-analytics-software/) ## Send me user reviews about this product ### Fill out the form and we'll send a list of the top-rated software based on real user reviews directly to your inbox.