Live data from Hacker News

Why is Snowflake so expensive

blog.devgenius.io

11–20 of 217 posts

Re: Why is Snowflake so expensive

#12

Snowflake is a bit generic to easily find - and the article has no hyperlinks - anybody have a one sentence summary? EDIT: There it is: https://www.snowflake.com/ Data warehousing, basically.

It's a data warehouse, like Google BigQuery or AWS Redshift / Athena

Re: Why is Snowflake so expensive

#13
I am like 95% sure that the MAX issue he mentions is wrong - I just modified some windowing function based approaches to the one he mentions and its several OOM faster because of partition elimination.

Nonetheless I agree with the basic points of the article.

Re: Why is Snowflake so expensive

#14
I'm of the mind that Snowflake and Databricks are losing their value prop now that Delta Lake is open source and Iceberg is maturing. What's to stop me from rolling my own Spark clusters and just using one of those? Is anyone doing this?

Re: Why is Snowflake so expensive

#15

The monthly bill does make me wince, but Snowflake of course includes all server and compute costs, no installation, initial configuration or upgrades etc. It’s genuine SaaS. It’s also very simple to manage and optimise so less DBA or DevOps type manpower. Then of course you can perfectly right size your instances and pay by the second for compute and by the byte for storage. Expensive, but lower TCO than alternate a…

It’s also very simple to manage and optimise so less DBA or DevOps type manpower.

Then of course you can perfectly right size your instances and pay by the second for compute and by the byte for storage.

These two are connected vessels.

Re: Why is Snowflake so expensive

#16

The monthly bill does make me wince, but Snowflake of course includes all server and compute costs, no installation, initial configuration or upgrades etc. It’s genuine SaaS. It’s also very simple to manage and optimise so less DBA or DevOps type manpower. Then of course you can perfectly right size your instances and pay by the second for compute and by the byte for storage. Expensive, but lower TCO than alternate a…

Yeah...100%. It's expensive til you try running a data warehouse yourself and have to hire in to support it.

Like any other service there are scale points where it no longer makes sense but for most smaller orgs it's still a bargain over DIY

Re: Why is Snowflake so expensive

#17

I'm of the mind that Snowflake and Databricks are losing their value prop now that Delta Lake is open source and Iceberg is maturing. What's to stop me from rolling my own Spark clusters and just using one of those? Is anyone doing this?

>What's to stop me from rolling my own Spark clusters and just using one of those? Is anyone doing this?

Ops. Unless your core competency is running reports and spark nodes, it's probably cheaper to outsource the management of Spark and friends than to hire people to make sure it's always up and running. To be fair I haven't touched Spark in many years but having to page someone who was good enough to spark to debug why a job stopped at 3am isn't fun.

Re: Why is Snowflake so expensive

#18

I'm of the mind that Snowflake and Databricks are losing their value prop now that Delta Lake is open source and Iceberg is maturing. What's to stop me from rolling my own Spark clusters and just using one of those? Is anyone doing this?

You'll find plenty of the customer base of Databricks used to run their own clusters.

It's a tradeoff. It might cost less dollars but more time. The time and expertise to run their own clusters effectively is not something every org can or desires to do.

Re: Why is Snowflake so expensive

#19
"Snowflake has no incentive to push a code change that makes things 20% faster because that can correspond to 10–20% drop in short-term revenue. In a typical Innovator’s Dilemma, Snowflake prioritizes other things that generate an ever larger menu of compute options, like Snowpark and data apps built on Streamlit, that will bleed your organization dry."

This is not true. Snowflake has done just that - it has continuously improved performance resulting in reduced credit consumption and revenue from customers on a unit compute/storage basis. And it has negatively impacted their revenues and stock price. Snowflake's incentive is to strengthen their competitive position and to hopefully generate more long-term revenue from their customers.

The CFO forecasted a $97 million dollar short fall when guiding for 2022 revenue resulting from product improvements. Snowflake stock dropped immediately after.

See Q4 transcript -- https://www.fool.com/earnings/call-transcripts/2022/03/02/sn...

"Similarly, phased throughout this year, we are rolling out platform improvements within our cloud deployments. No two customers are the same, but our initial testing has shown performance improvements ranging on average from 10% to 20%. We have assumed an approximately $97 million revenue impact in our full-year forecast, but there is still uncertainty around the full impact these improvements can have. While these efforts negatively impact our revenue in the near term, over time, they lead customers to deploy more workloads to Snowflake due to the improved economics."

Also see the Bloomberg article -- https://www.bloomberg.com/news/articles/2022-03-02/snowflake....

"Snowflake Inc., a software company that helps businesses organize data in the cloud, dropped the most ever in a single day Thursday after projecting that annual product sales growth would slow from its previous triple-digit-percentage pace.

Executives said improvements to the company’s data storage and analysis products will let customers get the same results by spending less, which will hurt revenue in the short term, but attract more clients in the future.

“The full-year impact of that next year is quite significant,” Chief Executive Officer Frank Slootman said on a conference call Wednesday after the results were released. But “when customers see their performance per credit get cheaper, they realize they can do other things cheaper in Snowflake and they move more data into us to run more queries.”"

Re: Why is Snowflake so expensive

#20
post #2

You would think they would be saving (and charging the customer!) a bundle not enforcing constraints on their tables. I’d be very interested to hear the Snowflake side of this decision, but to the customer it’s simply unforgivable to have cosmetic constraints on a database.

Do you really need functional constraints in a OLAP database? Surely such validations already exist wherever your data is coming from.
Post reply on HN