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?
Polished interface and standard SQL interface
No hand optimisation required, data stored in efficient proprietary storage
Compute optimization managed by snowflake, manage it's own pools.
Seamless sharing or replication of data
All of these are easily replicable by competitors, but it also has the closed garden network effect.