Amazon Redshift

(18)
4.0 out of 5 stars

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.

Work for Amazon Redshift?
Ibmpuredatasystemsforana 2x

Learning about Amazon Redshift?

We can help you find the solution that fits you best.

Amazon Redshift Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 18 Amazon Redshift reviews
LinkedIn Connections
Amazon Redshift review by <span>Keith G.</span>
Keith G.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Works well, but beware of early mistakes

What do you like best?

Redshift can query huge data sets quickly with little optimization on the developer's side. It integrates well with other systems, like S3 or DynamoDB, and outputs in many different useful formats like Avro or JSON. Since it speaks the PostgreSQL wire protocol, it integrates with basically every tool you would want to use. Unlike most other data warehouses that we evaluated, Redshift is pretty simple to setup and use, and you don't really need to be a BI/DW expert to do so.

What do you dislike?

Once you hit a certain scale, mistakes you make in the initial design of your tables will become a problem. Since there aren't indexes or anything like that, it might be time consuming to fix mistakes depending on what changes need to be made. There also could be a lot more tools to help you find performance issues. To be fair, lots of performance information is in the documentation, but it's hard to tell that your design isn't as good as it could be until you hit scale.

Recommendations to others considering the product

Fully read the documentation and understand how sortkeys/distkeys work. Also, use the smallest width columns you can as Redshift is more performant at scale whenever the columns are optimally sized. This is different from Postgres, where unbounded VARCHAR columns are faster than fixed length VARCHAR columns.

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

We needed to be able to quickly analyze data we generate and Redshift was the cheapest and easiest way to do so. Redshift allowed us to get up and running and has given us plenty of headroom to grow and scale.

Sign in to G2 Crowd to see what your connections have to say about Amazon Redshift
Headshots
Amazon Redshift review by <span>Tauseef K.</span>
Tauseef K.
Validated Reviewer
Invitation from G2 Crowd
Reviewed On

A Robust Data Warehouse for Large Amounts of Data

What do you like best?

Amazon Redshift is a robust software. Being a columnar data storage architecture makes it very efficient to query very large amount of data. We have several users who access and query Amazon Redshift but it does not affect the speed or efficency of the queries. It is compatible with several BI and visualization tools. We use Tableau in our organization to create reports and analytics. It is easier to setup and most of maintenance is managed by Amazon. This makes it less resource intensive and easier for your IT team.

What do you dislike?

Not all features of Postgres SQL are supported by Amazon RedShift. There is no option to create variables which makes it difficult to write complex queries in certain scenarios. It also does not support stored procedures and triggers.

Recommendations to others considering the product

If you have a large amount of data then Amazon RedShift is a good and very efficient alternatrive to other expensive data waerhousing tools.

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

We have several SQL Server databases which hold data for our different business units. We selected Amazon Redshift as our main analytics data warehouse which store data from all business units (100s of terabyte). We integrate and join data from all sources. We create different data marts which cater to reporting and analytics needs of differnt users in the organization and external clients. We use Tableau as BI tool with our Amazon RedShift data warehouse for most of our reporting & analytics needs.

What Data Warehouse solution do you use?

Thanks for letting us know!
Amazon Redshift review by Consultant in Management Consulting
Consultant in Management Consulting
Validated Reviewer
Invitation from G2 Crowd
Reviewed On

One the fastest and highly scalable data warehouse as a service

What do you like best?

The query time and speed is exceptional good even for huge queries of millions of rows

Highly scalable in terms of addition or removal of nodes depending on workload.

Data injestion using S3 Copy command enables insertion of high volume data in seconds.

Availability of sort key and disturbing key helps database design efficiently.

What do you dislike?

Lack of availability of Update or Upsert facility out of the box.

Limited set of functionality available in terms of data warehouse usage. Support for functions, keys unavailable.

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

The initiative is to create a centralised data warehouse for the analytical team to generate reports. The analytical tool can be spotfire, Tableau, etc.

Support for native Postgres engine helps the development team as well as analytical team to write queries easily Which reduces the development and testing effort.

Support for AWS S3 copy command to insert data helps the development team to load the data quickly and efficiently.

Amazon Redshift review by <span>Daniel M.</span>
Daniel M.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Data Warehouse Developer

What do you like best?

Redshift is extremely easy to set up. The syntax is similar enough to PostgreSQL that we were able to migrate a lot of our scripts with minimal downtime.

What do you dislike?

There is enough dissimilarities with postgreSQL that it led to some "gotcha" moments for us. For instance, the default for VACUUM is FULL, whereas on PosgreSQL it's STANDARD (does not recalculate all indexes). This led to some serious I/O hits that we were not expecting.

Recommendations to others considering the product

Do it. It's way better than Vertica and is faster than you think. Columnar storage is the superior architecture. It seriously is lightning fast compared to a standard PostgreSQL database running on RDS with the same specs.

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

We are attempting to aggregate all of our data into a single repository. Redshift makes it extremely easy to do this since it scales extremely well and is super fast for BI reporting as well as ad hoc querying.

Amazon Redshift review by <span>Aaron G.</span>
Aaron G.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Amazon Redshift Review

What do you like best?

Speed. Redshift is blazing fast with seemingly everything. This is its biggest benefit to us.

What do you dislike?

It has a hard time scaling when you get to big data levels. we have had to migrate some of our datasets into a hadoop/spark cluster to get the performance we needed.

Recommendations to others considering the product

Fantastic Documentation. This has really helped us in our setup and service of this as a product. The fact that everything is easily searchable and readable has really saved us a lot of time when working. Also the admin dashboard is fantastic. Super organized and easy to read and follow.

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

Redshift primarily is used as a repository for our data that our BI tool reads from. In this sense it is not directly used. However that being said, its speed has really helped us in solving issues quickly.

Amazon Redshift review by <span>SHAILESH P.</span>
SHAILESH P.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Review for Amazon Redshift

What do you like best?

It is easy to use and reliable. It is currently one of the best solution for handling Analytics. Its a very cost effective solution for small companies which implements analytics.

What do you dislike?

Sometimes its not able to perform as intended when there is massive data.

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

We have our analytics supported through the amazon technologies and one of which is the amazon redshift. It is easily scalable most of the times and thats the most important benefit.

Kate avatar
Kate from G2 Crowd

Learning about Amazon Redshift?

I can help.
* We monitor all Amazon Redshift reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.