Try our new research platform with insights from 80,000+ expert users
Senior Economics Analyst at a manufacturing company with 51-200 employees
Real User
Oct 4, 2023
A scalable solution that helps handle unstructured data and offers good support for the data lake
Pros and Cons
  • "The product offers good support for the data lake."
  • "The initial deployment was complex."

What is our primary use case?

The solution is used to handle unstructured data.

How has it helped my organization?

We have been using the product for some time. We are exploring and learning from the new offering of the product.

What is most valuable?

AWS provides an ecosystem of different offerings. The product offers good support for the data lake. It also provides a lambda function for automating flows.

What needs improvement?

The initial deployment was complex.

Buyer's Guide
Amazon Redshift
March 2026
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,873 professionals have used our research since 2012.

For how long have I used the solution?

I have been using the solution for a year and a half.

What do I think about the stability of the solution?

We have an SLA of 99.99%. The product is available most of the time. The vendor maintains the SLA well. They also have a scheduled maintenance window.

What do I think about the scalability of the solution?

The tool’s scalability is pretty good. I rate the scalability an eight out of ten.

How are customer service and support?

The initial support for moving to a serverless database was very good. AWS provides good support. The technical support is not consistent, though.

What about the implementation team?

We need a solution architect from AWS to help us with deployment.

What was our ROI?

Initially, we saw a return on investment. Now, the cost is going up according to our use cases. We need to optimize the cost.

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

The cost must be improved. We’re concerned about the cost. It’s driving a lot of TCO for us. We are looking for alternatives to optimize the cost.

Which other solutions did I evaluate?

Nutanix also provides similar products. It also offers different options for cloud providers.

What other advice do I have?

It’s a pretty good solution. We plan small and grow big over time. Overall, I rate the product an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Sr BI and Data Engineer at Datacult
Real User
Apr 13, 2023
Good for data warehousing but complex setup
Pros and Cons
  • "The most valuable feature of Redshift is its cluster."
  • "The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."

What is our primary use case?

We use it for data warehousing. Currently, I'm setting up a data link with Redshift to fetch data from our data lake.

What is most valuable?

The most valuable feature of Redshift is its cluster.

What needs improvement?

Redshift's serverless technology needs to improve because not everyone is technically inclined. Organizations want to quickly access and import data into their data warehouse without hassle.

Redshift's ETL tool, Glue, is not seamlessly integrated with Redshift. I've encountered many instances where it couldn't fetch the perfect data type from the source, which should be intuitive. Snowflake's ETL tool, on the other hand, is more intuitive and seamless.

For how long have I used the solution?

I have been using this solution for two years. I am working with the latest version.

What do I think about the stability of the solution?

I haven't faced any stability issues because when it works, it runs continuously.

How was the initial setup?

The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs. You need to consult the documentation to understand what an RPU is.

Moreover, Redshift can be difficult to maintain, especially the Redshift cluster instance.

What about the implementation team?

When it comes to the initial deployment and implementation process of Redshift, there are two types of nodes to choose from: DC2 and RA3, which are for different requirements based on the load. One is for storage, one is for storage and checking, and one is for the computing center.

First, the user needs to know their exact requirement, unlike Snowflake, which automatically scales up and down based on the requirement using the Retrieval Service tool.

The service has not matured yet, and for the Redshift cluster, scaling has to be done manually. The cluster also needs to be set up manually, which is not ideal, especially when Snowflake is already in the market.

It is easy to deploy if you already know how to use Redshift. But if I were a new customer, I might need assistance.

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

Redshift is a bit less costly than Snowflake, but the effort justifies the cost for Snowflake.

What other advice do I have?

I would suggest starting with a three-cluster that is DC two large, especially if you are setting up a cluster-based search. We offer a three-month or one-month trial, which will allow you to see if you can handle the manual scaling up, scaling down, and maintenance of Redshift. If not, then you can switch to a serverless data solution.

Overall, I would rate it a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer. Integrator
PeerSpot user
Buyer's Guide
Amazon Redshift
March 2026
Learn what your peers think about Amazon Redshift. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,873 professionals have used our research since 2012.
Beverly R. Jamison - PeerSpot reviewer
IT Solutions Architect / Computer Scientist at Practical Semantics
Real User
Mar 9, 2023
Scalable, reliable, and simple implementation
Pros and Cons
  • "The stability of Amazon Redshift is good."
  • "The solution could improve in handling more data formats and more native support for RDF."

What is our primary use case?

I have used DBeaver to connect to SAP Amazon Redshift and my main use case is for SQL. I map data from a graph database into SQL.

How has it helped my organization?

Amazon Redshift has benefited the company by allowing us to scale. 

What needs improvement?

The solution could improve in handling more data formats and more native support for RDF.

For how long have I used the solution?

I have been using Amazon Redshift for approximately one and a half years.

What do I think about the stability of the solution?

The stability of Amazon Redshift is good.

What do I think about the scalability of the solution?

Amazon Redshift is a scalability solution.

How are customer service and support?

I have not used technical support. If I need support I ask my colleagues.

How was the initial setup?

The initial implementation of Amazon Redshift is simple. There was not anything difficult about getting started with the solution.

What other advice do I have?

It's important to have a grasp of the environment you're working in, including a basic understanding of Amazon AWS. Additionally, when selecting an interface to work with, it's essential to choose wisely, as you'll likely be using it for an extended period of time.

I rate Amazon Redshift an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer2002689 - PeerSpot reviewer
VP, Data and Insights at a tech company with 201-500 employees
Real User
Jan 2, 2023
Secure and reliable data warehouse for transactional and clickstream data
Pros and Cons
  • "If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."
  • "There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."

What is our primary use case?

We use this solution for production and customer data for one of the lines of the business, which is basically one of the warehouses. I oversee the whole architecture infrastructure.

What is most valuable?

The price isn't bad for the performance for a cloud data warehouse. It's also connected to Databricks but uses SQL. It's comparable to BigQuery. If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse.

The performance is good, and it's pretty fast. We also have Looker and MOLE connected to it for visualization, which works seamlessly. We're storing a lot of data. There's a lot of transactional data, clickstream data, and telemetry about the customer, what they're purchasing, call logs, and marketing data.

The analysts are familiar with SQL, and they're able to do this. Even the data scientists who aren't that savvy in Python, because they are very strong in SQL, are able to interact with it very quickly. I'm able to bring in more analysts for support.

What needs improvement?

There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments. It's easier to train people in just one environment to start with, like Snowflake or Databricks. It's difficult to have so many technologies that are very comparable, and each comes with a price tag.

For how long have I used the solution?

I have used this solution for seven months in my current company, but I have also used it in a couple of my previous companies.

What do I think about the stability of the solution?

The stability is good. For a mid-size company, it's very stable.

What do I think about the scalability of the solution?

It's very scalable.

How are customer service and support?

I would rate the technical support as 10 out of 10.

We had one or two tickets, and they responded extremely quickly. Technical support is good, but that's because we aren't running into many issues. The solution is pretty stable. The individuals who set it up did a very good job.

How was the initial setup?

It wasn't too complex because only a few people were needed to set up the solution.

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

It's not very pricey compared to other tools. I would rate the price as 5 out of 10.

Which other solutions did I evaluate?

In my organization, we also use GCP, Amazon EC2, Databricks, and Snowflake. We also have Delta Lakehouse. I'm going to move everything into the Delta Lakehouse. For a company of this size, it's a lot of tools to physically maintain with a small data engineering team.

I think Snowflake has a few more features. In Redshift, you need to write a bit more SQL in some instances, but it's very user-friendly and fast. It can be used as a data warehouse solution as well. It can also do some analytics.

Redshift is comparable to other solutions. I wanted to go with Amazon EC2 because we also have Databricks, and I think I can cover some of those features with the combination of that.

What other advice do I have?

I would rate this solution as eight out of ten. It's a very strong solution.

My advice is to do your research and see if it makes sense for you. You can always request a demo from Redshift.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Nadine Stevens - PeerSpot reviewer
Business Intelligence Software Engineer at Suncorp Group Holdings (NZ) Limited
Real User
Top 5
Jun 18, 2024
Capable of handling large-scale datasets for businesses but needs to reduce its prices
Pros and Cons
  • "I am satisfied with the performance of the product."
  • "The high price of the product is an area of concern where improvements are required."

What is our primary use case?

I use the solution in my company for our data warehouse and databases.

What needs improvement?

The high price of the product is an area of concern where improvements are required.

For how long have I used the solution?

I have been using Amazon Redshift for three years.

Which solution did I use previously and why did I switch?

My company uses IBM Cognos as a reporting portal on top of Amazon Redshift.

My company moved from Netezza to Amazon Redshift since the latter is available on the cloud platform. My company used some migration tools to shift from Netezza to Amazon Redshift, and it took almost a year.

What was our ROI?

Amazon Redshift was not helpful in improving our organization's functioning, and I believe that previously, we had a better database named Netezza in place.

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

It is an expensive product.

What other advice do I have?

The tool can handle some large-scale datasets for our company since we use data shares.

I am satisfied with the performance of the product.

The product is able to fulfill my company's needs associated with data analytics.

Amazon Redshift is used as a storage tool.

I rate the tool a seven out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Mikalai Surta - PeerSpot reviewer
Head of Big Data Department at IBA Group
MSP
Top 10
Feb 24, 2024
Provides excellent features, enables fast reporting, and can be deployed easily
Pros and Cons
  • "Redshift Spectrum is the most valuable feature."
  • "The product must become a bit more serverless."

What is our primary use case?

We use the solution for data storage of reports.

What is most valuable?

Redshift Spectrum is the most valuable feature.

What needs improvement?

The product must become a bit more serverless. Users should have to pay only for the resources they consume.

For how long have I used the solution?

I have been using the solution for one year.

What do I think about the stability of the solution?

The tool is quite stable.

What do I think about the scalability of the solution?

Around 20 people in our organization use the product. The tool’s scalability is good.

How was the initial setup?

The solution is deployed on the cloud. The initial setup was pretty easy.

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

The product is quite expensive.

Which other solutions did I evaluate?

We also tried using Athena. However, Redshift was faster.

What other advice do I have?

We use the tool because we have everything on AWS. Amazon Redshift is best for fast reporting. People who want to use the solution must try using Athena. If it is not fast enough, they can try Redshift. Overall, I rate the product an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Coby Jefferson Gardner - PeerSpot reviewer
Data Consultant at Align BI
Real User
Sep 23, 2023
A highly stable solution that has the ability to handle really large sets of data
Pros and Cons
  • "The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
  • "Amazon Redshift is a little more expensive than other products."

What is our primary use case?

We use Amazon Redshift for our data warehouse to store a lot of our data for a client.

What is most valuable?

The most valuable feature of Amazon Redshift is its ability to handle really large sets of data. In our case, the solution does a lot of things that would be difficult to do otherwise.

What needs improvement?

Amazon Redshift is a little more expensive than other products.

For how long have I used the solution?

I have been using Amazon Redshift for four years.

What do I think about the stability of the solution?

Amazon Redshift is super stable, and we haven't faced any outages or other issues.

What do I think about the scalability of the solution?

The solution's scalability has been fine regarding how much data we can load into it. Once the solution is set up, we pay for what we use. Three people are using the solution in our organization.

What other advice do I have?

Users should select Amazon Redshift depending on what their needs are. Amazon has other cheaper database products, but Amazon Redshift is a really good option for users who need a lot of computation.

Overall, I rate Amazon Redshift ten out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Ansari Rehman - PeerSpot reviewer
AI Engineer at a consultancy with 10,001+ employees
Real User
Top 5Leaderboard
Mar 21, 2023
The Redshift Spectrum is the most valuable feature, but the solution needs to be more optimized
Pros and Cons
  • "I have primarily used the Redshift Spectrum feature and found it most valuable."
  • "The solution is unable to work fast."

What is our primary use case?

We use Redshift Spectrum for creating temp tables during the Ignition process.

What is most valuable?

I have primarily used the Redshift Spectrum feature and found it most valuable.

What needs improvement?

During our last office project, Redshift couldn't perform well even for a data size of 6 TB. Thus, compared to Teradata and Snowflake, the solution needs to work faster. They should extend the plan by including better optimization and readability as we get while using Teradata. Also, they should provide zero-copy coding and sharing facilities.

For how long have I used the solution?

I have been using the solution for three months.

What do I think about the stability of the solution?

I rate the solution's stability as a seven.

What do I think about the scalability of the solution?

There is no issue with the solution's scalability.

How was the initial setup?

The setup was straightforward as I have a POC. It was a simple process.

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

The solution is available at a mid-range price as compared to other vendors.

What other advice do I have?

While using Redshift, we need to combine it with Glue to complete the process. Whereas, Databrix offers the same procedure without combining two solutions. Redshift would work well with small businesses if they already use AWS services. They can use Redshift if the database is not that huge. I recommend Snowflake over Redshift. I rate the performance as well as the overall product as a five.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Buyer's Guide
Download our free Amazon Redshift Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2026
Buyer's Guide
Download our free Amazon Redshift Report and get advice and tips from experienced pros sharing their opinions.