Chose Snowflake
Redshift and Hive both have unique architecture. Both have their own cons. My guess is that Snowflake is made up by using the concepts of the two architecture concepts such as Amazon Redshift and Haddop, addressed the issues or gaps found in Redshift and Hadoop.
Independently Invited by TrustRadius
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info