Complete list of System Functions in snowflake

The complete list of System Functions in Snowflake are as follows.

System functions will

  1. Control functions that allow you to execute actions in the system (e.g. aborting a query).
  2. Information functions that return information about the system (e.g. calculating the clustering depth of a table).
  3. Information functions that return information about queries (e.g. information about EXPLAIN plans).

Control
SYSTEM$ABORT_SESSION , SYSTEM$ABORT_TRANSACTION , SYSTEM$CANCEL_ALL_QUERIES , SYSTEM$CANCEL_QUERY , SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE , SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE , SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER , SYSTEM$PIPE_FORCE_RESUME , SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS, SYSTEM$WAIT

Information
SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS , SYSTEM$CLUSTERING_DEPTH , SYSTEM$CLUSTERING_INFORMATION , SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS, SYSTEM$GENERATE_SAML_CSR, SYSTEM$GENERATE_SCIM_ACCESS_TOKEN , SYSTEM$LAST_CHANGE_COMMIT_TIME , SYSTEM$MIGRATE_SAML_IDP_REGISTRATION , SYSTEM$PIPE_STATUS , SYSTEM$TYPEOF , SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN, SYSTEM$WHITELIST , SYSTEM$WHITELIST_PRIVATELINK

Query Information
EXPLAIN_JSON , SYSTEM$EXPLAIN_JSON_TO_TEXT, SYSTEM$EXPLAIN_PLAN_JSON

 

Author: user

Leave a Reply