Scalar Functions¶
This document provides links to the systemdefined 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 

Perform bitwise operations on expressions. 

Manipulate conditional expressions. 

Provide contextual information about the current environment, session, and object. 

Convert expressions from one data type to another data type. 

Generate random or sequential values. 

Manipulate dates, times, and timestamps. 

Perform encryption and decryption on VARCHAR or BINARY values. 

Access files staged in cloud storage. 

Work with geospatial data. 

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

Work with semistructured data (JSON, Avro, etc.). 

Manipulate and transform string input. 

Subset of strings functions for performing operations on items that match a regular expression. 

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

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