System functions¶

Snowflake provides the following types of system functions:

• Control functions that allow you to execute actions in the system (e.g. aborting a query).

• Information functions that return information about the system (e.g. calculating the clustering depth of a table).

• Information functions that return information about queries (e.g. information about EXPLAIN plans).

Many of these system functions have the prefix SYSTEM$ (e.g. SYSTEM$TYPEOF). For the system functions that use this prefix, you must specify the prefix when calling the function. For example:

SELECT SYSTEM$TYPEOF('a');