Amazon Redshift Reviews

The solution is used to handle unstructured data.

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

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.

The initial deployment was complex.

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

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.

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

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

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

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

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.

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

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

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

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

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.

I have been using the solution for three months.

I rate the solution's stability as a seven.

There is no issue with the solution's scalability.

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

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

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 used it as part of the Amazon Connect integration; I had to implement Redshift for a couple of customers. It's used for various use cases involving reporting and exporting data to external sources. I have also used it for some analytics integrations.

The use cases I have typically worked on involve transferring Amazon Connect data to different systems for analytics. The two or three deployments I have done with Redshift are more or less similar because it acts as a kind of data middleware. 

Redshift effectively gathers data from various sources and facilitates the integration of that data into different destinations. This is typically used for insights collection, data showcasing, and integration into a standard ETL process.

So, the overall performance and speed of Redshift have affected the query times.

For the use cases I worked on, particularly on the Connect side, the query times with Redshift are pretty straightforward. We started using Redshift for these cases, and it significantly helped. To achieve faster results from Redshift, we first need to optimize the queries. It does reduce a lot of time in how data is gathered and then presented from the queries.

For me, the most valuable feature of Redshift is the way it operates as a reliable Amazon service. It has the capability to gather data from various Amazon sources and can be easily integrated with some maintenance configuration and code; Lambda functions are required for this. It can be used in multiple places. 

It all depends on the use cases, how we can actually ship the data, and how we can use the data from multiple sources. It is a typical reliable software and works very efficiently with Amazon.

For Amazon Connect combined with Redshift, the integration is mostly straightforward. Using Redshift always depends on the use cases, as there are other methods Amazon Connect can use to achieve its goals. As for Redshift itself, it can be used to build pipelines.

When working with third-party services requires additional integrations and configurations, which can sometimes add more cost.

From the Amazon Connect side of things, we have integrated Redshift. However, as an overall product, I have limited experience. 

But from what I have experienced, whenever we do a Redshift integration, it needs to be planned carefully because although Amazon supports multiple data sources and different data consumption, Redshift needs to be configured very effectively and requires dedicated shared knowledge for successful deployments. 

Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly. It’s a relatively old service within Amazon's offerings, with at least 10,000 customers. I've seen cases in different organizations where users experienced up to 35X times increase in throughput while using Amazon Redshift.

It's pretty much straightforward. I just need some sort of configuration and a bit of integration, and then that's it. We should be able to get that done.

For first-time usage of Redshift, the process is pretty straightforward, thanks to the documentation provided by AWS and the straightforward integration with Amazon Connect. 

It didn't take me much time to create, deploy, and configure. It’s very straightforward. However, having some prior knowledge about Redshift can speed up the process significantly. 

For me, coming from a different background and learning about Redshift for the first time, I ended up reading some database documentation and doing some trials and testing before committing the production data.

For someone who knows a bit about how databases and data warehousing work, it's quite straightforward to learn Redshift. It's easier for those involved in analysis, reporting, and ETL data warehousing, specifically database developers or data warehousing developers; they can learn it faster. 

However, for someone without this background, it might take a bit more time to understand the concepts and how they integrate in different ways.

Overall, I would rate it an eight out of ten because it has been straightforward for my use cases. It's easy to integrate for those use cases.

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

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.

Amazon Redshift is a little more expensive than other products.

I have been using Amazon Redshift for four years.

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

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.

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.

I have used it for our reporting solution requirement. We gathered data from different processes and applications, like the high system process. Clients can review the data; we use it for connections and reports. Additionally, Redshift generates some configuration files without using an application.

For reporting purposes, Redshift is a great tool to use. Redshift has an advantage when it comes to administration, making it easier to manage and collaborate. Additionally, its server architecture allows for faster processing. Redshift also supports prepaid costs, which is another great feature. However, similar features are also available in Azure.

Redshift has some advantages in terms of administration and performance.

When compared to Snowflake, Amazon Redshift does not have the capability to dynamically increase the VM file. However, Amazon Redshift provides a virtual database called 'VW' that allows you to increase the size of the warehouse to run faster on a monthly basis without changing anything. This feature is not available in Redshift. So it's a limitation of Redshift.

It's not possible to immediately increase the virtual warehouse size in Amazon Redshift. When compared to Snowflake, we cannot increase the virtual warehouse size in Redshift. 

I have been using this solution since 2015. 

I don't see any issues with data loss or any other problems. Although there might be some loss in the data center, we monitor it, and everything is enabled. In such scenarios, the turn-up time is much faster. We've been using it since 2018, and I've got the same product for another customer using a limited rate. So, I don't see any significant impact, and it's a very stable product.

We have to consider the scalability of this solution carefully. In production, we have a proper size. We allocate 40% for data storage and 60% for temporary segments. We cannot increase data storage usage beyond 50%. It cannot exceed 80% of the total utilization, including network speed and query performance. We monitor all of these carefully.

So if the CPU utilization goes beyond 80%, I recommend upgrading to multiple nodes. It ensures that there won't be any issues. Around 30 people are using AWS and Azure modules along with me.

We have contacted the Redshift team for support related to other installations, such as WDL configuration for project implementation for a web application. When it was not working as expected, we had to provide authentication for the web chat. So, we used to contact them for that kind of knowledge.

The initial setup depends on who is doing it. In my opinion, it doesn't require much knowledge. Since we've been using it for a long time, it's much faster for me, but it might not be the same for others.

It's on the expensive side.

One reason we chose this solution is that we are in the process of moving everything to the cloud. But that's not the only reason. My company wanted to consolidate everything into one system, and AWS provided all the necessary information in one place. For example, Lambda is for specific storage and limited membership; all this information is available in one cloud network. This way, data segregation is much faster and easier to use. It's just everything in one cloud network, so we decided to use it.

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. 

We use Amazon Redshift in our business intelligence ecosystem. It's simple to configure, cost-effective, and close to our data sources.

The managed service is scalable and reliable. AWS takes away scalability and reliability components, making it relatively easier for us.

Its simplicity in configuration, cost-effectiveness due to being in the cloud and close to our data sources, and the fact that it's a managed service that is scalable and reliable are highly valuable.

There are no significant issues preventing us from doing our tasks. However, there might be some limitations from a business intelligence perspective, but nothing we can't find a workaround for.

We have been using it for five years or more.

We are happy with it, so there are no major stability issues that stand out.

AWS handles scalability and reliability, making it easier for us to manage.

We have two people to continue with support.

Positive

Setting it up was straightforward due to its simplicity and being a managed service.

AWS handles the scalability and reliability components, making it easier to implement.

Ensure that information about specific configurations and internal uses remains anonymous.

I'd rate the solution seven out of ten.

We use the solution for data storage of reports.

Redshift Spectrum is the most valuable feature.

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

I have been using the solution for one year.

The tool is quite stable.

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

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

The product is quite expensive.

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

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.

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

The most valuable feature of Redshift is its cluster.

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.

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

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

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.

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.

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

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.