In my org some CV-finessor first persuaded the accountants to pay for Netezza, then some Redshift bollocks in AWS and latterly this Snowflake jobby. The Netezza thingy was, to be fair, pretty quick. And fatally expensive. The AWS wossname didn't come even close to the same performance, not surprising since the old doodah was strictly on-prem.
Now this melty cristal.
I'm a software dev, not a DB-guy, but my impression is that the web-based client is pretty good, and that the database performance is decidedly mediocre. But not totally unusable. It's been a long time since I set off a query and made a cup of coffee while it did its thing. This is a commonplace with Snowflake. Don't bleat about the bigness of the data, that's precisely what you are selling.
-A.