They fit well in the market space despite being a relational DB SAAS with big competitors. It's superiority is in its flexibility. When I say it was many more features its not like, "oh that's cool" but actual practical features that AWS and Google Cloud don't have.
Not really sure how to get into this without sounding like too esoteric or anything but its part of the design shift from traditional ETL (Extract Transform Load) to the superior (Extract Load Transform) that's been coming around for a number of years. You can ETL all of your data into it fairly cheaply and cut out middle man data loading services like Fivetran (IPO next year) or Segment if you meet a few requirements. And you don't need to use expensive ETL design tools like IBM InfoSphere/Datastage and stuff like that.
- Easy and cheap ETL if you meet a few requirements.
- Ex. What Segment would charge you $1M to load to your databases in a year will cost you like $10-20k with just using Snowflake's features.