While I was browsing our Marketing Ressources today I 're-found' a whitepaper that we created earlier this year.
Benchmarking Exasol against an Amazon Redshift installation.
Find the whitepaper here: https://www.exasol.com/en/resource/benchmark-exasol-and-amazon-redshift/
What are your experiences with the Performance of Cloud Warehouses, did you directly compare? We would love to hear from you
I had the possibility to work with Redshift for a while and I could compare it with Exasol. It was a mixed bag.
From an SQL prospective working with Redshift is like working with a 15 years old PostgreSQL:
If you are a DBA you would love Redshift, spinning up a cluster takes very little time (and you can script it with CloudFormation). Backups are done automatically and can be restored quickly, you can also pick specific tables from a backup. Scaling is also quite easy and is managed by AWS. There is a monitoring dashboard to see what is happening and even a Query Advisor. Compared to Exasol Redshift here has the upper hand.
Not sure if you notice but, for me, the interesting features are the ones related to cloud functionalities where they can charge you more (backups or scaling) or keep you in the AWS ecosystem. In fact it is no coincidence that the user management in Redshift is bad, you will be much better off if you use AWS IAM Role instead of groups or the introduction of Redshift Spectrum (Impala), a convenient way to run queries on top of big data formats.
Final words. I would not recommend people to use Redshift if they are not already heavily involved with the AWS ecosystem or have real use cases for a growing and shrinking database (even in that case a product like Snowflake is much more developer friendly than Redshift offering the same pros for the DBAs - there the problems are the costs). But, because Redshift is an AWS product, it is very easy for a medium/small company to start the first cluster and start playing with it (then they will hardly move from there).