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 |
---|---|
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 by differential 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). |
|
Produce JSON-formatted strings that you pass to SYSTEM$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. |