Warehouse Optimization

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).
cover blue 2

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.