Here's a quick write up on AWS redshift's features, advantages and unique use-cases - https://dev.to/aws-builders/aws-redshift-advantages-and-use-cases-183n