Solutions to manage runaway Snowflake costs?

Posted by concernedeng on Monday January 15, 2024 @06:25PM
from the self-post dept.

My org's Snowflake bill has 2xed over the past year as the company has grown -- when I joined in 2021, we were spedning ~$30k / year and now we're spending at a rate of $67k / year.

As head of data, I have a few data / infra engineers on my team, but we're spread too thin to do all the optimization / management / policing work we'd need to do to get a handle on these costs.

Anyone else dealing with this problem? Any products on the market that seem effective for this? Or creative solutions I may not have thought of?

( 2 comments | on HN )

Re:Solutions to manage runaway Snowflake costs? by BohuTANG on Tuesday January 16, 2024 @09:14PM (#39022329)

Managing costs with Snowflake's virtual warehouse is more straightforward, allowing you to adjust the warehouse's size and operational status to control expenses. However, optimizing costs for Snowflake's cloud service is more complex. Each SQL query incurs costs for parsing and planning. These costs, less transparent than warehouse expenses, increase as your business and request volume grow, making budgeting and cost control challenging.

To address this, consider DatabendCloud – a cost-effective alternative to Snowflake, built entirely in Rust.

Key Benefits of DatabendCloud:

*Significant cost savings, over 50% compared to Snowflake.

*Similar user experience to Snowflake, with comparable syntax and product functionalities.

*Minimal to no cloud service fees; costs are primarily based on warehouse usage.

*Transparent pricing model, allowing you to easily estimate expenses at: https://www.databend.com/plan/

Links:

[1] DatabendCloud: https://databend.com/

[2] Databend vs. Snowflake: https://github.com/datafuselabs/databend/issues/13059

[3] TPC-H SF100: https://twitter.com/DatabendLabs/status/1714456893941526761

[ Parent | on HN ]

Re:Solutions to manage runaway Snowflake costs? by BohuTANG on Wednesday January 17, 2024 @07:03AM (#39026598)

TPC-H Benchmark: Databend Cloud vs. Snowflake: https://docs.databend.com/guides/benchmark/tpch

[ Parent | on HN ]