Amazon Redshift

Multiple integration possible
Easy to setup and use
Lot of features and still evolving

It's a good tool with easy to write SQL with almost all features available.
Offers fastest database on cloud with low maintenance cost.
Loading of data in parallel via AWS is quite convenient.

Overall it serves all our aspects of data management like data cleaning, data manipulation, and data reporting on the cloud platform. We can create stored procedures and triggers in it very easily as all the options are self suggested in it. We can easily attach the results of ARS to the other tools as well for drawing the statistical results.

It is simple and easy to maintain and we saved a lot of dollars in a year.

All technologies have their own pros and cons, and Redshift has pros and cons. For example, in their architecture, the distribution/query process happens on the compute nodes where data is stored. The documentation suggested identifying the best distribution keys and sort keys based on the use of cases before loading the data. The dimensional model also suggests certain recommendations. If we follow these steps properly, certainly we can mitigate performance degradation. This would need data modeling knowledge as well as designing knowledge. A con is that design and modeling skills are required for a better result.

My understanding is that if we take proper measurements at the design phase and decision phase, everything would be up to our satisfaction. Hence I rated 8.