# Amazon Redshift Reviews **Vendor:** Amazon Web Services (AWS) **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.3/5.0 **Total Reviews:** 401 ## About Amazon Redshift Tens of thousands of customers use Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions. ## Amazon Redshift Pros & Cons **What users like:** - Users value the **ease of use** in Amazon Redshift, appreciating its straightforward setup and seamless integration with AWS services. (7 reviews) - Users value the **seamless integrations** of Amazon Redshift with AWS services, enhancing data warehousing and analytics capabilities. (7 reviews) - Users appreciate the **easy integrations** of Amazon Redshift with AWS services, enhancing their data solution workflows effortlessly. (5 reviews) - Users value the **fast querying** capabilities of Amazon Redshift, benefiting from its impressive speed and scalability for data analysis. (5 reviews) - Users praise the **scalability** of Amazon Redshift, enabling effortless handling of vast data volumes with speed. (5 reviews) - Customer Support (4 reviews) - Features (4 reviews) - Users value the **efficiency in managing large datasets** with Amazon Redshift, making complex queries seamless and fast. (4 reviews) - Performance (4 reviews) - Users value the **speed and efficiency** of Amazon Redshift, enhancing their ability to manage large datasets seamlessly. (4 reviews) **What users dislike:** - Users find the **complexity of optimizations** in Amazon Redshift to be burdensome, requiring significant management and maintenance effort. (5 reviews) - Users note the **feature limitations** of Amazon Redshift, particularly in advanced analytics and unstructured data support. (5 reviews) - Users find **software limitations** in Amazon Redshift, noting challenges with performance, concurrency, and support for unstructured data. (5 reviews) - Users face **query issues** that require time and expertise for optimization, affecting performance and concurrency management. (4 reviews) - Users find **query optimization challenging** in Redshift, requiring significant effort to maintain performance and manage resources. (4 reviews) - Expensive (3 reviews) - Integration Issues (3 reviews) - Performance Issues (3 reviews) - Users find **slow query performance** in Amazon Redshift challenging, needing significant time for optimization and tuning. (3 reviews) - Complex Processes (2 reviews) ## Amazon Redshift Reviews ### 1. Powerful Analytics Tool with Some Flexibility Limitations **Rating:** 4.0/5.0 stars **Reviewed by:** Atharva P. | Cloud BI Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 08, 2026 **What do you like best about Amazon Redshift?** I like Amazon Redshift because it solves large-scale data warehousing and analytics challenges by providing a centralized platform for storing and querying massive datasets. It enables faster reporting and better business insights, offering scalable analytics for enterprise workloads. I also appreciate its tight integration with AWS and its AI features, like automated workload management and query optimization. **What do you dislike about Amazon Redshift?** Cluster sizing, tuning, and cost optimization require very careful management. Performance can degrade if distribution keys and sort keys are not designed properly. Not very flexible as compared to Snowflake or BigQuery. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift solves large-scale data warehousing and analytics challenges. It provides a centralized platform for storing and querying massive datasets, enabling faster reporting and better business insights, with scalable analytics. It's tightly integrated with AWS and offers strong SQL support and high query performance. ### 2. Fast, Scalable Data Warehouse with Strong AWS Integration **Rating:** 5.0/5.0 stars **Reviewed by:** Ankit K. | Business Analyst, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** March 17, 2026 **What do you like best about Amazon Redshift?** fast query performance on large datasets, scalable data warehouse, strong integration with AWS ecosystem, columnar storage for analytics, good for structured data workloads, reliable for reporting and BI **What do you dislike about Amazon Redshift?** query performance can degrade without optimization, concurrency limitations on heavy workloads, maintenance and tuning effort required, scaling is not fully seamless, cost can increase with usage **What problems is Amazon Redshift solving and how is that benefiting you?** centralized data warehousing, faster analytics on large datasets, improved query performance for reporting, better integration with BI tools, enables data-driven decision making ### 3. Powerful Data Warehousing with Speed, but Lacks Out-of-the-Box Optimizations **Rating:** 3.5/5.0 stars **Reviewed by:** Rishav M. | Data Engineer 2, Mid-Market (51-1000 emp.) **Reviewed Date:** October 13, 2025 **What do you like best about Amazon Redshift?** What I like best about Amazon Redshift is its ability to handle massive amounts of data with impressive speed and scalability. It’s designed specifically for data warehousing, so complex queries run efficiently thanks to its columnar storage and massively parallel processing (MPP) architecture. Plus, it integrates smoothly with the AWS ecosystem, making it easier to build end-to-end data solutions accompanied by existing backend infrastructure. **What do you dislike about Amazon Redshift?** In terms of optimizations, there are very little things that come out of the box. A significant amount of effort is required to optimize Redshift. - We have to manage the clusters and nodes since its not a serverless solution (not talking bout spectrum here!) - Concurrency issues when it is being used by a large number of users. We've had to set up limits and checks in place separately, which is a bit annoying. - There's a lot of maintenance overhead. Tasks like vacuuming and analyzing tables to maintain performance still require attention and adds lots of operational complexity. **What problems is Amazon Redshift solving and how is that benefiting you?** In my previous companies, we decided to build out a pandas based reporting solution on top of a data warehouse. We had billions of rows of historical retail data which was ingested into Redshift from our OLTP systems via DMS. We chose Redshift for this since we were already in an AWS environment and it offered easy integrations. - Redshift's columnar nature helped in crunching and aggregating huge data volumes, making it ideal for our reporting solutions. - There are some nice optimizations like sort keys and distribution keys and vacuuming which helps to query the data faster. Though this takes quite some time to set up. - New improvements like Redshift Spectrum also help in querying raw data residing in S3 buckets for adhoc use cases. Overall, I've been satisfied with the product for usecases with small-to medium size data load. ### 4. Easy Integration with Amazon Redshift for Fast Data Queries **Rating:** 4.5/5.0 stars **Reviewed by:** Anup K. | Business Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** February 19, 2026 **What do you like best about Amazon Redshift?** It’s easy to integrate with other software, works well with Amazon Redshift, and makes it fast to query data. **What do you dislike about Amazon Redshift?** ui can be more interactive as right now everthing look clustered **What problems is Amazon Redshift solving and how is that benefiting you?** we uses aws datawarehouse and currently work faster when we have query without joins ### 5. Reliable and scalable data warehouse with room for improvement **Rating:** 4.5/5.0 stars **Reviewed by:** Kathy L. | Director, Mid-Market (51-1000 emp.) **Reviewed Date:** August 27, 2025 **What do you like best about Amazon Redshift?** Amazon Redshift provides excellent scalability for handling large volumes of structured data and integrates smoothly with other AWS services like S3 and Glue. Query performance is strong for analytical workloads, and the columnar storage significantly speeds up aggregation queries. The ability to separate storage and compute has improved cost management and flexibility, making it easier to scale resources up or down depending on workload needs. **What do you dislike about Amazon Redshift?** While powerful, Redshift can become costly at scale if not carefully monitored and optimized. Query performance sometimes degrades when dealing with complex joins or semi-structured data compared to newer cloud-native solutions. Managing concurrency can also be a challenge, and performance tuning requires specialized knowledge. Additionally, native support for unstructured data is still limited compared to alternatives. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift helps consolidate data from multiple sources into a centralized data warehouse, making it easier to run analytical queries at scale. This has allowed our team to generate business insights much faster compared to traditional databases. By leveraging its integration with AWS services like S3 and Glue, we’ve automated our ETL pipelines, reduced manual data preparation, and improved reporting speed. It has also helped optimize decision-making by giving stakeholders near real-time access to dashboards and analytics. ### 6. Good Product **Rating:** 5.0/5.0 stars **Reviewed by:** Manh N. | Inventory Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** July 29, 2025 **What do you like best about Amazon Redshift?** What I like best about Amazon Redshift is how easy it is to connect and get started. The interface is user-friendly, and the connection is fast, which makes querying large datasets smooth and efficient. **What do you dislike about Amazon Redshift?** "So far, I haven’t encountered anything I dislike about Amazon Redshift. It’s been reliable and has met my needs well. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift makes it way easier to handle and analyze large amounts of data without everything slowing down. I can run big queries and get results fast, which really helps when I need to make decisions quickly or build reports. It also pulls data from different sources into one place, so I don’t have to waste time jumping between tools ### 7. Easy to Use, Scalable, and Simple to Connect with Other Software **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Utilities | Mid-Market (51-1000 emp.) **Reviewed Date:** March 16, 2026 **What do you like best about Amazon Redshift?** Easy to use, scalable, easy to connect to other software **What do you dislike about Amazon Redshift?** Sometime sis hard to translate the data types from other RDBMS but usually you can find a way to sync them **What problems is Amazon Redshift solving and how is that benefiting you?** We are using it as a datawarehouse in the project I'm on ### 8. Easy to scale up and down, cost effective and easy to integrate with EMR and lambda **Rating:** 5.0/5.0 stars **Reviewed by:** Antarix K. | AI Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** October 12, 2025 **What do you like best about Amazon Redshift?** Easy to scale up and down, Multi zone architecture for data safeguarding. Easy to scale schedule. Easy logs access. Easy to setup and simple to inject data using EMR and lambda and Auto Sharing is great help. **What do you dislike about Amazon Redshift?** Query queuing and concurrency issues.At times Auto distribution style does not work wonders and needed to be changed. **What problems is Amazon Redshift solving and how is that benefiting you?** Data ingestion and massaging and manipulation for serving BI reports and ML models to use train on. ### 9. Amazon Redshift: Feature-Rich Cloud Data Warehouse with Excellent Support **Rating:** 3.5/5.0 stars **Reviewed by:** Yogesh K. | Senior software engineer 2, Enterprise (> 1000 emp.) **Reviewed Date:** October 23, 2025 **What do you like best about Amazon Redshift?** cloud-based data warehousing service, easy to access and manage, great support, lots of features, available to be integrated and used with many other platforms **What do you dislike about Amazon Redshift?** higher cost, few limitations to some data types **What problems is Amazon Redshift solving and how is that benefiting you?** flexibility and easy of usage of data at one place to be managed efficiently solving the problem of looking for multiple options for one problem ### 10. Amazon Redshift: Powerful and Scalable Data Warehousing for Seamless Analytics **Rating:** 4.0/5.0 stars **Reviewed by:** Prakash G. | Data Migration Specialist, Data Engineering Manager, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** November 15, 2024 **What do you like best about Amazon Redshift?** Amazon Redshift has an easy to use and setup gives teams of all sizes access to data warehousing and analytics. It’s got robust feature and it integrates well with other AWS services to make it easy to implement and scale. Their customer support is reliable and their use frequency adds a value by using their analytics which give us important insights about our business. **What do you dislike about Amazon Redshift?** While powerful, Amazon Redshift can be expensive to process on a large scale with increasing amount of data. Complex joins can slow down query performance, and tuning is an expertise. In high demand environments there is limited support for unstructured data and frequent optimization can be difficult, especially for daily operations. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift helps satisfy our demand for fast data warehousing by giving us blazing fast query performance in large datasets to run daily reporting and analytics. While complex data queries can occasionally be performance challenging, it provides our center data, which in turn helps us to gain better insights, and better decisions which in turn helps in our business operation and strategy planning. ## Amazon Redshift Discussions - [Should I use with a data mart for a frontend tool that make request on it ?](https://www.g2.com/discussions/should-i-use-with-a-data-mart-for-a-frontend-tool-that-make-request-on-it) - 3 comments, 3 upvotes - [Is Amazon redshift good for large datasets considering its cost.](https://www.g2.com/discussions/is-amazon-redshift-good-for-large-datasets-considering-its-cost) - 2 comments, 1 upvote - [Is AWS redshift a database?](https://www.g2.com/discussions/is-aws-redshift-a-database) - 1 comment - [When can I use Amazon redshift?](https://www.g2.com/discussions/when-can-i-use-amazon-redshift) - 3 comments - [What are the characteristics of redshift?](https://www.g2.com/discussions/what-are-the-characteristics-of-redshift) - 2 comments - [View Amazon Redshift pricing details and edition comparison](https://www.g2.com/products/amazon-redshift/reviews/amazon-redshift-review-3077051?section=pricing&secure%5Bexpires_at%5D=2026-05-12+17%3A57%3A18+-0500&secure%5Bsession_id%5D=3e516f7b-c2b1-4f89-aad7-daf0efdceab8&secure%5Btoken%5D=b9f46eaedddafba365a0660e68561e53e3f61942b35518179880dce402b8b47c&format=llm_user) ## Amazon Redshift Integrations - [Amazon AppFlow](https://www.g2.com/products/amazon-appflow/reviews) - [Informatica Data Engineering](https://www.g2.com/products/informatica-data-engineering/reviews) - [Liquibase](https://www.g2.com/products/liquibase/reviews) - [Metabase](https://www.g2.com/products/metabase/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) ## Amazon Redshift Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Storage** - Data Model - Data Types **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Availability** - Auto Sharding - Auto Recovery - Data Replication **Deployment** - On-Premise - Cloud **Performance** - Integrated Cache **Performance ** - Scalability **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Security** - Data Governance - Data Security **Support** - Multi-Model - Operating Systems **Generative AI** - AI Text Generation - AI Text Summarization ## Top Amazon Redshift Alternatives - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,156 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (687 reviews) - [OpenText Vertica](https://www.g2.com/products/opentext-vertica/reviews) - 4.3/5.0 (195 reviews)