Summary of Functions¶
Snowflake supports most of the standard functions defined in SQL:1999, as well as parts of the SQL:2003 analytic extensions.
In this Topic:
Scalar Functions¶
Aggregate Functions¶
Window Functions¶
Window functions are aggregate functions that can operate on a subset of rows within the set of input rows.
Table Functions¶
Category/Sub-category |
Functions |
---|---|
Data Loading
|
|
Data Generation
|
|
Object Modeling
|
|
Semi-structured Queries
|
|
Query Results
|
|
Historical & Usage Information . (Information Schema) |
|
Queries
|
QUERY_HISTORY , QUERY_HISTORY_BY_* ( SESSION | USER | WAREHOUSE ) , EXTERNAL_FUNCTIONS_HISTORY |
Warehouse & Storage Usage
|
DATABASE_STORAGE_USAGE_HISTORY , STAGE_STORAGE_USAGE_HISTORY , WAREHOUSE_METERING_HISTORY |
Column-level Security
|
|
Data Loading & Transfer
|
|
SCIM
|
|
User Login
|
|
Search Optimization Maintenance
|
System Functions¶
User-defined Functions (UDFs)¶
In addition to the system-defined functions provided by Snowflake, users can create functions. Snowflake supports the following types of UDFs:
Type |
Notes |
---|---|
SQL |
SQL UDFs can be defined to return either scalar or tabular output. |
JavaScript |
JavaScript UDFs can be defined to return either scalar or tabular output. |
External Functions¶
Snowflake also supports External Functions, which are stored and executed outside Snowflake.