Amazon Redshift Reviews & Product Details

The most helpful part of Amazon Redshift is that it allows large quantity of data warehouse service in cloud. It offers tools that help in administrating a database and hence is termed as Massively Parallel Processing Db. Review collected by and hosted on G2.com.

The least helpful part of Amazon Redshift is that the data types such as JSON and XML are not fully supported as working with the data with unsupported format can lead to various tedious tasks. Review collected by and hosted on G2.com.

Amazon Redshift provides robust security features to protect data, including authentication and access control. Ease of use and user-friendly with SQL-like query quality and ease of implementation. Amazon Redshift has high-performance analytics and can process complex queries quickly. Review collected by and hosted on G2.com.

Not necessarily disadvantages of Amazon Redshift but rather aspects that organizations should be aware of when evaluating and using the services. And complex for new users. Review collected by and hosted on G2.com.

- Fully-managed, petabyte scale data warehouse service.

- Integration with other AWS Services.

- Short Query Acceleration (SQA) Review collected by and hosted on G2.com.

- Data write with EMR is slow.

- Can't use for the Unstructured data Review collected by and hosted on G2.com.

The overall features, support, and availability are great. Amazing way to run all kinds of DB on the platform. Easy to for hardware processing and patching activities. Review collected by and hosted on G2.com.

More documentation and support that will be helpful Review collected by and hosted on G2.com.

Speed, price, and the ease of use. The serverless option make it so much faster and easier to manage the system itself. Review collected by and hosted on G2.com.

Dealing with relationships more like a traditional RDS database could be helpful. Review collected by and hosted on G2.com.

Most helpful and upside using Amazon Redshift is that it's security and E2E encryption. And its support for multi query which results in high speed performance and best features Ibhave used for Redshift are data warehousing techniques and auto scaling and auto backup. And aws data pipline. For loading data files. Review collected by and hosted on G2.com.

Least helping for there is nothing as of now. Integration and deployment need documentation Review collected by and hosted on G2.com.

Its web-based console allows us to quickly provision new clusters, monitor usage, and scale resources up or down as needed. Additionally, it integrates seamlessly with other AWS services, so overall it is a powerful data warehousing solution that is definitely worth considering. Review collected by and hosted on G2.com.

One potential downside is its cost, which can add up quickly for large amounts of data. Additionally, the learning curve for using Amazon Redshift can be steep for users unfamiliar with cloud-based data warehousing solutions. Finally, the lack of built-in functionality for specific data types can make working with certain types of data complex. Review collected by and hosted on G2.com.

Building data lake using Redshift is excellent. It's columnar storage feature is the one the best feature. Querying large datas with efficient parallel processing and dara compression was not thats efficient. Easy of data loading to Redshift. Review collected by and hosted on G2.com.

Backing up data to ES3 could be better or more efficient. Auto backup is great. Review collected by and hosted on G2.com.

* Cheapest Data Warehouse in the market.

* Highly Scalable

* With a high-value brand name backing it, people trust it.

* Integration with a ton of different applications is probably it's most direct feature. Review collected by and hosted on G2.com.

* The pain to COMMIT all the DDLs and DMLs manually (or tick the box) when it should be by default.

* Missing the ability to run ACID compliant queries directly on Data Lake.

* Missing Delta Lake Capabilities. Review collected by and hosted on G2.com.

It has all types of enhancements, integration, metric calculations and a lot more features such as lambda, s3, putty, memory instances, putty features which help us to thoroughly enjoy the AWS features and queries the AWS table as fast as possible. Review collected by and hosted on G2.com.

There is nothing we can dislike about AWS. It's the best. And the support team here is amazing. Whenever we face a glitch they are help to us 24/7. What else is there to complain. Negative. Review collected by and hosted on G2.com.