Snowflake is built on AWS, you can be sure Amazon has been watching them for years.
I’ll put my money that by 2020 AWS will have a strong Snowflake competitor. Honestly, Athena/Redshift Spectrum are getting somewhat close.
Why?
If it was a smaller company then spreading resources out across more and more products could result in a drop in quality, but this is Amazon. They have practically unlimited resources. They can afford to put far more in to products than other companies, and they've already got a team who can build some really good stuff. If they can capture what works and use it to understand how to build their products that should result in better products rather than worse.
Scale means you can throw lots of people at something, it doesn't mean you can make it good.
Bureaucracy, internal politics, budget/cost cutting, unpleasant work environment, short-term stock price targets instead of long-term goal based targets... There are a million and one reasons why big companies start to suck.
One of the standout features when I used them a few years ago was their ability to do analytic queries on JSON columns in huge databases. Maybe Postgres is up to the task on it's own now, but MongoDB at the time was not.