You’re both right. Snowflake as a technical slang/jargon generally refers to “flaky” or light-weight solutions that aren’t expected to withstand the test of time/scale.

Snowflake, the data warehousing platform, on the other hand is a juggernaut - in a league of it’s own (I suppose comparable to BigQuery and RedShift).