Amazon Redshift Reviews

4.1 out of 5 stars
 (13)
430c4231 160c 4ab1 804e 21e2576cdd21 avatar
Real User
Big Data Solution Architect - Spatial Data Specialist at Sciera, Inc.
Apr 10 2017

What is most valuable?

Scalability: Ability to load huge number of datasets (I have experience with petabytes of data) and process those things. Storage is not limited. We can increase whatever we want. Performance: The distributed architecture of Redshift has the... more»

How has it helped my organization?

We were using MySQL & MongoDB for our regular operations, but when we grew, we were forced to handle a huge number of datasets. It could be petabytes of data in and out on a regular basis. We struggled a lot to complete the operations in... more»

What needs improvement?

Of course, every product has pluses and minuses. From that perspective, Amazon Redshift has some issues with snapshot restoring when we handle huge datasets. When our snapshot size is really huge, like 20 TB+, we are forced to wait a long... more»
86db969a 021a 4d2c b877 b864b15226a0 avatar
Real User
Rails Developer at a recruiting/HR firm with 51-200 employees
Feb 20 2017

What is most valuable?

* It is based on PostgreSQL. * It’s managed. Meaning, AWS takes care of handling infrastructure, deployments, encryption, and uptime for you. * It’s cheap when you consider the price per terrabyte per year. * It’s integrated into the AWS stack.

How has it helped my organization?

At my previous company that does mobile analytics as its core product, we moved all the analytics backend from MongoDB to Redshift. Where I currently work, we use it as our main data lake/data warehouse.

What needs improvement?

While It's probably the best product of its category (managed SQL-based data warehouse at scale), it has a few shortcomings, although very few. The main issue people complain about, and I agree with the claim, is that it's hard to load your... more»
Cloud data warehouse report from it central station 2018 03 24 thumbnail
Find out what your peers are saying about Amazon, Microsoft, Snowflake Computing and others in Cloud Data Warehouse.
264,911 professionals have used our research since 2012.
Anonymous avatar x80
Real User
BI Architect & Developer (contract) at a retailer with 501-1,000 employees
Jan 31 2017

What is most valuable?

Column store and distributed processing is optimized for read access. We grew to 3000+ users with no impact. Column store is a data compression technique for relational data. I’m using it now in SQL Server 2016. We configured a 16-core VM for... more»

How has it helped my organization?

This has given us the ability to provide metrics to the large number of company staff on their performance without impacting core systems.

What needs improvement?

I’d like to see these RedShift features arrive in other languages, such as SQL's ColumnStore index. .
Anonymous avatar x80
Real User
BI Architect at a comms service provider with 1,001-5,000 employees
Jan 29 2017

What is most valuable?

Columnar storage technology is the most valuable feature of this solution.

How has it helped my organization?

We can get the SLS/SLAs in our daily processes.

What needs improvement?

Some improvements can be brought about in: Restore table: I would like to use this option to move data across different clusters. Right now, you can only restore a table from the same cluster. Right now, the feature only permits bringing the... more»
3a3bea3e 06be 44b7 9d80 83baca44b2ad avatar
Real User
Manager BI Development at a comms service provider with 1,001-5,000 employees
Feb 20 2017

What is most valuable?

Redshift gives extremely fast response involving large tables. This is the most important feature I look for in data warehouse solutions. Often you came across use cases where it is not possible to distribute data on a certain column, yet you... more»

How has it helped my organization?

One of my clients required large amounts of data but had a low budget. Amazon Redshift was the perfect choice for my client. We joined two tables containing billions of rows each and got results back in 27 seconds with a relatively small... more»

What needs improvement?

Amazon should bring more SQL functions that are required in data warehouse implementations. It lacks SQL functions for complex data processing. A very small example is recursive queries. However, Amazon is developing the product at a fast... more»
See 8 more reviews

Articles

User Assessments By Topic About Amazon Redshift

Cloud data warehouse report from it central station 2018 03 24 thumbnail
Find out what your peers are saying about Amazon, Microsoft, Snowflake Computing and others in Cloud Data Warehouse.
264,911 professionals have used our research since 2012.

Amazon Redshift Questions

Amazon Redshift Projects By Members

Amazon Redshift Consultants

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

Vendor 6834 screenshot 1520701462
BUYER'S GUIDE
Not sure which Cloud Data Warehouse solution is right for you?

Download our free Cloud Data Warehouse Report and find out what your peers are saying about Amazon, Microsoft, Snowflake Computing, and more!
Cloud data warehouse report from it central station 2018 03 24 thumbnail

Sign Up with Email