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');  Function Name Notes Control Information Deprecated; use the other clustering functions instead. Deprecated; use DATABASE_REFRESH_HISTORY instead. Deprecated; use DATABASE_REFRESH_PROGRESS , DATABASE_REFRESH_PROGRESS_BY_JOB instead. Deprecated; use SYSTEM$ALLOWLIST instead.