Amazon Redshift Reviews

145 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Do you work for this company? Learn how we help vendors

TrustRadius Top Rated for 2020

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-22 of 22)

Companies can't remove reviews or game the system. Here's why.
Jay Padhya | TrustRadius Reviewer
February 26, 2020

Amazon Redshift: Fastest but comes at a price

Score 9 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Amazon Redshift has a better UI, hands down. And it is easy to integrate with bigger tools like Talend. It has many issues when it comes to understanding the architect perspective like Toad, which has a better UI for architect data together. However, that is because we are not used to many features of Amazon Redshift. I like how they don't change the UI often like Azure, making it harder to adjust to the new tool look and feel.
Read Jay Padhya's full review
Arthur Zubarev | TrustRadius Reviewer
October 10, 2019

Amazon Redshift Review

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Azure SQL Database was discarded because of a less attractive licensing, costs, plus its integrates poorly with many of the Azure offerings as say Azure Data Factory - it is not a true ETL yet. Also, the rest of the tools used were of Open Source type and it did not look like a good fit for Azure.
AWS Aurora in Postgres mode could be easier to migrate, but it wasn't that much cheaper than Redshift, minus its limitations.
Snowflake looked like the most promising and yet modern data warehousing solution that is able to elastically autoscale and provision more connections than Redshift, but it wasn't in wide use and hard to experiment with (not a native AWS citizen and wasn't whitelisted in GCP back then).
Redshift won because most of the developers and analysts knew Postgres.
Read Arthur Zubarev's full review
Akshaya Bhardwaj | TrustRadius Reviewer
July 09, 2019

Amazon RedShift is great if you have multiple data channel sources

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

It works on the cloud and we use the platform Dbeaver which is very unique and easy to maintain. There are very limited tools of this kind but the security issues are pretty high within those tools.
Read Akshaya Bhardwaj's full review
Jacob Biguvu | TrustRadius Reviewer
June 08, 2019

Amazon Redshift: easy, simple, fast

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Snowflake supports semi-structured data types and provided solutions to manage/process the semi-structured data. It supported sharing data between the different accounts and makes it easy in the scale and scale down process. Snowflake doesn't limit users on the database.
Read Jacob Biguvu's full review
Anonymous | TrustRadius Reviewer
November 30, 2019

Redshift Review

Score 2 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

We like Snowflake for its separation of computing and storage and also the separation of data warehouse different users. We replaced Redshift with Snowflake. However, Snowflake is great for its pay for performance kind of methodology.
Read this authenticated review
Anonymous | TrustRadius Reviewer
June 25, 2019

Amazon Redshift: Reliable and powerful cloud-based data warehouse

Score 7 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

As our applications are hosted on AWS service, Redshift is the best option for us. Also, it provide a near to real-time performance on limited datasets and less complex queries. High availability is the major concern for any growing business and AWS is the best option for this. Compared to other services like Google and Azure, this one has limited functionality but great support by the AWS customer service.
Read this authenticated review
Anonymous | TrustRadius Reviewer
June 15, 2019

Start a data warehouse today with Redshift!

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

We are currently on Redshift, because it was out before Snowflake. However, Snowflake looks promising. It's the new shiny toy that gives options that Redshift does not provide for. The big thing is that storage and compute can be scaled separately, whereas you cannot do that in Redshift. That's a big one. If you have enough data, it's worth it and should be cheaper.
Read this authenticated review
Anonymous | TrustRadius Reviewer
June 13, 2019

Great Analytic Data-Warehouse

Score 10 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Most of our stack is on AWS, so while Snowflake and BigQuery was a viable option from a performance perspective, it was easier to integrate with RedShift. We considered hosting SQL Server on AWS or using Amazon RDS (Postgres or MySQL), however, the self-service aspect of RedShift and its superior parallel query execution made us choose RedShift.
Read this authenticated review
Anonymous | TrustRadius Reviewer
December 19, 2018

Amazon Redshift - a new generation of data warehouse platform

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Amazon Redshift is much easier to set up and start using. It interacts well with the PostgreSQL client (psql) and shares certain basic data dictionary, and people familiar with PostgreSQL feel right at home. The cluster is part of AWS services offering, and it works well with other services such as S3 and EC2.
Read this authenticated review
Gavin Hackeling | TrustRadius Reviewer
October 12, 2018

A hands-free data warehouse

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Some organizations use PostgreSQL as an OLAP store. PostgreSQL offers a modern SQL dialect, data types, and features that Redshift lacks. RDS is a great managed PostgreSQL product. However, PostgreSQL is a poor choice for a data warehouse. It's row-oriented storage requires careful schema and index design to ensure analytical queries perform adequately.
Read Gavin Hackeling's full review
Tamás Imre | TrustRadius Reviewer
February 06, 2018

Amazon Redshift: a fast, scalable and easy to use data warehouse service

Score 9 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Prezi is using AWS so Amazon Redshift was the obvious choice. It is fast, scalable and easy to use. Supplemented with Spark and Hive I'm completely satisfied using Redhsift. Sometimes I miss commands I used earlier on MS and Oracle SQL and the lack of procedural features is also negative.
Read Tamás Imre's full review
Vinaybabu Raghunandha Naidu | TrustRadius Reviewer
October 12, 2017

Scalable and cost-effective data warehousing tool

Score 7 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

From an engineers perspective data must be available in near real time and from business perspective data must to consistent all over which is perfectly supported by Amazon Redshift. Scalability and performance tuning is well designed in Redshift.
Business can make decisions and write queries for data retrieval instead of requesting engineers to fetch data.
Read Vinaybabu Raghunandha Naidu's full review
Seth Goldberg | TrustRadius Reviewer
August 01, 2016

Great data warehouse for the money!

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

  1. Compared to Oracle Data Warehouse, Redshift is a better data warehouse. However, this comes at a cost of advanced functionality and the ability to do OLTP style processing. What you gain is faster querying time and better scalability.
  2. Compared to MySQL, you gain a WHOLE lot. MySQL is terrible for data warehousing and is still gaining features that other databases have had for years (ie. hash joins).
  3. Compared to Teradata, Redshift is a far cheaper option. This comes at the expense of functionality like partitioning and indexing. For the money though, Redshift is still far better since I personally believe you get much more bang for your buck.
Read Seth Goldberg's full review
Anonymous | TrustRadius Reviewer
November 21, 2017

Best Analytics Cloud Data Warehouse Database

Score 10 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

It's fast processing compared to other products and it's best for structured data analytics & data warehousing purpose.
The unique columnar data storage architecture compared to other products makes it the great choice for analytics projects.
Read this authenticated review
Anonymous | TrustRadius Reviewer
August 10, 2016

Redshift review for the analytics environment

Score 8 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).


Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.


Than Hive: Hive is great if you are in the PB+ range, but latencies tend to be much slower than Redshift and it is not suited for ad-hoc applications.

Read this authenticated review
Anonymous | TrustRadius Reviewer
August 05, 2016

get started with columnar databases easily with AWS Redshift

Score 7 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

Redshift may have the lowest barrier to entry for adopting any columnar database. This is mainly due to (1) the ease of use (signup/setup/etc) common to many Amazon Web Services and (2) since Redshift started as a fork of PostgreSQL (8.4) this eases the transition from RDBMS (principles/semantics/etc) to columnar databases. Once you gain an understanding of columnar databases and the use-cases for which they are a good fit, you'll be in a much better position to evaluate the many emerging (and compelling) alternatives available (especially those that are free and open source)
Read this authenticated review

About Amazon Redshift

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
Categories:  Data Warehouse

Amazon Redshift Technical Details

Operating Systems: Unspecified
Mobile Application:No