What's special about Amazon Redshift is that it constantly offers new features to meet the demands of increasingly large data stores. It is undoubtedly the best solution for data storage and processing in the cloud. If you are not yet a user, I highly recommend it.

It takes time to get up to speed with all the features of Amazon Redshift.

Redshift has given us a viable OLAP data warehouse which speeds up all of our analytical workloads. The main benefits we got are speed, ease of use, and reliability, which in turn gave us more time to work on other projects and also much better visibility of our products and business.

Redshift is a reliable cloud data warehouse that's easy to set up especially if your tech infra already runs on AWS.

Scaling out/up/down is quite limited with Redshift. The elastic resize is supposed to help on this but it's still limited to just halving/doubling your current cluster. It's not as flexible as Snowflake or BigQuery. Also, the max concurrency of 50 is quite low compared to other cloud data warehouses.

In my Opinion AWS redshift is an average product, the syntax and methods you have to use if you are used to using SQL server you will find to be more long winded or searching for alternatives ways. Basic items like parameters in stored procedures after a lot more complex than required.

It is a good tool for combining multiple data sources into one place. It is not really useful to load data in a delta approach but to fully reload the data source.

Its ETL process always wants you to create objects as S3 objects which most of the time is fine but you then end up storing the data twice, once in the 3s and then again in Redshift unless you code to delete the S3 files after loading.

Redshift is the bedrock upon which our entire product lives. It stores the underlying data for our reporting, dashboards, etc.

Redshift is a great starting point for storing data if you're planning to build out a stack using other AWS products (EMR clusters, S3 for browsing, etc.). Redshift is reliable/dependable, we haven't faced uptime issues or anything like that. Easy to query against which is essential for us when pulling reports or performing QA. In previous work I've also been able to hook Redshift up directly to Tableau which has been huge in building ad-hoc reporting directly from our datastore.

Integrations aren't always as intuitive as with other tools, but this can be avoided with a solid internal knowledge base.

Amazon Redshift helped us creating standard reports for advertising activities and proved to be a valuable data source for our visual dahsboards

Amazon Redshift allowed us to organize efficiently all our data, both for reporting and visualization purposes. You can use SQL syntax to query the tables and to extract all the info you need. It supports multiple datatypes with many data compression solutions to save disk space and money. The Amazon Redshift console (on the AWS dashboard) allows you to keep track of your db performances, from query execution time to disk space used, and displays also wise recommendation on how to manage properly your tables.

There is nothing I can complain about Amazon Redshift.