Redshift Review
Anonymous | TrustRadius Reviewer
November 30, 2019

Redshift Review

Score 2 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Amazon Redshift

Amazon Redshift was our enterprise data warehouse as a backend to our BI solutions.
  • Fixed cost.
  • Tunable table design.
  • Need to provision warehouse for highest capacity.
  • No real separation between computing and storage (even when considering Spectrum).
  • All users share the same infrastructure resulting in frequent 100% utilization error messages.
  • A leader node can become a bottleneck for too many concurrent aggregate queries.
  • Constant killed queries.
  • Not much performance boost in terms of the cache.
  • Users perceived the data warehouses as incapable of supporting widespread usage throughout the enterprise.
We like Snowflake for its separation of computing and storage and also the separation of data warehouse different users. We replaced Redshift with Snowflake. However, Snowflake is great for its pay for performance kind of methodology.
We had premium AWS support so can't speak about support for those who don't sign up for it.

Do you think Amazon Redshift delivers good value for the price?

No

Are you happy with Amazon Redshift's feature set?

No

Did Amazon Redshift live up to sales and marketing promises?

No

Did implementation of Amazon Redshift go as expected?

I wasn't involved with the implementation phase

Would you buy Amazon Redshift again?

No

Redshift is appropriate when the number of concurrent users are low and pointed queries are the focus. It is not appropriate when a large number of concurrent users is to be supported,