Amazon Redshift Reviews

Filter by:
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Sarfraz Nawaz
Real User
Chief Executive Officer at Ampcome
Jun 23 2020

What is most valuable?

The most valuable feature is the scalability, as it grows according to our needs. The part that I like best is that you only pay for what you are using.

How has it helped my organization?

I've been working with data warehouses for a long time and it has always been the case that we had to invest quite a bit on infrastructure, upfront. We are used to dealing with Teradata, and the cost of setting up the data center and… more»

What needs improvement?

The OLAP slide and dice features need to be improved. For example, if a business wants to bring in a general ledger from an ERP, they want to slice and dice the data. What we have found is that they have a lot of formulas that are used to… more»

Which solution did I use previously and why did I switch?

We have worked with Teradata and more recently, have been working with Azure SQL Warehouse. Teradata is an on-premises solution and the upfront costs are high. Comparing Azure SQL Warehouse and Amazon Redshift, in terms of features I think… more»

What other advice do I have?

I am interested in seeing a split between compute and storage, which is something that they are currently working on. We plan to start leveraging it at some point in the future. In summary, I think that Amazon Redshift is a very good data… more»
Thomas Dallemagne
Real User
Cloud & Data - practice leader at Micropole Belgium
Jul 21 2020

What is most valuable?

I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing. There are only three parameters that you need to understand, which are the distribution key, the sort key, and the compression method or… more»

What needs improvement?

I would like a better way to ingest data in realtime because there is a bit too much latency. There are too many limitations with respect to concurrency. It is now possible to auto-scale it, although that is still slow. It could offer… more»

What's my experience with pricing, setup cost, and licensing?

The cost of Redshift ranges from a few hundred dollars a month to thousands of dollars a month, according to the resources that you're going to use, the number of nodes, and the type of nodes. My customers have implementations that cost… more»

Which solution did I use previously and why did I switch?

I have also used Snowflake and its methods for ingesting real-time data are faster. It also offers a bit more functionality and a bit more flexibility. It's a bit easier to maintain and faster to scale, but more expensive as well. To me… more»

What other advice do I have?

With the most recent update, we should now be able to decouple storage from processes. My advice for anybody who is implementing Redshift is to make sure that they are using it for what it is made to do. It's an analytical database, so it's… more»
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: June 2020.
431,024 professionals have used our research since 2012.
Real User
Service Manager & Solution Architect at a logistics company with 10,001+ employees
Jun 21 2020

What is most valuable?

The TP transactions for the creation of the tables does very well. It is quite simple to use and there are no issues with creating the tables.

What needs improvement?

The managing updates, deletes, and role-level change performance is very low. For example, while you are doing inserts, updates, deletes, and amalgamates, the performance is very, very poor. If you want to query the database after you have… more»

Which solution did I use previously and why did I switch?

Previously, we tried the Snowflake database, which works really well. The expectations were really good with the performance, also the DDL, DML operations on the processing of the data.

What other advice do I have?

We have only just started using Redshift, but we are not really satisfied with it. I would rate this solution a six out of ten.

Which other solutions did I evaluate?

We are switching to Azure, although not because of the product or the services that we did not like. It's about AWS being competitors for logistic companies that we are working with. Also for security reasons, we do not know how secure the… more»
AndrewAlangaram
Real User
Business Analyst at a tech services company with 201-500 employees
Jan 23 2020

What is most valuable?

The processing of data is very fast.

What needs improvement?

It would be useful to have an option where all of the data can be queried at once and then have the result shown. As it is now, when we run a query and we are looking at the results, part of the data remains to be processed at the back end. That works very well, but in some cases, we require the… more»

Which solution did I use previously and why did I switch?

The company was using other solutions such as Google Cloud and the Microsoft Cloud Service, but I have not personally used these solutions.

What other advice do I have?

I am very happy with what RedShift has. So far, anything that I have required has been there and whatever use case I have faced, the functionality is available. My advice for anybody who is implementing this solution is to look into what certifications are available and which ones are required for… more»
Real User
Head of Data Warehouse & Business Intelligence at a comms service provider with 501-1,000 employees
Nov 28 2019

What is most valuable?

The product is relatively easy to use because there is no indexing and no partitions. There is no referential integrity only declarative, which is okay.

What needs improvement?

From my perspective, the product could be improved by making it more flexible. There are now more flexible products on the market that allow for expandability and dynamic expansion as the market changes with regard to data warehouses. Although the product is simple to use there can be problems. If… more»

What's my experience with pricing, setup cost, and licensing?

In terms of pricing, if you plan to use the product for a small company and you compare the cost to a product like Oracle Autonomous Data Warehouse, then you need to consider potential company growth and whether you may need to expand the system in the future, require partitions, etc. It could be… more»

What other advice do I have?

I would rate it a five out of ten.
Shyam Shankar
Real User
Senior System Engineer at a computer software company with 10,001+ employees
Jan 16 2020

What is most valuable?

In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes are valuable.

What needs improvement?

Pricing is one of the concerns that I have because if you compare Snowflake with Redshift, it provides some of the same services, but at a much cheaper rate. So pricing is one of the things that it could improve. It should be more competitive. Otherwise, everything else looks good, especially the… more»

What's my experience with pricing, setup cost, and licensing?

Of course I would advise others to choose Amazon Redshift, as long as pricing is not a concern for them.

What other advice do I have?

On a scale of 1 - 10, where 1 is the worst and 10 is the best, I'd give it an 8.
Mediha Šiljić
Real User
Chief Information Officer at Sensilab
Aug 06 2019

What do you think of Amazon Redshift?

What is our primary use case?

We are using the private cloud model of this solution. Our primary use case is for a data warehouse for BI.

What is most valuable?

The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it.

What needs improvement?

Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions. That's a big problem now.

For how long have I used the solution?

I have been using Redshift for around eight to nine months.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

Scalability is okay. It's easily scalable. We don't have any plans to increase…
Real User
Senior Software Engineer at a tech services company with 51-200 employees
Nov 09 2019

What is most valuable?

The best part about this solution is the cost. The performance of this solution is good if you have only a few use cases and a few queries, but for larger applications, it is not so good.

What needs improvement?

Running parallel queries results in poor performance and this needs to be improved.

What other advice do I have?

The suitability of this solution depends on the environment and the requirements. For some, Amazon Redshift is perfect. However, some people will need better queries. Based on my research, many of the products are pretty close. It is possible that the much higher priced solutions have more differences. This is a good solution but the queries need to perform better. I would rate this solution a… more»
See 2 More Amazon Redshift Reviews

Articles

User Assessments By Topic About Amazon Redshift

Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: June 2020.
431,024 professionals have used our research since 2012.

Amazon Redshift Questions

What is Amazon Redshift?

Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.

Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.

Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.

As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.

Amazon Redshift customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

Read Archived Reviews
BUYER'S GUIDE
Download our free Amazon Redshift Report and get advice and tips from experienced pros sharing their opinions.