Amazon Redshift Reviews & Product Details - Page 29

bulk data load, integration with firehose, cluster management. Review collected by and hosted on G2.com.

duplicates handling, no key enforcement. Review collected by and hosted on G2.com.

fast query processing.

Easy to scale up and down the clusters.

User friendly AWS console. Review collected by and hosted on G2.com.

Nothing so far.

I have been able to get all the benefits I can from a data warehousing tool. Review collected by and hosted on G2.com.

Easy to configure and implement the solutions Review collected by and hosted on G2.com.

Still did not find the problem working with AWS Redshift Review collected by and hosted on G2.com.

It is fast, we can use it concurrently and we can use SQL over it so we don't have to learn a new language. The Redshift dashboard allow us to cancel request that take too much ressources. We can optimize to allow the request to run faster (with indexing) and the data to take less space on the disk (with column formatting and compression) Review collected by and hosted on G2.com.

It is a little bit expensive if we want both performance and disk space. It's quite easy to use all the disk space available as the data is replicated by default. Sometimes the errors are difficult to find as we have to request specific system table. They could have been available in the AWS console. Review collected by and hosted on G2.com.

The Speed of data processing and ease of setup on AWS using columnar storage and integration to S3 using Spectrum Review collected by and hosted on G2.com.

Expect auto scalability and on demand compute Review collected by and hosted on G2.com.

AWS Redshift is the cloud-based data warehouse. It's query script is very easy and familiar to other SQL query.

Its support a wide range of data variables.

Due to in cloud, no compliance issue for sensitive data.

Query execution on complex dataset is fast.

Easy to load data from different sources like S3, EC2 or web. Review collected by and hosted on G2.com.

For the new user, schema design is quite complex.

Even GUI for admin is not that much simple Review collected by and hosted on G2.com.

Amazon’s reputation as first movers in this space gives me confidence in their stability. They’ve already seen roadblocks and issues that other providers start to run into Review collected by and hosted on G2.com.

I would prefer support for more languages and interfaces from the user side to connect with Review collected by and hosted on G2.com.

the copy and unload to file support was great

and supports all psql features well

cluster management.

query history etc .. Review collected by and hosted on G2.com.

performance and the space was tightly coupled , some syntax's ware different from psql

computation power and memory should be decoupled Review collected by and hosted on G2.com.

I like that the SQL syntax is very similar to Oracle SQL which makes transitioning to Redshift easy. We currently use it as a data warehouse. Review collected by and hosted on G2.com.

I don't like that we can't update an S3 file directly from Redshift when you create an external table. A lot of the times writing from redshift is as important as reading from the S3 file. Review collected by and hosted on G2.com.

I like the online resources available. SQL Syntax is easier to work with compared to other SQL software. Review collected by and hosted on G2.com.

I dislike that there isn't enough user-generated resources online. Most of the only resources about SQL are about MySQL or SQL Server but not redshift, and given the slightly different syntax, a lot of the online help is not easily transferrable. Review collected by and hosted on G2.com.