Reducing Snowflake Costs

cover blue 2

Keebo product update – Sept 2023

The Keebo engineering team is always working on new features and improvements. Our latest update to Keebo Warehouse Optimization for Snowflake brings you more visibility and flexibility than ever before. Here are the highlights.
cover blue 1

Snowflake Optimization: Warehouse Settings

Of all the ways to optimize Snowflake we have discussed in this series, perhaps the easiest one is optimizing your warehouse settings. However, it is also the area that will most directly affect your Snowflake costs, so it is important to monitor warehouse settings frequently as a mistake here will work against you and even nullify the efforts you have made in other areas.
cover blue 1

Snowflake Optimization: Schema Choices

There are 3 types of schema in a relational database: physical, logical, and external. You need to make the right decisions at all 3 of these levels based on business requirements and data semantics. Doing so will directly impact data ingestion and query performance as well, which of course impacts your Snowflake compute usage (direct cost).