Snowflake is solidly a B2B analytics app. It is, and I don't mean this dismissively, nothing new. They do it
very well, and their market performance agrees with that notion, and they are innovating within their field, but data warehousing is complicated, especially at scale and they're not breaking new ground by providing a better solution for that. For a small company's analytics, I can download a CSV file and do all my analysis in Excel. But at a bigger company, when that "CSV file" is terabytes, possibly even petabytes of data, it's going to take a bit more of work to deal with it. For companies who's core expertise
isn't shoveling around data like that and loading it into a database, it's reasonable to contract with a vendor to do that. Snowflake is just one among many other vendors who do this.
To answer your question, what's great is that anybody who can SQL can use this, developers and business analysts alike. Developers who want data to back up product decisions will use this to answer, eg, how many customers use feature A vs feature B, and then use that information to choose to build either feature C or feature D. Business analysts want answers about the business, and if they have to write SQL to do it, then they'll partner with someone who can, or more likely, just learn SQL. (This is why "data scientist" is a hot new career path.)
Corporations that are in a place to be giving Snowflake a million dollar contract most likely already have a similar system already in place, either homegrown or via a competitor. (Eg Amazon Redshift.) Thus, their positioning depends on the customer, but for customers that previously already had a million dollar contract just with a different vendor, their focus is on why their product is super-amazing-awesome compared to their competition. (Which, and the market agrees, it is.)
patio11 has a thread on just how unseen some of the niches of software is - https://twitter.com/patio11/status/1235919318329643008
Software is like an iceberg - there's a wild world of software that none of us have heard of. It seems strange that it's possible for Snowball to succeed given that it's "essentially a stream of data that needs experts in order to use it", but the same thing is true about the Internet in the 1980s.