Skip to main content
TrustRadius
Amazon Redshift

Amazon Redshift

Overview

What is Amazon Redshift?

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

Read more
Recent Reviews

Redshift trumped Hive

9 out of 10
January 15, 2021
Incentivized
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
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

Return to navigation

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
Return to navigation

Product Demos

ETL From Amazon RDS to Amazon Redshift with using AWS Glue Service

YouTube

Introduction to Query Scheduler for Amazon Redshift

YouTube

ETL From AWS S3 to Amazon Redshift with AWS Lambda dynamically.

YouTube

Amazon Redshift Tutorial | AWS Tutorial for Beginners | AWS Certification Training | Edureka

YouTube
Return to navigation

Product Details

What is Amazon Redshift?

Amazon Redshift Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
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).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(207)

Attribute Ratings

Reviews

(1-25 of 37)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
If you are looking for a data warehouse where you don't need to worry about maintenance and scalability, Amazon Redshift should be one of your options once it is a self-managed data warehouse with many connectors and easy usage as well. Besides that, if your environment runs on AWS, it is even easier to integrate.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Amazon Redshift is well-suited for a variety of scenarios where businesses need to store, retrieve, and analyze large volumes of structured data. Some specific scenarios where Amazon Redshift may be well-suited include: Data Warehousing, Business Intelligence, Data Migration as well as Real-Time Data Processing. On the other hand, Amazon Redshift may not be the most appropriate for unstructured data, organizations with low volume of data or Real-Time Stream Processing.
Dileep Kumar | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
It is a solid data warehouse on top of the AWS ecosystem. If most of your infra is on AWS, it makes good sense to go for it. But it is expected to be tuned well by a data engineer for an optimal performance. For a data scientist too, the SQL is a bit limited when it comes to unstructured columns in the tables. Arrays, jsons, etc have very poor support compared to other warehouses.
Sameera Srivastava | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is well suited in scenarios where you have distributed data sources and would like to build an ETL pipeline with limited data engineering efforts. Operations time and cost is relatively low compared to other tools. Also it offers great connectivity with Heap with no technical know-how required. It is mostly self managed and reliable.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
[Amazon] Redshift is suited for various use cases like Time series data, Structured / relational data, Semi structured data like JSON, etc.

[Amazon] Redshift might not work 100% well with full performance, for Graph DB use cases.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
If you are looking for something easy to implement that will give you a nice performance, I would suggest Amazon Redshift. I'm using it in AWS environment, so I don't know if in another cloud environment the performance and all the features would be nice as well. It's also important to check if the price fits to you too.
Arthur Zubarev | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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).
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Amazon Redshift performs extremely well for reporting/analytics data and is way ahead of other competitors. The biggest challenge is migrating data from on-premises databases to Amazon Redshift. The initial hurdle is a major one.
Bojan Sovilj | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
ResellerIncentivized
Redshift is great data warehouse solution if you have several billion rows tables. More than 200 very important improvements were added in several years' time. With new Redshift instance types solution has separation of storage and compute and magnitude better query response times. Don't use Redshift if you have less than several billion rows tables.
December 30, 2020

Redshift Review for you!

Duncan Hernandez | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Incentivized
Redshift is best suited for our data storage and designing our fact and dimension tables. We keep our non-structured data there that can be accessed at any time as well as our relational database. I'd say that if you don't have a need for a relational databasae, then Redshift probably isn't going to be a viable product.
December 30, 2020

Great Data Lake Solution

Score 9 out of 10
Vetted Review
Verified User
Incentivized
If you do not require a fast I/O rate. And frankly you should not expect that from data warehouse. And if you do not mind that your data is on cloud and only on AWS, and if you want a scalable and fast implementation of data lake, then you should consider Amazon Redshift.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • 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.
November 30, 2019

Redshift Review

Score 2 out of 10
Vetted Review
Verified User
Incentivized
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,
September 27, 2019

Redshift is way too easy!

Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Akshaya Bhardwaj | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
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.
Jacob Biguvu | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
[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.
Brendan McKenna | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
Return to navigation