Amazon Redshift

Amazon Redshift

4.2
(107)

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?

Learning about Amazon Redshift?

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

Find the Right Product

Amazon Redshift Reviews

Ask Amazon Redshift a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 107 Amazon Redshift reviews
LinkedIn Connections
Riley W.
Validated Reviewer
Review Source

"Scalable And Fast Data Warehouse Tool"

What do you like best?

It is a great tool since its fully managed. Its console allows you to easily inspect and manage all the queries in addition to the performance of the cluster. It is considered extremely fast querying tool and it allows for concurrent analysis. Amazon RedShift does great with data ingestion and it works on compressing data efficiently. Most of the queries return results fast even with very large data sets. In addition to this, it is considered scalable where if you need more space for your data or in case you want faster results you can add more nodes. The tool has as well a powerful graphical admin monitoring tool that monitors the ongoing queries in real time in addition to historical.

What do you dislike?

I don't like that the application doesn't support SQL syntax 100% this is sometimes very annoying when you work on developing a query. It doesn't support database keys as well. In addition to this, the workload management mechanism can be done to be more enhanced, dynamic and easy to manage.

Recommendations to others considering the product:

Redshift is ideal for your company, especially for small teams. It is a full managed tool that provides you out of the box metrics such as Cloud Watch and it integrates very well with other services provided by AWS. The console for the RedShift is great and the tool itself provides adequate performance for your company. It is easy to learn and use.

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

We use Amazon Redshift for our data warehouse where our transactional datastores in production are always replicated to Redshift and transformed into fact tables. Redshift main purpose for us is to provide business intelligence and more accurate business processes that the analysts need to be able to make decisions on. It was selected for us for its ability to support big data environment with high availability. It is a great new generation of data warehouse platform for its ability to provide essential business performances data and valuable intelligence. Different departments count on it for a variety of operations and top decision makers rely on it for its great analytics data tools for its ability to track and enhance whenever needed.

Sign in to G2 to see what your connections have to say about Amazon Redshift
Camila S.
Validated Reviewer
Review Source

"Moving to the AWS cloud changed the entire way we think about development for the better"

What do you like best?

Literally takes seconds to setup, integrates with AWS Kinesis via Firehose for huge data volumes and loading. Further you don't need to be a hardcore DBA to manage the system and it works flawlessly with BI Tools like Tableau.

What do you dislike?

MySQL transition to Postgres for management required some on the job learnings, but nothing insurmountable

Recommendations to others considering the product:

Yes I would recommend it to all cloud developers as a good accompanying service provided by amazon

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

We are in the final stages of moving a 400+ computer co-location facility completely to the AWS cloud switching to over 40 services in AWS stack. During this time we have had 2 account managers and they have both been excellent in providing the AWS resources needed in a timely fashion. Given the significant differences of on premise vs. cloud environments, I am very pleased with the transformation, cost savings and the future products in the pipeline at AWS as our company is continues its AI based solutions for the travel marketplace.

What Data Warehouse solution do you use?

Thanks for letting us know!
Amit D.
Validated Reviewer
Review Source

"Like Redshift"

What do you like best?

Redshift keeps all of our data together for analytics. We use S3 buckets to collect data and transformdata and then move it to reshift. Looking to to enable with keyword search to make data retrival much easier to use and consume.

What do you dislike?

Some of the data analytics are difficult based on the side and clarity of data. Looking to enable it to work with keyword search. This will make our data retrevial much easier.

Recommendations to others considering the product:

Recommended

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

Some of the data analytics are difficult based on the side and clarity of data. Benefit is data can be put here on temp basis and upon producing analytics we can remove the data from here. Some of the data analytics are difficult based on the side and clarity of data. Benefit is data can be put here on temp basis and upon producing analytics we can remove the data from here.

carl v.
Validated Reviewer
Review Source

"Useful and Reliable"

What do you like best?

I like that redshift allows us to store our large datasets in easily accesible databases. being able to use the postgres syntax i am familiar with makes it easy to adopt. Redshift clusters are quick and easy to deploy.

What do you dislike?

I find that optimizing databases can be difficult at times. It's a different sort of database to conceptualize based on our previous experiences so understanding the best practices can be challenging. In addition because it is its own database with it's own syntax you can't 100% use postgres syntax or plug-ins directly. It also doesn't have many options for desktop clients.

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

Storing large datasets for cold storage and legacy uses. This allows us to offset our production databases and keep them lighter, faster and smaller. Being on amazon architecture means that we have reliabilty and automated backups available

Brian B.
Validated Reviewer
Review Source

"Powerful data warehouse with some limitations"

What do you like best?

I like the large, large amount of raw data you can put in. My company has less than half a terrabyte of nice, simple relational data and redshift obviously meets our size needs.

What do you dislike?

This is probably due to how we originally designed our star schema, but I find for our most common use cases that the queries we have to write can be much more complicated than queries sent to a non-normalized database. Needing to do window functions is a common need and I think window functions tend to run a bit slower on column storage DBs? Not exactly sure.

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

We are able to get our valuable data cleaned up and nightly batched into redshift. This enables us to run daily ad hoc queries on all of our clients without querying our production olap database.

Keith G.
Validated Reviewer
Verified Current User
Review Source

"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 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.

Tauseef K.
Validated Reviewer
Review Source

"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 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.

C
Consultant
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Effortless Environment setup with super fast speed in lowest price"

What do you like best?

- Elasticity :

- No specific DBA required - Even application developer can handle . so maintenance cost is low.

- Very very cheap when compare other equilant tool / Databases

- Super fast - Because of the MPP architecture

What do you dislike?

- There is no key constrains . so these needs to be handled in the ETL or front end.

Recommendations to others considering the product:

Easy Environment setup . pay only for your use . Don't think about future usage . whenever you need more space you can add instantly in 2 minutes. Easy maintenance - No separate DBA is required.

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

Migrating the SQL DW to Redshift . When compare with SQL server configuration, redshift configuration is 50% low, even though we are getting the better performance. Client has saved lot of money through this. They spend almost 2.5 K for one application . Now we are running 4 application for the same cost. .

C
Consultant
Validated Reviewer
Review Source

"Redshift - the almost datawarehouse solution"

What do you like best?

Redshift's query statistics and tuning tools are critical to the offerring. They enable powerful optimzation opportunities and a create agreat conneciton between the objectives and performance you want to acheive and the neccessary structure and format changes that will drive those wins.

What do you dislike?

Redshift suffers in the true enterprise DW world due to concurrency issues and slow changes (resizezing or arch changes often have large delays assocaited with them - this is unfortunate. Redshift seems to assume a model of customer's making their data fit the Redshift offering rather than being able to tailor Redshift to the data. As a cloud person I understand this thinking but many potential DW customers in the market see the initial appeal of a managed DW like Redshift only to find that it is not able to meet their performance objects for countless reasons. I am encouraged by improvements like Spectrum

Recommendations to others considering the product:

Spectrum is the best thing that happened to Redshift

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

Data warehousing problems

Eric H.
Validated Reviewer
Review Source

"Redshift - great data store for reporting and analytics"

What do you like best?

We've found Redshift to be a great tool for ad hoc, compute-intensive queries. We make extensive use of Redshift's built-in JSON functions, often using these to format data for reporting and analytics purposes.

What do you dislike?

We've run into a few situations where Redshift's lack of support for a given feature had led to some roundabout solutions (recursive CTEs, cursors, etc.). We also hit Redshift's maximum column width (64k) for some JSON data (even after providing a JSON Paths mapping to the deepest level possible).

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

We use Redshift as a centralized data store for business intelligence (Tableau, in particular) and analytics.

U
User
Validated Reviewer
Review Source

"Redshift the beast"

What do you like best?

the powerfull of management all the data also all the configuration of the work management, the easiest tway to configure the database and the easy way to manage the resizing of the cluster.

The extra % of space that AWS provides, that save me a couple fo times, cause we only were able to resize on weekends, and sometimes we reached 100% but we kept writing data in the DB, so thank you aws for that extra space in the cluster

What do you dislike?

some times the resizing takes a lot of time

Recommendations to others considering the product:

The performance it's great, and the easy way to scale up the cluster, you only have to set a couple of setting then your are increasing the cluster automatically

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

local databases, after migrated to redshift our performance it's much better

CM
Consultant in Management Consulting
Validated Reviewer
Review Source

"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 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.

Daniel M.
Validated Reviewer
Verified Current User
Review Source

"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 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.

Christian T.
Validated Reviewer
Review Source

"Use redshift to grab data for processing"

What do you like best?

Compared to some data backends used in the past, redshift was considerably faster and scales easily. We were using MySQL before, which has a lot of features, but was taking a lot of time to return data as we got larger.

What do you dislike?

Some of the SQL features from MySQL aren't there.

Recommendations to others considering the product:

It scales and has AWS support. Definitely go through the ducumentation, however, to ensure it has all the SQL functions you may need.

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

Its a data warehouse that quickly gets me data that I pull when doing a Spark job with EMR.

Jeremy C.
Validated Reviewer
Review Source

"Analytics made simple"

What do you like best?

Redshift enables us to quickly injest data through traditional ETL as well as through Redshift Spectrum, leveraging S3. It gives us MPP horsepower while providing the simplicity of SQL to our less technical staff, enabling them direct query access as well as a variety of BI tools

What do you dislike?

Can't scale compute and storage independently on the nodes themselves

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

Quick insights into data. Ability to pull in more data with ease and answer business questions quickly. We've been able to get the performance of query output that our traditional commercial databases could not handle.

Aaron G.
Validated Reviewer
Verified Current User
Review Source

"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 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.

Doug T.
Validated Reviewer
Review Source

"Redshift rocks"

What do you like best?

Fast querying of large datasets. Fast provisioning of hardware. No downtime. SQL interface for our users makes it easy to migrate them. JDBC connectivity allows virtually any client tool to connect.

What do you dislike?

Certain changes require moving to a new cluster. Write operations are not permitted when you go to encrypt your data in the server.

Recommendations to others considering the product:

Also look at Spectrum.

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

Data warehousing and moving away from legacy DB engine in brick and mortar. Moving to cloud and DevOps allows us to get things accomplished faster. Also, no downtime.

U
User
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Amazing Managed MPP Solution"

What do you like best?

I really liked how easy it was to use and get familiar with it as the code base is a postgreSQL based SQL dialect. The read write cabailities are excellet. Loading data is pretty simple and I liked how most of the error handling is a part of the internals.

What do you dislike?

A general lack of parameterized SQL statements is a problem in mind. While there are work around for this It seems Jenky to me not to have Stored procedures. I also wish that features like named windows existed and I find it frustrating at time that the things I know about postgreSQL are not always supporeted or are only supported on the leader node.

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

Right now I am building a datawarehouse with Redshift.

Akshaya B.
Validated Reviewer
Review Source

"This tool helps in working in the cloud, It holds no disparity in the syntax."

What do you like best?

It works in the cloud environment.

We can write any syntax i.e they can be from Oracle SQL/ MS SQL server etc.

User Interface is quite attractive.

What do you dislike?

To work in Redshift we need DBeaver which sometimes slows the connection and system crashes.

Recommendations to others considering the product:

If the data is small then it is a good tool to use.

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

We used this just to make the reports for our new client like any other tool.

Michael C.
Validated Reviewer
Review Source

"Great product"

What do you like best?

It performas as advertised. Easy to spin up and resize

What do you dislike?

Scaling clusters is tricky, and more resources and best practice guides would be great. Scaling spectrum or tuning for perfroamcne also seems to be a grey area

Recommendations to others considering the product:

Scaling and spectrum are areas that have alot of ambiguity, and support on these fronts would help

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

We use this as our company data warehouse, and source of truth for analytics. This has unified out companies view on metrics

SHAILESH P.
Validated Reviewer
Verified Current User
Review Source

"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 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.

Mark B.
Validated Reviewer
Verified Current User
Review Source

"Automatic data warehouse"

What do you like best?

I like how simple it is to get started. There is a learning curve in optimization, but it is good that you can get going with very little hassel.

What do you dislike?

I think it could be made better by keeping up with the features of Postgres a little better. It seems like it is a bit stagnant.

Recommendations to others considering the product:

Once you are up and running, review distribution keys, sort keys, indexes and nodes.

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

Data visibility for analysis by everyone in the company without worrying about scale. We use FiveTran for ETL and Looker for visibility, so our data analysis solution is all SaaS and it is great.

U
User
Validated Reviewer
Review Source

"It's not bad as an analytical database, but be aware of the nuances"

What do you like best?

I loved using Redshift at my previous job for analysis. It was speedy and super easy to set up.

What do you dislike?

We encountered difficulties once we hit our maximum concurrency limit - query queues ended up taking a very long time.

Recommendations to others considering the product:

While it works very well, try to undrestand the nuances of using Redshift at scale. It can be done, but I wish I did more research on how to set it up for a user base of 300+ analysts.

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

We performed Data Analytics on Redshift using SQL. Redshift helped us in the same way our previous analytical database did - provide answers to questions we asked.

I
Internal Consultant
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Redshift crunches heavy data volumes"

What do you like best?

Redshift works excellent when querying data of high volumes spanning multi billion data points in each objects. Apart from the standard relational like objects one can create, the addition of Redshift Spectrum enables virtualized views of S3 objects via AWS Glue catalog can be consumed by users.

What do you dislike?

Redshift database does not work so great for data manipulation activities for updates etc. Also administrative functions like vacuum etc on high volume objects is a time consuming activity.

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

Used for many purposes in the R&D space, commercial space to store trasnformed schema on write datasets for wider massively parallel consumption.

Ashish R.
Validated Reviewer
Review Source

"Best Cloud based DW solution"

What do you like best?

Its Cloud based and highly scalable, Fault tolerasnt. Provide Python UDF support. Ofers efficeint snapshot solution.

What do you dislike?

not much, we dont have hugh data sets, so not hitting so many problems.

But one thing I dislike we always have to commit otherwise it wont refresh.

Dont like locks on the table

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

Created DAtaware house to support Business dashboard. Run metrics calculations.

Learn more about Amazon Redshift

Amazon Redshift Videos

Kate from G2

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.