Amazon Redshift Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
John Laws
Real User
Manager Data Services at a logistics company with 201-500 employees
Jul 18 2017

What is most valuable?

* Easy to build out our snowflake design and load data * Ability to dynamically increase space requirements * Good speed *… more»

How has it helped my organization?

We use Redshift as our primary BI data repository. It provides BI for all four of our product lines, which run on… more»

What needs improvement?

It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to… more»

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

BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled… more»

If you previously used a different solution, which one did you use and why did you switch?

This was our first foray into a data warehouse and customer facing BI.

What other advice do I have?

Plan out your our DB design in advance and test your theories on running a small instance first. Use a good ETL tool, like… more»
GregorRatajc
Real User
Full Stack Engineer at a tech services company with 11-50 employees
Jun 22 2017

What is most valuable?

The valuable features are performance, data compression, and scalability.

What needs improvement?

Query compilation time needs a lot of improvement for cases where you are generating queries dynamically. Also, it would help tremendously to have… more»

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

Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other… more»

If you previously used a different solution, which one did you use and why did you switch?

Previously, we were using AWS RDS for our use case. We found that we had outgrown it. Our data grew in size and we wanted to still have performance… more»

What other advice do I have?

It is very important to understand how Redshift is designed to work. The database schema design is not trivial and requires an in-depth knowledge… more»
Find out what your peers are saying about Amazon Redshift vs. Vertica and other solutions. Updated: March 2019.
332,644 professionals have used our research since 2012.
Nir Wasserman
Real User
BI Manager at a tech vendor with 201-500 employees
Jun 28 2017

What is most valuable?

The features I find valuable in Redshift are JSON format support. You can copy JSON to the column and have it analyzed using simple functions… more»

How has it helped my organization?

Since we have lots of data sources and high volumes, we needed a unified and organized DB that can handle these amounts and will be our single… more»

What needs improvement?

It lacks a few features which can be very useful, such as stored procedures, Also, one needs to perform Vacuum in order to manage this DB. It would… more»

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

If you want to think of every query you make but want to know that your nodes are fully managed, then use BigQuery Data Analytics. If you want a… more»

What other advice do I have?

My rating would be 8.5. This a great product, but one still needs to know how to manage clusters and nodes. In order to make your DB scalable and… more»
ScottSumner
Real User
Senior Solutions Engineer, West at a tech vendor with 5,001-10,000 employees
Jul 20 2017

What is most valuable?

Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift.

How has it helped my organization?

It helped my customers migrate off on-premise platforms such as Teradata to Redshift, at a fraction of the cost.

What needs improvement?

There are challenges with dealing with character set mismatches. Migrating data from other data sources can be challenging… more»

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

I have nothing to add here as I wasn’t involved in this part of the process. However, one of my customers went with Google… more»

If you previously used a different solution, which one did you use and why did you switch?

I’ve helped customers migrate off Teradata, SQL Server , Oracle Exadata, Greenplum, and ParAccel Matrix to Redshift. Some… more»

What other advice do I have?

Be careful with vendor lock-in! You cannot move your Redshift environment to a different cloud provider or to an… more»
Andrew Smale
User
Principal Consultant
May 23 2018

What do you think of Amazon Redshift?

What is our primary use case?

Storing and querying data in near real time. Loading millions of raw CSV records. Running data comparisons and queries, then shutting it all down all within a few hours, once a week.

How has it helped my organization?

Easy to load and reload data.

What is most valuable?

Fast load times  Flexibility in column definitions The ability to reload data multiple times at different times.

What needs improvement?

It would be nice if it was a bit cheaper to retain data long-term.  Should be made available across zones, like other Multi-AZ solutions.

For how long have I used the solution?

Less than one year.

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

Per hour pricing is helpful to keep the costs of a pilot down, but long-term…
Nir Wasserman
Real User
BI Manager at a tech vendor with 201-500 employees
Feb 04 2019

What do you think of Amazon Redshift?

What is our primary use case?

We use it to build a data warehouse and a centralized location for all of our data sources, allowing for in-depth analysis by using SQL queries.

How has it helped my organization?

Allows for the storage of huge amounts of data.  Assists users to perform ad hoc analysis on a lot sources together.

What is most valuable?

Windows functions, such as LEAD and LAG. Allows you write complex queries and perform row by row processes.

What needs improvement?

In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations.

For how long have I used the solution?

Three to five years.

Articles

User Assessments By Topic About Amazon Redshift

Find out what your peers are saying about Amazon Redshift vs. Vertica and other solutions. Updated: March 2019.
332,644 professionals have used our research since 2012.

Amazon Redshift Questions

Amazon Redshift Projects By Members

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


Sign Up with Email