Operator & Function Reference¶
Provides links to the system-defined operators and functions.
Operators for performing arithmetic, comparison, and logical operations on expressions.
List of all system-defined scalar and table functions.
Functions for performing bitwise operations on expressions.
Functions for working with conditional expressions.
Functions that provide contextual information for the current environment, session, and object.
Functions for performing rounding, truncation, exponent, root, logarithmic, and trigonometric operations on numbers.
Functions for performing operations on string input.
Subset of strings functions for performing operations on items that match a regular expression.
Functions for manipulating dates and timestamps.
Functions for working with semi-structured data (JSON, Avro, etc.).
Functions for converting strings to Snowflake data types.
Functions that operate on values across rows to perform operations including counts, distincts, mathematical operations, approximate cardinality estimation, etc.
Functions that compute an aggregate over a group of rows.
Utility functions, data generation functions, and random distribution functions.