Amazon Redshift Reviews & Product Details

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.

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.

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

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

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

"So far, I haven’t encountered anything I dislike about Amazon Redshift. It’s been reliable and has met my needs well. Review collected by and hosted on G2.com.

Easy to use, scalable, easy to connect to other software Review collected by and hosted on G2.com.

Sometime sis hard to translate the data types from other RDBMS but usually you can find a way to sync them Review collected by and hosted on G2.com.

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

Query queuing and concurrency issues.At times Auto distribution style does not work wonders and needed to be changed. Review collected by and hosted on G2.com.

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

higher cost, few limitations to some data types Review collected by and hosted on G2.com.

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

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

Amazon Redshift is a game-changer, allowing us to have highly scalable and performance-enabled data warehousing for the complex project. The MPP architecture and columnar storage offer powerful query performance on the platform. Redshift also allowed us easily to integrate several AWS services, such as using S3 for data imports and Glue for ETL operations, and made our pipeline very streamlined so that data transfer and queries were decreased by many times.

With Spectrum, Redshift can handle structured as well as semi-structured data, which will allow efficient cross-database queries and productivity boost with regards to data analytics and reporting. Advanced data compression features and data distribution ensure that storage is optimally utilized while efficiently making use of and managing costs on resources. Review collected by and hosted on G2.com.

Though performance and scalability of Redshift are excellent, the system is not very easy to use for optimization and query tuning for new users. Automated tools for better configuration will enable it to reach a diverse set of teams. Review collected by and hosted on G2.com.