Amazon Redshift

Amazon Redshift

About TrustRadius Scoring
Score 8.6 out of 100
Amazon Redshift

Overview

Recent Reviews

Redshift trumped Hive

9 out of 10
January 15, 2021
It is used within a few departments. It is used to solve certain legacy problems that have not yet been ported over to other more suitable …
Continue reading

Great Data Lake Solution

9 out of 10
December 30, 2020
Amazon Redshift is being used by some departments of our company to bring solution to data warehouse. Our data center was not large and …
Continue reading

Redshift Review

2 out of 10
November 30, 2019
Amazon Redshift was our enterprise data warehouse as a backend to our BI solutions.
Continue reading

Redshift is way too easy!

9 out of 10
September 27, 2019
Redshift is our data warehouse used by our organization. It takes data from different sources and put them together in Redshift for our …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Amazon Redshift, and make your voice heard!

Pricing

View all pricing

Redshift Managed Storage

$0.24

Cloud
per GB per month

Current Generation

$0.25 - $13.04

Cloud
per hour

Previous Generation

$0.25 - $4.08

Cloud
per hour

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Amazon Redshift?

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

Amazon Redshift Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

Reviewers rate Usability highest, with a score of 10.

The most common users of Amazon Redshift are from Mid-sized Companies (51-1,000 employees) and the Computer Software industry.

Comparisons

View all alternatives

Reviews and Ratings

 (180)

Ratings

Reviews

(1-25 of 30)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Review Source
We evaluated [Amazon] Redshift vs BigQuery vs Amazon EMR, back in 2014.
Back then BigQuery cost was slightly higher than that of [Amazon] Redshift price structure.
Amazon EMR, needs lots more management (Admin tasks) and EMR is designed to be ephemeral and not designed to be a data store.
[Amazon] Redshift was ideal with the price structure, performance and ROI[.]
Arthur Zubarev | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is one of the fastest service offerings available in the market now. Plus you get an advantage of using a cutting edge compute service offering from AWS. Other technologies are fast but not as good as Amazon Redshift, I would say. Our business is interested in exploring technologies offered by a company in the form of stack unlike others which only concentrate on offering one of the services.
January 15, 2021

Redshift trumped Hive

Score 9 out of 10
Vetted Review
Verified User
Review Source
Redshift leapfrogged Hive back when Hive was trying to figure out how to implement indexes, providing a more stable, standardized (postgres), easy to use (any postgres client), easier to administer, and scalable solution for querying server logs and raw usage data.

Now, Snowflake has surpassed Redshift in usability and scalability.
Bojan Sovilj | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
1. Redshift has better compression (automated) consuming less space then competitors
2. Automated Vacuum Delete for having consistent performance
3. AWS introduced ra3 node types for simple separation of compute and storage
4. Redshift has automatic concurrency scaling, provisioning new nodes if necessary
5. Better and more native integration with s3 data lake, possible destination for AWS Kinesis Firehose
6. Transparent 'pay-as-you-go' commercial model
7. Automatic backup
December 30, 2020

Redshift Review for you!

Duncan Hernandez | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source
Its definitely an improvement on all fronts for our business needs. Again, our MySQL server was really slow and we needed a more efficient solution. It was a major upgrade, but it is much more expensive than an in house server. It was expected but I'd say that lots of headaches dealing with server slowness have been relieved.
December 30, 2020

Great Data Lake Solution

Score 9 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift supports multiple data formats including multiple structured data formats. And it is easy to implement a cluster if you do not have knowledge of data lake solution. Also when you do not need a lot of resources, you can just scale down so you do not have to spend more than you need.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Akshaya Bhardwaj | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Score 7 out of 10
Vetted Review
Verified User
Review Source
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Jacob Biguvu | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Gavin Hackeling | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
Tamás Imre | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
Vinaybabu Raghunandha Naidu | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
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.