Baselit

tl;dr: Baselit automatically optimizes Snowflake costs with zero human effort. To find out how much you can save on Snowflake with Baselit, run this SQL query. Start saving today by booking a demo here.

Watch our demo video

Why build Baselit?

In our conversations with data teams over the last year, the topic of Snowflake costs came up frequently - how it had become a top concern, and cost optimization was now their business priority. Every few months, they would manually look for opportunities to cut down on costs (removing workloads or optimizing queries) - a time consuming process. We decided to build a solution that could automate cost optimization, and complement the manual effort of data teams.

How does it work?

If you want to lower your data processing costs, usually the only thing you can do is to just process less data (i.e. query optimization). But Snowflake’s warehouse abstraction allows an extra dimension along which you can optimize - by minimizing the compute you need to process that same data (i.e. warehouse optimization). Baselit automates Snowflake warehouse optimization for you.

You can easily find out how much you can save with Baselit. Run this SQL query on your Snowflake - it will calculate your savings.

There are two main components of Baselit:

1. Automated agents that cut down on warehouse idle time. This happens in one of two ways: cache optimization (when to suspend a warehouse vs letting it run idle) and cluster optimization (optimal spin down of clusters).

2. Autoscaler that lets you create custom scaling policies for multi-cluster warehouses based on SLAs. Snowflake’s default policies (Economy and Standard) are not cost optimal in most cases, and they don’t give you any control. With Autoscaler, you can save costs and improve performance with a bespoke scaling policy for each warehouse.

We’ve built a bunch of other features that help in optimizing Snowflake costs: dbt optimizer that automatically picks the right warehouse size for dbt models through constant experimentation, a “cost lineage”, spend views by teams/roles/users, and automatic recommendations from scanning Snowflake metadata.

Our Ask 👋

1. If you’d like to know more about Baselit, and see a live demo - book one here.

2. Curious about how much you can actually save with Baselit? Run this SQL query on your Snowflake!