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.
From time to time, the solution needs to be restarted for maintenance. I recommend BigQuery over Amazon Redshift. I don't have experience with Snowflake, but it's set to be more feature-rich than BigQuery or HSA. I was more happy using BigQuery. Redshift is doing what it's expected to do, but you had to invest in learning the setup. Overall, I rate the solution a seven out of ten.
Senior Director Data Architecture at Managed Markets Insight & Technology, LLC
Real User
Top 5
2023-07-27T20:51:51Z
Jul 27, 2023
If it fits the bill and the business purpose, I would recommend using the solution. But when it comes to business needs, that's when all these things matter. Whether one tool versus the other supports all the business needs and meets the SLA and RT, or whatnot, then we are talking about different products. So it's based on business needs. Overall, I would rate Amazon Redshift a six out of ten. They still need to adapt the maturity and be on par with the open source community and ecosystem. Recent technology adoption is towards Delta. Microsoft is moving towards Delta. A lot of ecosystems are moving towards Delta, but Amazon Redshift is not making its move towards this technology, which is serving the engine. So that aspect has to grow. So, there are a lot of aspects where they can improve.
I would recommend it. However, I think we need to consider other configuration levels. You need to decide, and I would not go with the first option. To evaluate the data you are planning to migrate, we need to assess the environment. What is the value of your data, and what type of data is it? The density of the data is also important. Before implementing Redshift, we need to ensure that the AWS configuration is activated. After that, you need to set up enrollment and increase your storage. I don't recommend making a purchase on the same day, but it is a critical moment at a high level. I suggest purchasing a renewal that meets the deposit requirements so that you can have a good experience and optimal performance. You can increase the budget for the building process. If you have the right team, such as those with experience in AWS or those who are learning about Azure databases, they can start using Redshift without any issues. Overall, I would rate the solution a nine out of ten.
I recommended it for data storage. I don't recommend integrated solutions, like Pacemaker unless you have an advanced team to handle it. I like using it, but it's too expensive. So, I rate the overall solution a seven out of ten.
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.
Cloud Data Architect (AWS-Snowflake-Teradata-Oracle) at Capgemini
Real User
Top 5
2023-03-13T06:12:00Z
Mar 13, 2023
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.
Amazon Redshift is a horrible solution. I recommend my customer to use AWS Glue since while dealing globally with real-time data, which you need to make decisions, factors like how much cost and data is needed to make a decision should be considered. Apart from this, if customers are paying a huge price for the solution, then probably Amazon shouldn't mind spending on the tool. However, it may not be necessary for small businesses with only a few thousand data points. Although Azure is a better option, some clients prefer AWS, and we had to develop a solution using AWS for our client. Overall, I rate this solution a three or four out of ten.
IoT Consultant at a computer software company with 1,001-5,000 employees
Consultant
Top 20
2022-12-13T14:45:00Z
Dec 13, 2022
I would rate this solution as nine out of ten. My advice is to use a consultant to set it up correctly and to get familiar with data warehousing in general. It's pretty straightforward once you're using the data management console. Anyone could use Google to set it up, but to do it correctly and sketch the perfect architecture, an external consultancy company should handle it because the usual IT departments aren't that experienced. I think Redshift is worth the money, and there's always some return. Most companies don't have a full solution for business intelligence. AWS provides a pretty good service architecture to implement this. Anyone who uses Redshift or a data warehouse in general will have a return on investment.
I rate Amazon Redshift ten out of ten. I recommend the solution to anyone in an AWS environment. I see a lot of fuss about Snowflake, and I used both, but I'm not much of an Azure guy. I don't know why the pickup rate for Redshift in NL is so low, but that's more marketing-driven, as Snowflake has very aggressive marketing. Amazon Redshift is one of the best products I've ever come across.
I would rate this solution 6 out of 10. If an organization has invested heavily in AWS services and they have a good knowledge of the AWS ecosystem, then I would recommend Redshift. Otherwise, I would still recommend Snowflake because Snowflake works very well with AWS services. I can have my AWS S3 buckets in which I can store my enterprise data lake, and then Snowflake works with that seamlessly. If the organization has good knowledge of AWS and good knowledge of RDBMS data warehouses, then we can recommend Redshift to them. It all depends on how much investment that organization has done in Redshift. For example, we have a customer which has a very large setup. It's a large US-based company, where they have invested heavily in AWS. They're an AWS house, so they like everything about AWS. For them, we have recommended Redshift so that the overall tech ecosystem remains optimum.
In summary, this is a good solution and I recommend it. That said, the customer support needs to be improved. I would rate this solution a seven out of ten.
Data Analyst at a tech vendor with 51-200 employees
MSP
2021-12-27T19:44:47Z
Dec 27, 2021
I am just the user and we make use of the solution. The solution is deployed solely on the cloud. I believe there are around 20 people making use of the solution in our environment. While the solution is not appropriate for every case in which usage must be evaluated, it can be used for sure. I rate Amazon Redshift as an eight out of ten.
I rate Redshift nine out of 10. If you're thinking about implementing Redshift, I would recommend focusing on the use case. It's a warehouse database, not a transactional system, so they need to plan their workload before migrating to Redshift.
Senior Solutions Architect at a retailer with 10,001+ employees
Real User
2021-08-07T10:41:15Z
Aug 7, 2021
I would recommend this solution depending on the scale. You need to decide whether you want to be lined up with a single cloud provider or go over the service and have it deployed on multi cloud. There are many factors to take into consideration. I rate this solution seven out of 10.
If a company is already using Amazon Cloud or they're looking for a cloud solution, Amazon is one of the oldest and most reliable cloud service providers and Redshift is a no-brainer for data warehouse needs. I rate this product a nine out of 10.
I would recommend Amazon Redshift as it is part of the AWS platform and they are the biggest in the world. I would give Amazon Redshift a rating of eight on a scale of ten.
My advice for anybody who is implementing Redshift is to ensure that the requirements include having technical people on board to continuously work on getting the results you want. Because it's not that user-friendly, there is a need for a technical resource in the company. Also, I would suggest watching out for scalability beyond what we have tested. If there is a need for scaling then it should be tested, although it depends on the use case. If Redshift had a proper interface then I would score it higher. I would rate this solution a seven out of ten.
Cloud & Data - practice leader at Micropole Belgium
Real User
2020-07-19T08:15:38Z
Jul 19, 2020
With the most recent update, we should now be able to decouple storage from processes. My advice for anybody who is implementing Redshift is to make sure that they are using it for what it is made to do. It's an analytical database, so it's not meant to process transactional data. It's the perfect tool if you use it for the right purpose. Overall, it is a very stable and robust product. That said, there is still plenty of potential for improvement. I would rate this solution a seven out of ten.
I am interested in seeing a split between compute and storage, which is something that they are currently working on. We plan to start leveraging it at some point in the future. In summary, I think that Amazon Redshift is a very good data warehouse and we really like it a lot. I would rate this solution an eight out of ten.
Business Analyst at a tech services company with 201-500 employees
Real User
2020-01-22T12:44:00Z
Jan 22, 2020
I am very happy with what RedShift has. So far, anything that I have required has been there and whatever use case I have faced, the functionality is available. My advice for anybody who is implementing this solution is to look into what certifications are available and which ones are required for different roles. Depending on the job, different certifications are relevant or required. For example, as a business analyst, a coding certification would not be useful for me and it would be a waste of money. These things should all be considered before beginning with any certifications. I would rate this solution a nine out of ten.
Senior Software Engineer at a tech services company with 51-200 employees
Real User
2019-11-07T10:35:00Z
Nov 7, 2019
The suitability of this solution depends on the environment and the requirements. For some, Amazon Redshift is perfect. However, some people will need better queries. Based on my research, many of the products are pretty close. It is possible that the much higher priced solutions have more differences. This is a good solution but the queries need to perform better. I would rate this solution a seven out of ten.
We use public and hybrid cloud deployment models. We are Amazon partners. The solution itself is very popular. Many people use it these days. I recently went to an AWS summit in Zurich. I was very impressed by AWS and the presentation. Their solutions are very good. I'd rate this solution eight out of ten.
What is Amazon Redshift?
Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.
Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of...
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.
From time to time, the solution needs to be restarted for maintenance. I recommend BigQuery over Amazon Redshift. I don't have experience with Snowflake, but it's set to be more feature-rich than BigQuery or HSA. I was more happy using BigQuery. Redshift is doing what it's expected to do, but you had to invest in learning the setup. Overall, I rate the solution a seven out of ten.
If it fits the bill and the business purpose, I would recommend using the solution. But when it comes to business needs, that's when all these things matter. Whether one tool versus the other supports all the business needs and meets the SLA and RT, or whatnot, then we are talking about different products. So it's based on business needs. Overall, I would rate Amazon Redshift a six out of ten. They still need to adapt the maturity and be on par with the open source community and ecosystem. Recent technology adoption is towards Delta. Microsoft is moving towards Delta. A lot of ecosystems are moving towards Delta, but Amazon Redshift is not making its move towards this technology, which is serving the engine. So that aspect has to grow. So, there are a lot of aspects where they can improve.
I would recommend it. However, I think we need to consider other configuration levels. You need to decide, and I would not go with the first option. To evaluate the data you are planning to migrate, we need to assess the environment. What is the value of your data, and what type of data is it? The density of the data is also important. Before implementing Redshift, we need to ensure that the AWS configuration is activated. After that, you need to set up enrollment and increase your storage. I don't recommend making a purchase on the same day, but it is a critical moment at a high level. I suggest purchasing a renewal that meets the deposit requirements so that you can have a good experience and optimal performance. You can increase the budget for the building process. If you have the right team, such as those with experience in AWS or those who are learning about Azure databases, they can start using Redshift without any issues. Overall, I would rate the solution a nine out of ten.
I recommended it for data storage. I don't recommend integrated solutions, like Pacemaker unless you have an advanced team to handle it. I like using it, but it's too expensive. So, I rate the overall solution a seven out of ten.
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.
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.
I rate the solution as an eight out of ten.
I would recommend Amazon Redshift and would rate it at nine on a scale from one to ten, where one is the worst and ten is the best.
Amazon Redshift is a horrible solution. I recommend my customer to use AWS Glue since while dealing globally with real-time data, which you need to make decisions, factors like how much cost and data is needed to make a decision should be considered. Apart from this, if customers are paying a huge price for the solution, then probably Amazon shouldn't mind spending on the tool. However, it may not be necessary for small businesses with only a few thousand data points. Although Azure is a better option, some clients prefer AWS, and we had to develop a solution using AWS for our client. Overall, I rate this solution a three or four out of ten.
I would rate this solution as nine out of ten. My advice is to use a consultant to set it up correctly and to get familiar with data warehousing in general. It's pretty straightforward once you're using the data management console. Anyone could use Google to set it up, but to do it correctly and sketch the perfect architecture, an external consultancy company should handle it because the usual IT departments aren't that experienced. I think Redshift is worth the money, and there's always some return. Most companies don't have a full solution for business intelligence. AWS provides a pretty good service architecture to implement this. Anyone who uses Redshift or a data warehouse in general will have a return on investment.
I rate Amazon Redshift ten out of ten. I recommend the solution to anyone in an AWS environment. I see a lot of fuss about Snowflake, and I used both, but I'm not much of an Azure guy. I don't know why the pickup rate for Redshift in NL is so low, but that's more marketing-driven, as Snowflake has very aggressive marketing. Amazon Redshift is one of the best products I've ever come across.
I would rate Amazon Redshift a nine out of ten. I am very satisfied with it.
I would rate this solution 6 out of 10. If an organization has invested heavily in AWS services and they have a good knowledge of the AWS ecosystem, then I would recommend Redshift. Otherwise, I would still recommend Snowflake because Snowflake works very well with AWS services. I can have my AWS S3 buckets in which I can store my enterprise data lake, and then Snowflake works with that seamlessly. If the organization has good knowledge of AWS and good knowledge of RDBMS data warehouses, then we can recommend Redshift to them. It all depends on how much investment that organization has done in Redshift. For example, we have a customer which has a very large setup. It's a large US-based company, where they have invested heavily in AWS. They're an AWS house, so they like everything about AWS. For them, we have recommended Redshift so that the overall tech ecosystem remains optimum.
In summary, this is a good solution and I recommend it. That said, the customer support needs to be improved. I would rate this solution a seven out of ten.
I am just the user and we make use of the solution. The solution is deployed solely on the cloud. I believe there are around 20 people making use of the solution in our environment. While the solution is not appropriate for every case in which usage must be evaluated, it can be used for sure. I rate Amazon Redshift as an eight out of ten.
I rate Redshift nine out of 10. If you're thinking about implementing Redshift, I would recommend focusing on the use case. It's a warehouse database, not a transactional system, so they need to plan their workload before migrating to Redshift.
I would recommend this solution depending on the scale. You need to decide whether you want to be lined up with a single cloud provider or go over the service and have it deployed on multi cloud. There are many factors to take into consideration. I rate this solution seven out of 10.
I rate Amazon Redshift a seven out of ten.
If a company is already using Amazon Cloud or they're looking for a cloud solution, Amazon is one of the oldest and most reliable cloud service providers and Redshift is a no-brainer for data warehouse needs. I rate this product a nine out of 10.
I would recommend Amazon Redshift as it is part of the AWS platform and they are the biggest in the world. I would give Amazon Redshift a rating of eight on a scale of ten.
My advice for anybody who is implementing Redshift is to ensure that the requirements include having technical people on board to continuously work on getting the results you want. Because it's not that user-friendly, there is a need for a technical resource in the company. Also, I would suggest watching out for scalability beyond what we have tested. If there is a need for scaling then it should be tested, although it depends on the use case. If Redshift had a proper interface then I would score it higher. I would rate this solution a seven out of ten.
With the most recent update, we should now be able to decouple storage from processes. My advice for anybody who is implementing Redshift is to make sure that they are using it for what it is made to do. It's an analytical database, so it's not meant to process transactional data. It's the perfect tool if you use it for the right purpose. Overall, it is a very stable and robust product. That said, there is still plenty of potential for improvement. I would rate this solution a seven out of ten.
I am interested in seeing a split between compute and storage, which is something that they are currently working on. We plan to start leveraging it at some point in the future. In summary, I think that Amazon Redshift is a very good data warehouse and we really like it a lot. I would rate this solution an eight out of ten.
We have only just started using Redshift, but we are not really satisfied with it. I would rate this solution a six out of ten.
I am very happy with what RedShift has. So far, anything that I have required has been there and whatever use case I have faced, the functionality is available. My advice for anybody who is implementing this solution is to look into what certifications are available and which ones are required for different roles. Depending on the job, different certifications are relevant or required. For example, as a business analyst, a coding certification would not be useful for me and it would be a waste of money. These things should all be considered before beginning with any certifications. I would rate this solution a nine out of ten.
On a scale of 1 - 10, where 1 is the worst and 10 is the best, I'd give it an 8.
I would rate it a five out of ten.
The suitability of this solution depends on the environment and the requirements. For some, Amazon Redshift is perfect. However, some people will need better queries. Based on my research, many of the products are pretty close. It is possible that the much higher priced solutions have more differences. This is a good solution but the queries need to perform better. I would rate this solution a seven out of ten.
We use public and hybrid cloud deployment models. We are Amazon partners. The solution itself is very popular. Many people use it these days. I recently went to an AWS summit in Zurich. I was very impressed by AWS and the presentation. Their solutions are very good. I'd rate this solution eight out of ten.
I would rate it a ten out of ten.