That it's easy to use and has user friendly UI. Review collected by and hosted on G2.com.

Sometimes there are so many techs listed on aws website that's overwhelms us. Review collected by and hosted on G2.com.

If on AWS, Redshift is a great option for a data warehouse. For medium-sized data, this is a great way to manage, update tables. It works well with it's extension, Redshift Spectrum. Review collected by and hosted on G2.com.

Having always-on compute can be expensive if workloads are not consistent. Review collected by and hosted on G2.com.

With proper distribution style, compression, and data model, brings superior query performance. WLM queue is another great feature that helps manage the workload by provisioning proper memory allocation and concurrency levels for different user groups. Review collected by and hosted on G2.com.

Being the columnar database, the performance optimization technique is centered around the data colocation strategy using the proper distribution style. However, lack of ability to manage data in multiple partitions is sometimes challenging in scenarios where one needs to deal with a multi-tenant environment. Another challenge is a tradeoff between dense storage and dense compute nodes - in current days where storage has become very cheap, the storage cost of Reshift is still very high. Often it is difficult to choose between compute over storage or vice versa. Review collected by and hosted on G2.com.

It is very faster due to columnar data storage. Easy to deploy code.

Can be scaled quickly and most importantly is very secure. Cost effective. Review collected by and hosted on G2.com.

Redshift doesn't have any tool to ensure data uniqueness. There can be redundant data points. Review collected by and hosted on G2.com.

Everything, the performance, management, and efficiency of the clusters are excellent, in addition to the integration with the rest of AWS services like S3 and Kinesis. Review collected by and hosted on G2.com.

The truth is that nothing in particular, maybe the only thing I miss is a specific client that matches everything it can offer, but as a tool itself, nothing to reproach. Review collected by and hosted on G2.com.

Redshift is awesome for handling semi-structured data in data warehouse and what i liked the most is exceptional support for ETL process. Review collected by and hosted on G2.com.

Integration and support for standalone tools like BDM Review collected by and hosted on G2.com.

It offers ample amount of commands to be used especially for uploading of data to files. You can also use in to unload different types of files and in parts as well. Review collected by and hosted on G2.com.

It is very difficult to integrate it with other AWS resources as it invoices a lot od hustle woth security constraints and access issues. This can be simplified. Review collected by and hosted on G2.com.

It's highly scalable and offers low latency / managed cloud data management solutions for analytical workloads. The documentation is one of the best across cloud providers! Review collected by and hosted on G2.com.

I wish it could have offered better integrations with other data warehouses and data sources from different cloud providers/data center, which would be most needed to make multi-tenant setup easy for Analytical workloads, which is often from diverse sources and platforms. Review collected by and hosted on G2.com.

i found it's support to analysis data using sql way for structed & nom structured data Review collected by and hosted on G2.com.

i didn't find anything yet, it is actually gooad as industry standard Review collected by and hosted on G2.com.

It helps in performing analytics and gaining insight from the whole dataset rather than taking samples from the data and combining them, which may lead to erroneous insight. Review collected by and hosted on G2.com.

It is hard to train new individuals as it many of it's functions seem to be redundant and behind the times compared to it's competition. Review collected by and hosted on G2.com.