In the last two years I have used both Redshift (AQUA) and Snowflake, and I prefer Snowflake by a mile. Snowflake is just a lot easier to use, scales better and has a much better permission model.