Amazon Redshift Reviews & Product Details - Page 8

Amazon Redshift provides cost advantages over other popular cloud data warehouses. It's scalable, available and easily integrates with AWS infrastructure. Review collected by and hosted on G2.com.

Storage and Compute is tightly coupled.. Review collected by and hosted on G2.com.

Data Engineering

Speed

Scalability

Cloud

Querying Review collected by and hosted on G2.com.

I think its expensive compared to Azure suite Review collected by and hosted on G2.com.

Everything being contained in the AWS environment is a big plus. S3, Redshift, Spectrum, MWAA all working together and billed together. It's a lot easier to get approvals and such. It also has a lot of support with external tools such as dbt. Review collected by and hosted on G2.com.

There are some very specific problems related to my use case (analytics engineering). The documentation around SUPER fields was awful and it was hard to figure out how to use them. Also bizarrely there is no IF statement in Redshift queries. Comparing it to Presto, there are a lot less functions. Review collected by and hosted on G2.com.

Highly automated service is definitely what I was looking for. Review collected by and hosted on G2.com.

There is nothing that one state as not likeable. Review collected by and hosted on G2.com.

Easy to set up, deploy, & manage. Automated provisioning. Review collected by and hosted on G2.com.

Nothing,

I like this product. Good experience. Review collected by and hosted on G2.com.

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 performance 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.