Amazon Redshift Reviews & Product Details

Amazon Redshift’s biggest advantage is how naturally it fits into the wider AWS ecosystem, especially S3, IAM, and AWS Glue. Its Massively Parallel Processing (MPP) architecture tackles complex multi-table joins across massive datasets—10M+ records—with little friction, which matters when teams need fast, exploratory analysis and fraud modeling.

Redshift Spectrum adds another layer of usefulness. It lets us query cold or unstructured data straight from our S3 data lake with standard SQL, avoiding the overhead and cost of loading everything into the warehouse first. Since it’s based on familiar PostgreSQL syntax, analysts and engineers can ramp up quickly. Redshift also provides a highly predictable pricing and performance model, making enterprise cloud compute costs easier to manage at scale than with many other modern data warehouses. Review collected by and hosted on G2.com.

Scaling compute isn't as instant as I'd like. The separation of compute and storage still feels less flexible compared to Snowflake. Concurrency can also be a real headache. When too many analysts hit the cluster with heavy queries at once, things queue up and slow down. It also requires a bit too much manual maintenance under the hood. You still have to stay on top of vacuuming and analyzing tables to keep query performance sharp. Review collected by and hosted on G2.com.

Amazon Redshift is a powerful cloud data warehouse that makes it easier to manage and analyze large volumes of data. As a Data Engineer, I find it especially useful for building ETL pipelines, running complex SQL queries, and integrating data from Amazon S3 as well as other AWS services. Features like columnar storage, parallel query execution, and tight integration with AWS Glue and Amazon Athena make it a strong fit for modern data engineering workflows. I also appreciate the flexibility to scale resources up or down based on workload requirements, which helps when demands change. Review collected by and hosted on G2.com.

Query performance and cost optimization take careful planning, especially when you’re working with large datasets and complex transformations. Picking the right table design, distribution style, and sort keys can be time-consuming, but it makes a real difference. It’s also important to keep a close eye on resource utilization and to identify and tune expensive queries so costs stay under control. Review collected by and hosted on G2.com.

What I like best about Amazon Redshift is its seamless integration with the AWS ecosystem. Querying data directly in S3 with Spectrum and using familiar SQL makes analysis fast and simple, while Redshift Serverless removes most of the infrastructure management. It handles large datasets with strong performance and scales easily as our needs grow. Review collected by and hosted on G2.com.

The main downside is that performance tuning can take effort. Choosing the right sort keys and distribution styles and running maintenance like vacuuming isn’t always intuitive. Costs can also be hard to predict, especially with heavy or spiky workloads, and concurrency can become a bottleneck when many users query at once. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Amazon Redshift provides excellent performance for large-scale data warehousing and analytics workloads. I like its seamless integration with AWS services, fast query execution, scalability, and ease of managing huge datasets. The pricing flexibility and support for BI/reporting tools make it very useful for enterprise analytics solutions Review collected by and hosted on G2.com.

The main downside is that query optimization and cluster management can be complex for beginners. Costs can increase quickly if resources are not monitored and optimized properly Review collected by and hosted on G2.com.

I have used Redshift for 4 years. I like the easy to use it, create instance and use as data warehouse. Since it cloud native for AWS so easily integrate with other AWS service. New cluster has good performance and price is bit higher. AWS Support is good and helped when asked for an issue. It can be integrated with Bedrock for AI use cases but at initial level. Review collected by and hosted on G2.com.

Not easy to integrated for other sources and make it difficult to manage. Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

I find it really easy to set up and maintain Amazon Redshift, which helps me get started quickly without needing much upskilling. Review collected by and hosted on G2.com.

The pricing is a bit complex, especially with AWS in general, and Amazon Redshift is no exception. Also, sometimes I find it runs quite slow, even without the need to be maxed out. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

It’s easy to integrate with other software, works well with Amazon Redshift, and makes it fast to query data. Review collected by and hosted on G2.com.

ui can be more interactive as right now everthing look clustered Review collected by and hosted on G2.com.