Snowflake

Treat Snowflake as a distinct cloud data platform, not PostgreSQL with different hosting. Focus on behavior that a capable SQL user or coding agent is likely to guess incorrectly; do not teach generic SQL or data-modeling basics.

Start with the live contract

Snowflake syntax and feature contracts change frequently. Start at the official LLM documentation index, then prefer the current SQL command/function reference over remembered syntax, examples in training data, or a historical workaround. Verify versioned client and Snowpark APIs against the version actually in use.

The bundled guidance was checked against official Snowflake documentation on 2026-09-02. Treat that date as a provenance baseline, not a frozen platform version: current official documentation and the target account's live capabilities take precedence.

Inspect the repository's existing Snowflake migrations, helpers, query builders, deployment tooling, and tests before introducing a new query shape. Establish which interface executes the work: worksheet, snow sql, driver, SQL API, Snowpark, task, dynamic table, Cortex REST API, or another service.

Load only the references the task needs