Snowflake Query Optimization: Cut Compute Without Rewriting Dashboards
A practical guide to Snowflake query optimization: manual tuning (prune SELECT *, push predicates, clustering) and deterministic in-path rewrites — no LLM, fail-open.
Snowflake Query Result Cache: How It Stays Correct
How Snowflake's query result cache works, its limits, and how a verified, false-positive-intolerant proxy cache stays correct across warehouses and sessions.
How chukei speaks Snowflake's wire protocol without breaking a single client
An engineering deep-dive into the transparent wire-protocol proxy that sits in the Snowflake query path, passes auth straight through, streams results, and fails open.
Deterministic SQL rewrites that are always safe to apply
How chukei rewrites expensive Snowflake query shapes inline using an equivalence-tested, deterministic AST rule-pack — no LLM on the hot path, fail-open by design.