THE CHUKEI LOG / ENGINEERING

Engineering

How the proxy speaks Snowflake on the wire — protocol, performance, and fail-open design.

Engineering
Snowflake10 min

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.

DK Dan Kowalski Jun 17
Engineering
Snowflake8 min

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.

RM Rina Mehta Jun 16
Engineering
Snowflake8 min

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.

DK Dan Kowalski Jun 11
Engineering
Snowflake8 min

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.

DK Dan Kowalski May 19