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.

• References — use references to authorize access on objects for owner’s rights stored procedures, applications, and classes.

• Ternary logic — information about the behavior of NULL in Boolean expressions and with comparison operators.

• 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:

  • Identifier requirements

  • Literals and variables as identifiers with IDENTIFIER() syntax

  • Object name resolution

• Constraints — concepts and reference information for defining and maintaining unique, primary key, and foreign key constraints in tables:

  • Overview of Constraints

  • Creating Constraints

  • Modifying Constraints

  • Dropping Constraints

• 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.

• SNOWFLAKE database — reference for the SNOWFLAKE shared database, which is provided by Snowflake for querying/reporting on your organization, account, data sharing, and other object usage.

• Snowflake 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.

• Metadata fields in Snowflake — concepts and reference for metadata fields in Snowflake.