Amazon Redshift

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.

Providing a great interface for queering the complex dataset and also provides a wide range of libraries for multi-language support. But initial setup and schema design and modification is complex compared to others.

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

It's definitely useable if you put time into it, but there are other solutions that are newer and easier to use. My example is Snowflake. I feel like they are a mature solution at this point and offer a level of usability that is not paralleled by Redshift. Even for smaller datasets, where is it more expensive, I feel like paying for ease of use is worth the cost.

RedShift is great for analytics, dealing with a large volume of data and running complex queries. The only reason why it is a 9 and not a 10 is the lack of procedural capabilities out of the box, which requires another software (Matillion, FiveTran) or AWS service (Lambda, Data Pipeline, Kinesis) to fully unleash the power of RedShift.

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.

It is fast and simple to use. I use SQL, so for me it is even better to understand. My clients are happy, my boss is happy, I am happy.

Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.