What is Snowflake?
Who uses Snowflake?
Why developers like Snowflake?
Here are some stack decisions, common use cases and reviews by companies and developers who chose Snowflake in their tech stack.
I use Google BigQuery because it makes is super easy to query and store data for analytics workloads. If you're using GCP, you're likely using BigQuery. However, running data viz tools directly connected to BigQuery will run pretty slow. They recently announced BI Engine which will hopefully compete well against big players like Snowflake when it comes to concurrency.
What's nice too is that it has SQL-based ML tools, and it has great GIS support!
Data warehouse solution that fully separates compute and storage. Better management facility than directly using S3. Snowflake