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-25 of 25)

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

Likelihood to Recommend

Except for the price, Amazon Redshift is a great tool and has the fastest performance across all the data warehouses we have seen. It's easy to connect with Talend, which makes it a better option to use. I like the UI better than most of the other DW. Overall it's a great DW tool.
Read Jay Padhya's full review
Anonymous | TrustRadius Reviewer
February 25, 2020

Amazon Redshift is an excellent scalable solution for your data warehouse needs.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

  • The initial costs were very low, and it was super easy for us to spin up databases. Also, setting up multiple instances were easily managed with just a click of a button.
  • The costs increased gradually, and it became more expensive than planned. The query analyzer was not up to the mark and needed constant support from the AWS support team. Gladly they were willing to help and had a good experience with them.
Read this authenticated review
Arthur Zubarev | TrustRadius Reviewer
October 10, 2019

Amazon Redshift Review

Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for).
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

Likelihood to Recommend

Amazon Redshift is well suited for fetching data from multiple different sources and servers, and it is very easy to learn how to use this tool. It is less appropriate for situations where you may need to process only limited rows, as this takes a large amount of time since you cannot create multiple tables in it.
Read Akshaya Bhardwaj's full review
Vibhakar Prasad | TrustRadius Reviewer
June 17, 2019

Redshift is awesome!

Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

I recommend all to use Redshift, It is easy to use and maintain. We have reduced the number of Salesforce licenses due to real-time data we have in Redshift. People are happy to use Redshift.
Read Vibhakar Prasad'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

Likelihood to Recommend

Amazon Redshift is good for when you need a Data Warehouse solution or a user-experience such as SQL kind queries. It is also good if you have limited budget constraints. It's not suggested when someone has DML queries such as INSERT, UPDATE, DELETE.
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

Likelihood to Recommend

Redshift is appropriate when the number of concurrent users are low and pointed queries are the focus. It is not appropriate when a large number of concurrent users is to be supported,
Read this authenticated review
Anonymous | TrustRadius Reviewer
September 27, 2019

Redshift is way too easy!

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It's very cost-effective from other databases we were using for our data warehouse. It was really easy to set up and it used our ETL tools to migrate data from different data sources. We added functionality add aggregate the data set for our Analytics team to analyze.
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

Likelihood to Recommend

Amazon Redshift is the data warehouse under the umbrella of AWS services, so if your application is functioning under the AWS, Redshift is the best solution for this. For large amounts of data, the application is the best fit for real-time insight from the data and added decision capability for growing businesses. If your application is outside of AWS it might add more time in data management.
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

Likelihood to Recommend

Use Redshift for data warehouses, especially if your data is already in the cloud (AWS). It's great for large datasets, and fast too, even if your dataset is column heavy. It's less so for when you have a bunch of rows. All in all, it's a good starting point for any aspiring data warehouse, but there are other promising solutions too. E.g. Snowflake.
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

Likelihood to Recommend

Amazon Redshift is great for analytics, reporting, and complex queries for statistical modeling and machine learning. Its ability to run parallel queries in a simple SQL environment makes the transition from traditional DB very easy. Very good for loading/reading/writing large datasets. I would not recommend RedShift for an environment that requires single row reads/updates, which it is not optimized for.
Read this authenticated review
Brendan McKenna | TrustRadius Reviewer
February 01, 2019

Amazon RedShift happy user

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Very well suited for aggregating/denormalizing data when you need a reporting environment. Can provide extremely fast querying for analytical purposes. Very nice to not have to have in house responsibility for sensitive data.

Not appropriate for a transactional system (though this is not what it is built for obviously). Must keep in mind the data you are syncing up to the cloud and scrub if necessary before. Something to always be mindful of of course.
Read Brendan McKenna's full review
Anonymous | TrustRadius Reviewer
May 14, 2019

smooth implementation and Quicker reports/dashboards

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

[It's] very good for reports and dashboards and is easy to use and fast performance makes it a good choice. It excels in columnar architecture and aggregates. If you have many clients as we do, you need to have separate schemas for each of them. That is a good way but also there is too much clutter spread all over. That is the only drawback I see, end users can see data in the schema, there are no individual permissions allotted.
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

Likelihood to Recommend

It is best for large structured data sets with data normally loaded from files, instead of through heavy SQL data manipulation. If there are SQL data manipulation, better to have mainly DDL (create/drop/alter) instead of DML (insert/update/delete) to achieve the same goals. It is also better for smaller number of concurrent connections (less than 500).
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

Likelihood to Recommend

Redshift is ideal for small teams. It is fully managed. CloudWatch metrics are provided out-of-the-box, and it integrates well with other AWS products, such as DMS. The Redshift console is among the better AWS consoles. Redshift offers adequate performance. Spectrum offers a convenient way to access our data lake, but we have encountered issues with recent versions.
Read Gavin Hackeling's full review
Kyle Reichelt | TrustRadius Reviewer
November 25, 2018

Great for "Big Data" -- but not so much otherwise

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It is well suited for:
  • Petabytes of data requiring near real-time analysis
  • Massive Data Insertions
  • Massive Data Reads
It isn't well suited for:
  • Web apps
  • Smaller transactional inserts
  • Smaller reads
You wouldn't drive an 18-wheeler to the corner store to pick up a bag of chips. Your specific need will determine whether or not Redshift is suited for the job.
Read Kyle Reichelt'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

Likelihood to Recommend

Redshift is a great data warehouse. It can serve the analyst team and most BI tools perfectly. Easy to learn and use. If you are using AWS then Amazon Redshift is a self-evident choice. You can use Redshift for ETL but It can be too expensive. It is not appropriate to serve as an in-production DB.
Read Tamás Imre's full review
Michael Romm | TrustRadius Reviewer
September 13, 2017

After Four Months with Redshift

Score 6 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Redshift is a viable platform to house a large or very large data warehouse designed for performance and scalability. It is especially well-suited in the cases where your source data is already stored inside of the AWS services infrastructure.
Read Michael Romm'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

Likelihood to Recommend

Well suited for faster data retrieval and powering OLTP need and perfectly suited for generating dynamic dashboards and reports.
Not suited for massive data storage and analytics. Can-not handle unstructured 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

Likelihood to Recommend

For data warehousing and analytics, Redshift can't be beat. It's price point, minimal maintenance, and OLAP query optimization make it excellent for querying and reporting for an organization with a small budget. As long as you can live without some standard database tools like constraints and stored procedures, it is an excellent database.
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

Likelihood to Recommend

It's the best option when we need to have a high volume of structured data analytics datawarehouse design & development. It perfectly reports fast with tableau reporting tool, even data around 300 million records. It's best suited where the organization is planning to build a custom datawarehouse rather than using any pre-packaged BI Apps data model.
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

Likelihood to Recommend

It's well suited to be used in an analytics environment where the consumers are 1-50 analysts who need to write complex queries against the data, where total data size is in the 1TB-1000TB range, and where there's no need for data latencies less than one hour. It won't work well in the PB scale, where there are too many consumers and data producers, and for real time 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

Likelihood to Recommend

If you want an easy way to get started with a column store, spin one up on AWS and see if it fits your use case. AWS is a reasonably cheap way to adopt new technologies. Then after a while, you'll be in a better position to decide whether to commit more to AWS or choose from comparable technologies available.
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