Functions (by Category)

Provides links to the system-defined scalar functions, grouped by category:

Category Description
Bitwise Expression Functions Perform bitwise operations on expressions.
Conditional Expression Functions Manipulate conditional expressions.
Context Functions Provide contextual information about the current environment, session, and object.
Numeric Functions Perform rounding, truncation, exponent, root, logarithmic, and trigonometric operations on numeric values.
String & Binary Functions Manipulate and transform string input.
String Functions (Regular Expressions) Subset of strings functions for performing operations on items that match a regular expression.
Date & Time Functions Manipulate dates, times, and timestamps.
Semi-structured Data Functions Work with semi-structured data (JSON, Avro, etc.).
Conversion Functions Convert expressions from one data type to another data type.
Aggregate Functions Operate on values across rows to perform operations including counts, distincts, mathematical operations, approximate cardinality estimation, etc.
Analytic / Window Functions Compute aggregates over a group (i.e. window) of rows.
Miscellaneous Functions Utility functions, data generation functions, and random distribution functions.