Official Docs

Overview

The authoritative source for everything on the Snowflake pages in this project. Snowflake documents one continuously-released version, so there is no version selector — but behaviour does change, and a note in the docs is the only reliable record of when.

Snowflake SQL Reference — the language index.

Identifiers and types

Topic	Official page
Upper-case folding and quoting	Identifier Requirements
Every data type	SQL Data Types Reference
VARIANT, OBJECT and ARRAY	Semi-structured Data Types
Querying a VARIANT with path syntax	Querying Semi-structured Data
Turning an array into rows	FLATTEN

Functions and statements

Topic	Official page
All functions	Function and Stored Procedure Reference
UPDATE — and why the target takes no alias	UPDATE
MERGE	MERGE
Filtering on a window function	QUALIFY
Transactions — statement-scoped by default	Transactions

Procedural code

Topic	Official page
Snowflake Scripting, end to end	Snowflake Scripting Developer Guide
EXCEPTION blocks, SQLERRM, SQLSTATE	Handling Exceptions
Procedure syntax and dollar-quoting	CREATE PROCEDURE
The Python surface	Snowpark Python

Why the constraints are documentation

Topic	Official page
Which constraints are enforced	Constraints Overview
Declaring them anyway	CREATE TABLE ... CONSTRAINT
Micro-partitions — why there are no indexes	Micro-partitions and Data Clustering
The nearest thing to an index	Clustering Keys and Clustered Tables
Table design decisions	Table Structuring Considerations

Loading data, and the platform around it

Topic	Official page
Every load path	Data Loading Overview
COPY INTO — what write_pandas calls underneath	COPY INTO
write_pandas, use_logical_type, quote_identifiers	Python Connector: pandas
Unloading, for reconciliation extracts	Data Unloading Overview
Warehouses — what a reconciliation query costs	Virtual Warehouses
Roles and grants, for the target account	Access Control Overview
INFORMATION_SCHEMA and ACCOUNT_USAGE	Information Schema