Function and stored procedure reference¶

These topics provide reference information for the system-defined functions and system-defined stored procedures.

• Summary of functions — combined summary of all system-defined functions. Can be used as a quick-reference.

• All functions (alphabetical) — alphabetical list of all system-defined functions (scalar, aggregate, table, etc.).

• Aggregate functions — functions that take multiple rows/values as input and return a single value.

• Scalar functions — functions that take a single row/value as input and return a single value:

  • Bitwise expression functions

  • Conditional expression functions

  • Context functions

  • Conversion functions

  • Data generation functions

  • Date & time functions

  • Differential privacy functions

  • Encryption functions

  • Geospatial functions

  • Hash functions

  • Metadata functions

  • Notification functions

  • Numeric functions

  • Semi-structured and structured data functions

  • String functions (regular expressions) — regular expression (search) functions

  • String & binary functions

  • Vector similarity functions

• Model monitor functions — functions that retrieve metrics from machine learning model monitors.

• System functions — functions that perform control operations or return system-level information.

• Table functions — functions that return results in tabular format.

• Window functions — functions that run analytic calculations, such as moving aggregations and rankings.

• Data metric functions — functions that enable data quality measurements for tables and views.

• Stored procedures — stored procedures to facilitate using certain Snowflake features.