Of course, every product has pluses and minuses. From that perspective, Snowflake has to improve there spatial parts. I mean it doesn't have much stuff in geo-spatial queries.
Scalability: Ability to load huge number of datasets (I have experience with petabytes of data) and process those things. Storage is not limited. We can increase whatever we want.
Performance: The distributed architecture of Snowflake has the capacity to process huge dataset faster and we can scale up and down as per the need.
Flexibility: This feature is helpful for user to increase the node size and config depending on their need. There is no need to wait for hardware to be in place whenever we increase the dataset. Snowflake provides the option to increase the node or cluster size whenever required.
Multi-formatted accessibility: The Snowflake engine has the capability to read the following file formats: CSV, DELIMITER, FIXEDWIDTH, AVRO, JSON, BZIP2, GZIP, LZOP. The user can choose which is best for their requirements.
Configuration: Even-though its running in AWS platform, it beats their platform product. Actually I feel more flexible than Redshift.
Snow-pipe: Snow-Pipe is better system to feed stream data to snowflake database. This is really helpful for less self-life triggering datasets.