Amazon Redshift Reviews

I use Amazon Redshift for the creation of SQL ETL procedures in a business system. Business people check this in a front-end application, and it helps them plan sales for the next year.

Redshift is being deployed on a Microsoft Azure server.

There are about six people working on this project and using the solution, but there are many similar projects running on Oracle and Redshift.

I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar. Until recently, I thought it was the superior database, but now I think that Redshift is better.

The explain panel in the Redshift database could be better.

I have used this solution for 10 months.

The solution is stable. I haven't had any problems or downfall with the database in the 10 months that I have used the solution.

I have also used Microsoft SQL server and Oracle.

Setup was difficult because I had to set up 25 connections with different users and passwords. The connections have been predefined, but there were still problems when trying to connect for the first time. I had some problems with some certifications that were malfunctioning. This might have had something to do with the functionality of my keyboard because if I pushed a random combination on the keyboard, it would delete the certificate from the folder and the connection wouldn't work. I think this is a problem with the remote desktop rather than with Redshift.

I would rate this solution as eight out of ten. I can't give it a higher score because there are some issues with variable character columns in the table. Otherwise, it's a great database.

Some of my former colleagues from a previous job have joined my organization, and they have had some issues with the SQRs because some things work differently in Redshift, like the partition bar. If someone has issues with Redshift, my advice is to check with support.

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

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

I have been using Amazon Redshift for three years.

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.

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.

It is an expensive product.

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.

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.

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

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 scalable, easy to use, and has very good query performance. It is serverless as well.

They introduced machine learning directly in to Redshift, and you can now query using machine-learning functions.

It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed.

AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift. 

We have been using Amazon Redshift from 2013.

For stability, I would give a rating of ten out of ten.

We have 16 Redshift users in our company, and I'd rate the scalability at ten out of ten. 

Redshift's technical support has been great.

The initial setup is simple.

In comparison to the price of similar solutions, Redshift's cost is the lowest.

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.

My primary use for Amazon Redshift is for analytical purposes.

In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes are valuable.

Pricing is one of the concerns that I have because if you compare Snowflake with Redshift, it provides some of the same services, but at a much cheaper rate. So pricing is one of the things that it could improve. It should be more competitive.

Otherwise, everything else looks good, especially the data storage and analytical processes.

I just started using Amazon Redshift. I'm still learning about the product and about how the pricing and the dynamic skilling are done.

I understand that Amazon Redshift is quite stable and it has features like higher readability. So I think it should be a good product to be used.

I have not been in touch with support but I will be needing their support in the near future to help me set up the environment.

In terms of the initial setup, as I said I've still not started using it, so I pray that it's going to be pretty easy for me to set it up.

Of course I would advise others to choose Amazon Redshift, as long as pricing is not a concern for them.

On a scale of 1 - 10, where 1 is the worst and 10 is the best, I'd give it an 8.