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 returningone value per row. This contrasts withAggregate 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. | |
Work with data protected bydifferential privacy. | |
Perform encryption and decryption on VARCHAR or BINARY values. | |
Access files staged in cloud storage. | |
Work with geospatial data. | |
Hash values to signed 64-bit integers using a deterministic algorithm. | |
Retrieve data or metadata about database objects (e.g. tables) or files (e.g. staged files). | |
Retrieve metrics from machine learningmodel monitors. | |
Produce JSON-formatted strings that you pass toSYSTEM$SEND_SNOWFLAKE_NOTIFICATION when sending a notification to a queue or email address. | |
Perform rounding, truncation, exponent, root, logarithmic, and trigonometric operations on numeric values. | |
Work with semi-structured data (JSON, Avro, etc.). | |
Manipulate and transform string input. | |
Subset of strings functions for performing operations on items that match a regular expression. |