Amazon Redshift Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Padmanesh NC
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... 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... more»

What needs improvement?

Of course, every product has pluses and minuses. From that perspective, Amazon Redshift has some issues with snapshot... more»

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

Pricing and licensing is so important. In terms of pricing, it's bit high, as they are using standard hardware. My... more»

Which solutions did we use previously?

I have experience working in Hadoop as well. When I compare the two (Redshift & Hadoop), Redshift is more user... more»

What other advice do I have?

Use this product for huge data mapping or aggregation. Use Redshift through VPC to keep their data very secure and for... more»
Crouzier Benjamin
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,... more»

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... more»

What needs improvement?

While It's probably the best product of its category (managed SQL-based data warehouse at scale), it has a few... more»

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

The pricing page is explicit. Choose what suits your needs in terms of storage and performance.

Which solutions did we use previously?

At my previous company, we switched from MongoDB to Redshift. The main reason was price and performance. At my current... more»

What other advice do I have?

If you evaluate Redshift, chances are that you should evaluate BigQuery too. So take the time to weigh the pro and cons... more»
Find out what your peers are saying about Amazon, Snowflake Computing, Microsoft and others in Cloud Data Warehouse.
301,872 professionals have used our research since 2012.
biarchit572622
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... 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. .

Which solutions did we use previously?

I was on a team that was using AWS tools for Dick Smith Electronics (now liquidated). The tools ceased use in February of 2016. Prior to that, we were using them fully for about 3... more»
BIArchit79be
Real User
BI Architect at a comms service provider with 5,001-10,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... more»

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

Based on quality of the product and its price, it is the one of the best options available in the market now.

Which solutions did we use previously?

Initially, we were using the Microsoft SQL solution. We decided to move over to this product due to the DWH volume and... more»

What other advice do I have?

You need to make sure that the space used in DWH has to be a maximum of 50% of the total space. You must create... more»
Qamar Shahbaz Ul Haq
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... 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... 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.... more»

Which solutions did we use previously?

I worked on Teradata and IBM solutions. Redshift gives performance similar to these solutions and costs a fraction of the amount.

What other advice do I have?

Redshift is based on PostgreSQL and adds MPP/columnar features to make it a data warehouse product. It is very easy for developers to adopt this... more»
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... 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... 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»

Which solutions did we use previously?

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,... more»
Richard L Williams
Real User
Senior Engineer, Big-Data/Data-Warehousing at a manufacturing company with 501-1,000 employees
Nov 23 2016

What is most valuable?

The most valuable features to us are: speed, DML, the fact that it is cloud-based, the management console, and Boto3.... more»

How has it helped my organization?

Redshift has helped to transform Makerbot into a data-driven company.

What needs improvement?

Integrating database security/access rights with AWS IAM would be great. I would also like to see more DML features... more»

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

Regarding pricing and licensing, I advise to start small and have your developers/DBA use table compression and... more»

Which solutions did we use previously?

We tried prior solutions, but they had limited or no scalability/agility.

What other advice do I have?

My advice to other is to prototype, prototype, prototype! Everything depends on your data and what you need to do to... more»
it_user396519
Real User
Director at a tech company with 1,001-5,000 employees
Feb 26 2017

What is most valuable?

* Performance: Very fast query performance due to columnar-storage databases that leverage the Massively Parallel... more»

How has it helped my organization?

The end users were able to have access to real-time analytics.

What needs improvement?

We would really like to see a few more connectors included that would enable connecting with other databases and... more»

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

AWS Redshift is one of the fastest and most cost-effective cloud-based databases. They have charged $3330 per TB/year... more»

Which solutions did we use previously?

We were using an on-premise MySQL data warehouse. To reduce the cost and improve scalability, we switched to a cloud... more»

What other advice do I have?

You need to design the database structure with best sort and distribution keys, along with primary and foreign keys.
See 7 More Amazon Redshift Reviews

Articles

User Assessments By Topic About Amazon Redshift

Find out what your peers are saying about Amazon, Snowflake Computing, Microsoft and others in Cloud Data Warehouse.
301,872 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

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, Snowflake Computing, Microsoft, and more!

Sign Up with Email