Item: Amazon Redshift
Rating: 2
Author: Verified User

Use Cases and Deployment Scope

Amazon Redshift was our enterprise data warehouse as a backend to our BI solutions.

Pros and Cons

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.

Return on Investment

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.

Support Rating

We had premium AWS support so can't speak about support for those who don't sign up for it.

Key Insights

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

Are you happy with Amazon Redshift's feature set?

Did Amazon Redshift live up to sales and marketing promises?

Did implementation of Amazon Redshift go as expected?

I wasn't involved with the implementation phase

Would you buy Amazon Redshift again?

Other Software Used

Snowflake, Terraform

Likelihood to Recommend

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,

Redshift Review

Overall Satisfaction with Amazon Redshift