Amazon Redshift Reviews & Product Details

Amazon Redshift Overview

What is Amazon Redshift?

Tens of thousands of customers use Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.

Amazon Redshift Details
Product Description

Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.


Seller Details
Seller
AWS
Ownership
AMZN
Company Website
Year Founded
2006
HQ Location
Seattle, WA
Total Revenue (USD mm)
$177,866
Twitter
@awscloud
1,878,364 Twitter followers
LinkedIn® Page
www.linkedin.com
75,532 employees on LinkedIn®
Description

By giving customers more of what they want - low prices, vast selection, and convenience - Amazon continues to grow and evolve as a world-class e-commerce platform.

Show More

Amazon Redshift Screenshots

Amazon Redshift Reviews

Write a Review
Filter reviews

LinkedIn®
Connections
Popular Mentions
Showing 132 Amazon Redshift reviews
Popular Mentions
Showing 132 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
For Category
All Industries
Review Type
Region
Already have Amazon Redshift?
Write a Review
Sr Data Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Strategy and Architecture Consultant
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

The features of Redshift which stand out amongst other cloud data warehouses are Automatic Workload Management (which allows to segregate your workloads, like ETL and Reporting and allocate a part of cluster resources to each workload - such that both of these can work in their 'own' space), Elastic Resizing (which allows you to scale your cluster up and down within minutes), Concurrency Scaling (which allows you to have a virtually unlimited number of connections on your Redshift cluster as additional capacity is added on-demand according to the workload).

Some other features worth the mentions are UDF and Stored Procedures (now you can also call AWS Lambda functions from within a UDF, isn't that cool.!!), Fully automated maintenance (including the tedious and time-taking Vacuum and Delete operations) which is really a big deal for data warehouses, Federated queries (to query other databases like RDS PostgreSQL from Redshift.

It is also amazing to see how AWS listens to customer feedback and implement new features at a great pace. Review collected by and hosted on G2.com.

What do you dislike?

Few limitations of Redshift are listed below -

1. Single Commit Queue - Redshift is primarily used for OLAP (On-line Analytical Processing) workloads. It is not recommended for OLTP (Transactional) workloads where heavy write operations are performed. Due to the single commit queue, writes are slower than other traditional databases (like PostgreSQL)

2. Constraints: Redshift does not enforce constraints like UNIQUE, Primary, and Foreign keys. Although, they can be used while creating tables and they are used by the compiler to determine the most effective query plan.

3. Although not a show stopper, Redshift could definitely benefit from having the ability to query another Redshift cluster from one (feature like dblink). Review collected by and hosted on G2.com.

Recommendations to others considering the product:

While Redshift can be considered for most use-cases pertaining to data warehousing, one must consider that Redshift is not cheap. It is true that you pay for what you use, but if you do not use it effectively - it could be a huge chunk of your overall AWS spends.

Few important points to consider and keep in mind -

1. Do not use Redshift if your requirement is to just store the data. Redshift gives you the most benefits when you perform complex analytics on the data

2. Dump infrequently accessed data to S3 and query using Spectrum (if required) to save storage costs on your Redshift cluster.

3. Pause your Redshift cluster when not in use and Resume when required. This is particularly beneficial for lower (dev, staging, and test) environments which are not used 24x7x365

4. Rightsize: Choosing the right node type for the Redshift cluster is really important, else the capacity would be just idle and a waste of money Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I have been doing a lot of work on Redshift in the last 5 years. For my clients, we are dealing with terabytes of data (including PII data). Redshift plays a key role in the data and analytics pipeline where we can store huge amounts of data without compromising the performance of analytical queries. The elastic resizing feature also helps to scale up and down the storage whenever required. Review collected by and hosted on G2.com.

Show More
Show Less
Data Engineer - SDE1
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

On the fly query performance, the way it stores the data, and parallel computing of aggregations. pre-computing aggregated results with materialized views. Importing and exporting the data from S3 with COPY UNLOAD command makes life easier to utilize whole AWS resources. The newly updated Query editor improves usability. AWS KMS integration with redshift provides a more secure way of making application-level connectivity. Sort keys and Distribution keys play the main role in optimizing the query. Understanding in-depth about these concepts constantly improves the overall performance of the query.

Best competitor for snow flow and big query. Review collected by and hosted on G2.com.

What do you dislike?

pricing and it should be serverless, better it should be for pay for use. Tuning documentation with all the positive scenarios need to be covered. Better to focus on automated Tuning for the different types of data.

During the high traffic times, data needs to be moved across the cluster for better computing, but currently, this is not happening. Can improve the caching layer for frequent queries aggregations for live updating websites. Concurrent queries on redshift decrease the overall performance. There needs to be an easier way to retrieve the schema of the table programmatically or SQL way. when utilization is less, better to look for a cost optimization view if serverless is not possible. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Earlier we use EMR spark to pull the data from S3 and perform realtime on the fly aggregations for analytics. Redshift make us to store the data and process the same, good thing is, its the code less computing on massively larger dataset and its aggregations. dynamic horizontal scaling of the cluster without any maintainence. Review collected by and hosted on G2.com.

Show More
Show Less
Data Analyst
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I have worked as Data Analyst with Webster Bank and I was using AWS Redshift as a Data Warehouse. It takes data from different sources and put them together in Redshift for our Analytics team to diagnose.

It is fairly quick and easy to set up and we can add nodes fairly quick to expand the data needs. Review collected by and hosted on G2.com.

What do you dislike?

Finding errors during a data load can be a little daunting at times and it needs a better query analyzer. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

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. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

we store our application-level datasets and is used further for insights from the stored dataset. It improves the decision support for our business based on data analytics on a large set of real-time datasets which force the business processes to the next level. Review collected by and hosted on G2.com.

Show More
Show Less
Big Data Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Cloud Native Interface with very impressive features

Its too easy to work on an SQL supportive tool Review collected by and hosted on G2.com.

What do you dislike?

Does not support No Structured Query Language

Unstructured format support is always an issue

But it is good for Transactional DBMS Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Better to go with it if the only purpose of it is to switch to Cloud because it is too costly Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I used it once while my company was ingesting their data from On Prem Oracle to Cloud Review collected by and hosted on G2.com.

Show More
Show Less
Data Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

The robustness of the redshift is by far the best across all cloud based data warehouses and it also got a great UI. Review collected by and hosted on G2.com.

What do you dislike?

Proven to be expensive on a long run and the it restricts the user to stick with the aws infrastructure because redshift has non aws server implementation issues. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If robustness and great UI is what you're looking for, I would like to recommend you redshift. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Well I mostly work on ETL and data analytics. Review collected by and hosted on G2.com.

Show More
Show Less
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

High Performance or query execution time over complex queries. Review collected by and hosted on G2.com.

What do you dislike?

I'm using SQLWorkbench for query tool editor.

Amazon should have their tool editor with a good interface. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you are looking for high performance with large dataset more than 1 TB then i will recommend Amazon Redshift Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

1st experience with columnar database. That was really good performance wise. Since ive also experienced with azure SQL but not get such good performance yet. Review collected by and hosted on G2.com.

Show More
Show Less
Business Technology Consultant
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Speed

Scalability

Relational data architecture

Information Schema for Metadata Review collected by and hosted on G2.com.

What do you dislike?

Reduced parallelism

Troublesome at time for hosting web dashboards Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data Warehousing solutions

Presence of redshift spectrum for saving cluster utilization Review collected by and hosted on G2.com.

Show More
Show Less
UR
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Organic
What do you like best?

It is super efficient and quick at retreiving data and therefore would recommend it to anyone who has a cloud database that is slow and buggy Review collected by and hosted on G2.com.

What do you dislike?

Nothing particular at the moment. It is too good Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We have realised that efficent data storage and data retreival is now a thing that AWS redshift can solve. In the times that we live in , we get data being ingested in giga Bytes and therefore AWS Redshift can not only store the data . It can also retreive it at a super fast as well. Review collected by and hosted on G2.com.

Show More
Show Less
Data Analyst
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Processing speed for Sql queries is fast !

Table data can be sorted based on queries.

User Friendly!

Columnar Database for fast Processing. Review collected by and hosted on G2.com.

What do you dislike?

Expensive if we want to increase the no. Of cores.

GUI is little bit conplex for the first time users. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Multiple benifits of S3 bucket.

Easy to connect multiple data sources ! Review collected by and hosted on G2.com.

Show More
Show Less
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Ease of access, db scalability, json structures handling Review collected by and hosted on G2.com.

What do you dislike?

It does not give much benifit over table structure, very limited options are avilable . Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I am able to solve problem related to programmatic and performance campaigns. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It's a very major replacement to all features of all major databases we have currently in market. Review collected by and hosted on G2.com.

What do you dislike?

Nothing much to highlight here. ALL ARE VERY FRIENDLY. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Major problem of creation and maintenance of the DB is now out of our plate which relieved half of the work load. With wonderful architecture, it's been a beautiful coverage of many major DB features. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Data Engineer
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Cloud based cost effective ,olap ,Columnar datawarehouse. Review collected by and hosted on G2.com.

What do you dislike?

Can get expensive when using more clusters Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

we are implementing it on a datalake to support data for machine learning and business reporting uses. Review collected by and hosted on G2.com.

Show More
Show Less
AWS / Python / Data Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

bulk data load, integration with firehose, cluster management. Review collected by and hosted on G2.com.

What do you dislike?

duplicates handling, no key enforcement. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

store sanitised business data, run queries on large dataset Review collected by and hosted on G2.com.

Show More
Show Less
Trainee Decision Scientist
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

fast query processing.

Easy to scale up and down the clusters.

User friendly AWS console. Review collected by and hosted on G2.com.

What do you dislike?

Nothing so far.

I have been able to get all the benefits I can from a data warehousing tool. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

it is a very powerful data warehouse.

You should prefer it over any other. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I am working with a insurance company and they have a lot of data coming in every day and hence it needs a powerful data warehouse for processing .

Amazon redshift can be connected directly to all renowned BI tools directly. Review collected by and hosted on G2.com.

Show More
Show Less
CF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Easy to configure and implement the solutions Review collected by and hosted on G2.com.

What do you dislike?

Still did not find the problem working with AWS Redshift Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Reading the data and running the MySql query engine Review collected by and hosted on G2.com.

Show More
Show Less
Software engineer
Small-Business(50 or fewer emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

It is fast, we can use it concurrently and we can use SQL over it so we don't have to learn a new language. The Redshift dashboard allow us to cancel request that take too much ressources. We can optimize to allow the request to run faster (with indexing) and the data to take less space on the disk (with column formatting and compression) Review collected by and hosted on G2.com.

What do you dislike?

It is a little bit expensive if we want both performance and disk space. It's quite easy to use all the disk space available as the data is replicated by default. Sometimes the errors are difficult to find as we have to request specific system table. They could have been available in the AWS console. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It's good if you have a team that know well SQL. Other options could be to use Spark, or other analytics tools. Redshift can be a bit expensive for small teams. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We used Redshift as a data warehouse that was used by data scientist to make statistics on the data. With Redshift, we were able to do analytics on all the data we had. We also created reporting tools over Redshift. Review collected by and hosted on G2.com.

Show More
Show Less
IF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

The Speed of data processing and ease of setup on AWS using columnar storage and integration to S3 using Spectrum Review collected by and hosted on G2.com.

What do you dislike?

Expect auto scalability and on demand compute Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Building analytical products for amazon finance Review collected by and hosted on G2.com.

Show More
Show Less
UC
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

AWS Redshift is the cloud-based data warehouse. It's query script is very easy and familiar to other SQL query.

Its support a wide range of data variables.

Due to in cloud, no compliance issue for sensitive data.

Query execution on complex dataset is fast.

Easy to load data from different sources like S3, EC2 or web. Review collected by and hosted on G2.com.

What do you dislike?

For the new user, schema design is quite complex.

Even GUI for admin is not that much simple Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are using Redshift to collect all data of user from web application. On collected data we are applying data statistics and extract the insights using Redshift. Its support quick data load and its very easy to manage a multiple source of data. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Amazon’s reputation as first movers in this space gives me confidence in their stability. They’ve already seen roadblocks and issues that other providers start to run into Review collected by and hosted on G2.com.

What do you dislike?

I would prefer support for more languages and interfaces from the user side to connect with Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you want to use languages, this might not be it Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We use it to look at all data at the very lowest data grains available. Performance has been great Review collected by and hosted on G2.com.

Show More
Show Less
Snowflake busted up our performance
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

the copy and unload to file support was great

and supports all psql features well

cluster management.

query history etc .. Review collected by and hosted on G2.com.

What do you dislike?

performance and the space was tightly coupled , some syntax's ware different from psql

computation power and memory should be decoupled Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

we used it for maintaining loges of our product and to store some pre computed values , we never used it for real time computation Review collected by and hosted on G2.com.

Show More
Show Less
Information Analyst
Education Management
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

I like that the SQL syntax is very similar to Oracle SQL which makes transitioning to Redshift easy. We currently use it as a data warehouse. Review collected by and hosted on G2.com.

What do you dislike?

I don't like that we can't update an S3 file directly from Redshift when you create an external table. A lot of the times writing from redshift is as important as reading from the S3 file. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you want to get started with data warehousing in the cloud, this is great fit. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are using it to query our data warehouse. Review collected by and hosted on G2.com.

Show More
Show Less
UM
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

I like the online resources available. SQL Syntax is easier to work with compared to other SQL software. Review collected by and hosted on G2.com.

What do you dislike?

I dislike that there isn't enough user-generated resources online. Most of the only resources about SQL are about MySQL or SQL Server but not redshift, and given the slightly different syntax, a lot of the online help is not easily transferrable. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

I recommend it. Mastering Redshift is very valuable as more companies rely on it as their solution Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

I am solving problems surrounding organizing data in tables and pulling data that is required all while having the data safely secured in Amazon's cloud. I realized how fast Redshift is/ Review collected by and hosted on G2.com.

Show More
Show Less
Sr. DevOps Engineer
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Highly scalable with the ability to have a huge amount of computing power. Review collected by and hosted on G2.com.

What do you dislike?

It's on a much older and heavily modified version of postgres. A lot of cool postgres things don't work in redshift. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data warehousing, frontend reporting. With a decent amount of query manipulation and query workload management, you can actually run a frontend reporting system off of redshift. Review collected by and hosted on G2.com.

Show More
Show Less
CF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Redshift follows columnar database structure which performs very efficient wile dealing with columns. I like most of the thing about AWS Redshift, it is easily integrated with S3, Support ANSI standard SQL, easily load/unload data from s3 or other sources. follows ACID properties.indexing, Sorting .. etc Review collected by and hosted on G2.com.

What do you dislike?

Sometimes queries will perform bad if you forgot to do vacuum/analyse after copy(load). Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

All our dashboards and analytics will happen on Amazon redshift. Review collected by and hosted on G2.com.

Show More
Show Less
Do you work for Amazon Redshift?

Amazon Redshift Consultants