Amazon Redshift Reviews

The valuable features are:

• PostgreSQL Interface
• Scalability
• Pricing/Maintenance/Setup

The PostgreSQL interface is good because you can play with big data with just SQL. This is one of the reasons why they made Hive.

However, Hive’s SQL is still not as standard as what Redshift provides:
http://docs.aws.amazon.com/red...

Redshift has been the data warehouse in at least three of my previous companies. The impact is huge to anyone who uses data in any way.

I would like to see improvements in the database integrations. Currently, Amazon does not provide real-time/near real-time integration with other products like RDS or DynamoDB out-of-the-box.

We need to either build the integrations ourselves, or rely on third-party services which are not always the best.

We have been using this solution for over three years.

There were stability issues in the beginning. However, the product has improved quite a lot in the last two years in term of stability.

Redshift can scale up to a petabyte with a few simple clicks.

Technical support is good, but similar to any other Amazon Web Service, you have to pay for a good level of technical support.

We did not have a previous solution. Redshift worked for us the first time we tried. The pricing could not be beaten by anything else in the market at that time.

The installation was straightforward and only required a few clicks.

Pricing was quite a strong point of Redshift when it was first released. Nowadays, quite a number of other services are very competitive in pricing, such as BigQuery.

Redshift, like any other big data technology, isn’t a silver bullet for everything. The most important thing is to understand your data and your requirements before you make any decision to use any technology.

We primarily use the solution for analytics.

The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing. 

The speed of the solution and its portability needs improvement.

The solution is getting more stable with each new version. It's stable now, but it can always continue to improve.

The solution can scale easily.

I've never been in touch with technical support.

The initial setup was straightforward.

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.

Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features.

Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure. 

I've only used Redshift a couple of times to do a proof of concept.

Redshift has had some scaling issues, but Redshift's performance overall is excellent. 

We haven't encountered many challenges so far.

Redshift setup is easy. It's not an issue. 

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.