Snowflake perplexes me. From what I can see of my own org it's a data tool with a database behind it that you can't swap out for another or run on your own cloud account.
Snowflake is trying to build something broader than a database. A cloud platform for storing, processing and sharing data.
But why Snowflake perplexes you and not Bigquery, Redshift or Databricks?