Amazon Redshift Room for Improvement
I would like a better way to ingest data in realtime because there is a bit too much latency.
There are too many limitations with respect to concurrency. It is now possible to auto-scale it, although that is still slow.
It could offer smaller nodes with decoupling of storage and processing because for the moment, the only nodes available to work that way are huge, and for large companies.View full review »
I would like to see improvement in the pricing and the simplicity of using this solution.View full review »
We have had some challenges with respect to considering some of the high-end availability architecture for production. We don't find many issues now, but initially, we had some challenges.
This is an older product, so when it comes to usability, it requires a technical person to work with it. It requires a specialist and a good business case to work on it. It has to be a little more user-friendly than what it is today.
In our experiments, the handling of unstructured data was not very smooth.View full review »
Financial Performance Manager at a retailer with 1,001-5,000 employees
We need more AWS applications. They have some solutions from Amazon that can manage performance, however, we will need something that can also manage financial reporting, visualization, and analytics - instead of having to go to other solutions like Tableau or Power BI. If they can offer comparable options, we'd like to be able to choose all AWS solutions instead of other platforms.
The refreshment rate of data reaching Redshift from other sources should be faster.
It could be more efficient during tasks such as data refreshing or uploading.View full review »
Engineering Manager/Solution architect at a computer software company with 201-500 employees
This solution could be cheaper, but Amazon could constantly add new instances and decrease the size from previous ones, so it could be an AWS work model.
It would also be better if it can be integrated with non-AWS sources, e.g. additional open source connectors.
Data Analyst at a tech vendor with 51-200 employees
I cannot state which features of the solution are in need of improvement, since those which we make use of have not changed.
The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number.
I rate the solution as an eight out of ten because it is not 100 percent, as there is much service-related maintenance required. It would be nice to see support for the usual LTP features, such as those involving traditional processing.View full review »
We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues.
In an upcoming release, I would like to have a Snowflake-like feature where we can create another cluster in the same data warehouse, with the same data. You can create a different cluster and compute nodes for each of your use cases, for retail, and for your data analyst all while keeping your underlying data safe.
Additionally, the cluster resize process takes down the cluster for too long, approximately 15 minutes. There are limitations to the size, you can resize only by a multiplier of two, for example, if you have four nodes then you can either go to eight nodes or you can come down to two nodes. There should be fewer limitations.View full review »
Redshift is a multi-tier engine that works like a calculator. There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity. Sometimes I'd like for them to support some special features or some special installations because we need automatic populations. I would like to see more programming outside of the cloud. I would like to see more functionalities under JSON files. the only functionality that they have now with JSON is reports. I would also like to see other data sources like MongoDB.View full review »
Senior Consultant at a tech services company with 1,001-5,000 employees
Improvement could be made in the area of streaming data. The capability can definitely be improved. There are other products like Kinesis which is a separate service we use for streaming data ingestion. Whatever features are missing in Redshift, they have separate sources but if there were the feasibility to ingest real-time streaming data directly into RedShift, that would be very useful.
Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics.View full review »
We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself.View full review »
Consultant at a tech services company with 51-200 employees
Amazon Redshift could improve the user interface support.View full review »
Manager at Protiviti
The technical support should be better in terms of their knowledge, and they should be more customer-friendly.View full review »
Senior Solutions Architect at a retailer with 10,001+ employees
Planting is the primary key enforcement that should be improved but there is probably a reason that they don't follow the reference architecture. It means they are creating clones of the data shading. Cost control measures could be improved along with added transparency.View full review »
Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure.View full review »