- Snowflake – Making Queries Fast
Why a query is slow, in the order worth checking. Reading the Query Profile, pruning and what breaks it, spilling to local and remote storage and what to do about it, the three caches and which one you are actually hitting, and when clustering keys earn their cost — which is far less often than people reach for them.
- Snowflake – Querying Data
The SQL that is worth knowing beyond SELECT ... WHERE. CTEs, window functions, QUALIFY — the clause Snowflake has and Postgres does not — SAMPLE for exploring a large table cheaply, GROUP BY ALL, and the date and string functions that come up in every reporting query. All of it against TPCH_SF1.
- Snowflake – JSON and Semi-Structured Data
Loading JSON without designing a schema first, then querying it as if you had. The colon path syntax, casting out of VARIANT and why forgetting to cast makes strings come back with quotes, FLATTEN for arrays, and the decision that actually matters: when to leave data in a VARIANT column and when to shred it into real columns.
- Snowflake – Snowpipe and Continuous Loading
When a nightly COPY is not enough. Snowpipe with cloud-storage event notifications, how its serverless billing differs from a warehouse, monitoring a pipe that has quietly stopped, and where the newer options — Snowpipe Streaming and directory tables — fit. Includes the notification setup that is the only genuinely fiddly part.
- Snowflake – Loading Data with Stages and COPY INTO
Getting files in. Internal versus external stages, PUT and COPY INTO, file formats as reusable objects, why a hundred medium files load faster than one huge one, and what to do when a row fails — ON_ERROR, VALIDATION_MODE and the load metadata that silently skips a file you already loaded.