2018-09-04T14:04:00Z

What needs improvement with Amazon Redshift?


Please share with the community what you think needs improvement with Amazon Redshift.

What are its weaknesses? What would you like to see changed in a future version?

Guest
77 Answers

author avatar
Top 5Real User

It would be useful to have an option where all of the data can be queried at once and then have the result shown. As it is now, when we run a query and we are looking at the results, part of the data remains to be processed at the back end. That works very well, but in some cases, we require the whole data to be queried at once and then have the results shown. We have not faced many use cases where it would have been useful, but in one or two, we used other methods to achieve this goal. When our clients contact customer support, they don't want to speak with a machine. Instead, they want to chat with a real person who can provide a solution. Customer service bots can provide solutions but they cannot understand our problems.

2020-01-22T12:44:00Z
author avatar
Real User

Pricing is one of the concerns that I have because if you compare Snowflake with Redshift, it provides some of the same services, but at a much cheaper rate. So pricing is one of the things that it could improve. It should be more competitive. Otherwise, everything else looks good, especially the data storage and analytical processes.

2020-01-12T07:22:00Z
author avatar
Top 5LeaderboardReal User

From my perspective, the product could be improved by making it more flexible. There are now more flexible products on the market that allow for expandability and dynamic expansion as the market changes with regard to data warehouses. Although the product is simple to use there can be problems. If you declare some unique key in a column and then store it, the database is going to believe this is what you have and results will be distorted. It's fine if the query is simple but if it's complex or you have too many queries per hour, it can create a bottleneck for Redshift and then you can't return and recover. It requires some fine-tuning. For additional features, I would like to see support for partitions, it doesn't exist yet as a feature. It's quite an important issue when you're dealing with large databases. Also, I believe the product needs improvement in parallel threading to support more database users without jeopardizing performance.

2019-11-27T05:42:00Z
author avatar
Top 10Real User

Running parallel queries results in poor performance and this needs to be improved.

2019-11-07T10:35:00Z
author avatar
Real User

The speed of the solution and its portability needs improvement.

2019-10-13T07:07:00Z
author avatar
Top 20Real User

Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions. That's a big problem now.

2019-07-31T05:52:00Z
author avatar
Real User

In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations.

2018-09-04T14:04:00Z
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: June 2020.
442,041 professionals have used our research since 2012.