Function and stored procedure reference (original) (raw)

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.