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.

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.

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

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

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

The stability of Amazon Redshift is good.

Amazon Redshift is a scalability solution.

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

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

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.

It is storing warehouse data for the organization. We commission data warehousing, storage of data, and reporting.

Data Science and Machine Learning are valuable features. We have found Machine Learning use cases are very nice.

Infinite storage is available in Snowflake and is not available in Redshift. Analytical tools for integration would be helpful in the future.

I have been working with Amazon Redshift for seven years now.

We have found Amazon Redshift to be stable.

We have no problems with scalability.

The initial setup is very smooth and took us about six months to deploy.  The cost is comparable to Snowflake.

I would rate Amazon Redshift a nine out of ten. I am very satisfied with it.

For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features.

They have enriched and elaborate documentation that is helpful.

We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself.

I have been using Amazon Redshift for one year.

Amazon Redshift is reliable and has high availability.

The scalability of Amazon Redshift is good.

We have approximately 20 people using this solution in my organization.

Before we were using Amazon Redshift, we were working with Postgres, Greenplum, and Oracle SQL. These were on-premises databases, and we migrated to the cloud.

The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term.

I would advise others that if they have a large set of data where you have a less number of updates, then choose Amazon Redshift. If there is more update and fewer inserts, then do not use Amazon Redshift.

I rate Amazon Redshift an eight out of ten.

We use the solution to build a data warehouse schema for a target database for analytics. We are uploading data from different transactional databases into Amazon Redshift. We use it for reporting purposes. We use the tool mainly for querying and retrieving the data for analytics.

The fast querying of a huge amount of data greatly impacts our data workflows. All the queries work pretty fast.

Amazon Redshift is a really powerful database system for reporting and data warehousing. I like the product. It works really fast with significant volumes of data. The product covers all the main functionalities required for our data security and compliance needs. It has almost everything we need. It is the main data source for our analytics functionality. We can run our models using the data stored in the database. The ease of use is fine. It is pretty easy to integrate the solution with other products and third-party solutions.

The product must provide new indexes that support special data structures or data types like TEXT.

I have no complaints about the product’s stability.

The tool is scalable. About 30 to 50 analysts use the solution in our organization. We need one or two people to administer the solution.

I haven't heard any complaints about the support team from our DevOps engineers.

My project involves analytics and data warehousing. I use Amazon Redshift. I also use AWS Glue as an ETL tool.

I will recommend the product to others for data warehousing and data analytics. However, I do not recommend the solution for small companies that do not have enough volume of data to analyze. Overall, I rate the product an eight out of ten.

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

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.

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.

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.

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

It's very scalable.

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.

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

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

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.

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.