General Reference¶
These topics provide general reference information for using Snowflake.
Parameters — parameters that can be used to control system behavior at the account, user, session, and object level.
Data Types — supported data types (VARCHAR, NUMBER, DATE, etc.) in Snowflake:
Collation Support — information about sorting and other character-set-dependent operations on text strings.
SQL Format Models — formats for specifying conversion of numeric and date/time values to and from text strings.
Object Identifiers — rules for defining and using object identifiers, including resolving object names used in SQL statements:
Constraints — concepts and reference information for defining and maintaining unique, primary key, and foreign key constraints in tables:
SQL Variables — concepts and reference for defining and using variables in sessions.
Transactions — concepts and reference for using transactions with SQL statements.
Table Literals — concepts and reference for using table literals instead of a single scalar value in queries.
UDFs (User-Defined Functions) — concepts for creating user-defined SQL and Javascript functions:
External Functions — concepts for creating external functions:
Stored Procedures — concepts for creating stored procedures:
Information Schema — concepts and reference for the Snowflake Information Schema, which consists of a set of metadata views and historical table functions for querying/reporting on objects in Snowflake.
Organization Usage — concepts and reference for the SNOWFLAKE shared database, which is provided by Snowflake for querying/reporting on your account and object usage across your organization.
Account Usage — concepts and reference for the SNOWFLAKE shared database, which is provided by Snowflake for querying/reporting on your account and object usage.