About
What this is
A small static site of practical Snowflake SQL patterns. It exists so someone facing a recurring warehouse problem can find a worked example, the usual failure mode, and a pointer to the official documentation.
Independence
This is an independent resource. It is not affiliated with, endorsed by, or sponsored by Snowflake Inc. Snowflake is a trademark of Snowflake Inc. Always prefer Snowflake Documentation when behavior, syntax, or product features are in question.
How examples were checked
- Some SQL was executed in DuckDB 2.0.0 (QUALIFY, UNNEST as a stand-in for flattening arrays, MERGE). Those pages say so.
- Snowflake-specific syntax (FLATTEN options, Time Travel, CLONE, clustering keys, COPY INTO, timestamp types, SAMPLE methods) was verified against official Snowflake documentation and was not executed on Snowflake. Those pages say so.
- Nobody is claiming that a particular person ran these in a production Snowflake account. There are no fabricated benchmarks, credit figures, or timings.
What this is not
A comprehensive reference, a training course, or a substitute for the official docs. Features change; re-check the linked documentation before you rely on a clause in production.