Pay as per usage

Ese of use

Nice UI

has many features associated with AWS Review collected by and hosted on G2.com.

No free tech support

Versioning is not free Review collected by and hosted on G2.com.

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

The least hepful part fo Amazon Redshift is that the datatypes 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 provide robust security features to protect to data including authentication and access control.

Ease of uses and find 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 organisation 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.

Backup ing 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.