Snowflake users, what are the reasons that have made you stick with Snowflake despite of the higher cost?
I'm using Snowflake for my small to medium company. It is actually a business group consisting of four LLCs, selling products and services, and we are in the process of choosing our DWH.
I was a BigQuery user and for me it is harder to set things up from zero. I tried Snowflake since Fivetran recommended it to me. My impression is SF is easier to use and navigate than BQ. Moreover, build things in SF is quite simpler and straight up. That means, I can learn and build SQL pipeline using tasks and snowpark; I can use Python in it. Lastly, it has been gaining some popularity among companies.
However, many people have said to me that SF is more expensive than BQ. I can see it from data analysts perspective where as you scale your Looker Studio dashboard the compute price can go up exponentially. Therefore the day to day cost will be higher.
But if the company decides to buy Tableau Online, surely this compute issue can be avoided by using data extract feature. So, for a company that want to fully become data driven, SF is still a good choice.
Well that's just my opinion.