We use reserved Redshift instances for close to 3 years now. There were a few moments that we were slightly screwed by new features and bugs in Redshift, but most of the time, we don't need to deal with any maintenance, and because we are fully on AWS, Redshift works way better with other systems we build or use (we have a few use cases of bigquery). We do have lots of regular queries running every hour, and we did lots of optimizations on Redshift. Overall, we are happy with Redshift.
I think in term of EDW solutions, it is really not a one size fits all situation. I am happy for the people (especially small companies who can't afford running Redshift 24/7) who went with BigQuery, but I am also happy that we chose Redshift and so far, it has been great.
I think in term of EDW solutions, it is really not a one size fits all situation. I am happy for the people (especially small companies who can't afford running Redshift 24/7) who went with BigQuery, but I am also happy that we chose Redshift and so far, it has been great.