Ask HN: Technology Reasons for Snowflake Hype?

I’m trying to understand the SNOW IPO from a product perspective - what is driving the interest that is not related to stock price growth (a unicorn)?

I have tested the platform a bit in a trial, and it is interesting, but comparing BigQuery and RedShift I’m missing what makes it stand out justifying its market valuation.

Has anyone used at least two of these platforms and can speak to specific features or capabilities?