Warehouse Optimization

warehouse settings

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.

schema choices 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).

Blog Snowflake Optimization

Snowflake Optimization: Avoiding Query Mistakes

Inefficient or poorly written queries are one of the biggest factors to consider when reducing Snowflake costs. Here are the top 8 mistakes we see that are easiest to correct and can have an immediate impact on query performance and cost.

Photo of desserts

Snowflake Data for Breakfast, the Keebo Optimizer for Dessert

I am looking forward to attending a nearby Snowflake Data for Breakfast session next week to learn more about how Snowflake customers are uniting siloed data, working and collaborating seamlessly across multiple clouds, and other ways they are leveraging Snowflake…

Reasons to Use Keebo

Four Reasons to Use Keebo to Auto Optimize Snowflake

In How to simplify Snowflake Optimization, you learned about the four types of Snowflake optimizations:  And by reading Keebo’s Complete Guide to Optimizing Snowflake’s Cost and Query Performance, you learned how Keebo could easily automate these complex optimizations for you.…