Scalar Functions

This document provides links to the system-defined scalar functions, grouped by category.

A scalar function is a function that returns one value per invocation; in most cases, you can think of this as returning one value per row. This contrasts with Aggregate Functions, which return one value per group of rows.

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.

Conversion Functions

Convert expressions from one data type to another data type.

Data Generation Functions

Generate random or sequential values.

Date & Time Functions

Manipulate dates, times, and timestamps.

Encryption Functions

Perform encryption and decryption on VARCHAR or BINARY values.

File Functions

Access files staged in cloud storage.

Geospatial Functions

Work with geospatial data.

Numeric Functions

Perform rounding, truncation, exponent, root, logarithmic, and trigonometric operations on numeric values.

Semi-structured and Structured Data Functions

Work with semi-structured data (JSON, Avro, etc.).

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.

Hash Functions

Hash values to signed 64-bit integers using a deterministic algorithm.

Metadata Functions

Retrieve data or metadata about database objects (e.g. tables) or files (e.g. staged files).