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 NameNotes
Control
EXECUTE_AI_EVALUATION
SYSTEM$ABORT_SESSION
SYSTEM$ABORT_TRANSACTION
SYSTEM$ACTIVATE_CMK_INFO
SYSTEM$ACTIVATE_CMK_INFO_POSTGRES
SYSTEM$ADD_EVENT (for Snowflake Scripting)
SYSTEM$ADD_REFERENCE
SYSTEM$AUTHORIZE_PRIVATELINK
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS
SYSTEM$AUTHORIZE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS
SYSTEM$BEGIN_DEBUG_APPLICATION
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS
SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS_WITH_EXCEPTION
SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS
SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_WITH_EXCEPTION
SYSTEM$CANCEL_ALL_QUERIES
SYSTEM$CANCEL_QUERY
SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS
SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT
SYSTEM$CONVERT_PIPES_SQS_TO_SNS
SYSTEM$CREATE_BILLING_EVENT
SYSTEM$CREATE_BILLING_EVENTS
SYSTEM$CREATE_EVALUATION_DATASET
SYSTEM$DEACTIVATE_CMK_INFO
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT
SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSS
SYSTEM$DEREGISTER_CMK_INFO
SYSTEM$DEREGISTER_CMK_INFO_POSTGRES
SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE
SYSTEM$DISABLE_DATABASE_REPLICATION
SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT
SYSTEM$DISABLE_PREVIEW_ACCESS
SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLY
SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE
SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT
SYSTEM$ENABLE_PREVIEW_ACCESS
SYSTEM$END_DEBUG_APPLICATION
SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLY
SYSTEM$FINISH_OAUTH_FLOW
SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER
SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT
SYSTEMISSUE_PER_ACCOUNT_APP_SERVICE_CERTIFICATE
SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME
SYSTEM$LINK_ORGANIZATION_USER
SYSTEM$LINK_ORGANIZATION_USER_GROUP
SYSTEM$MIGRATE_SAML_IDP_REGISTRATION
SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS
SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS
SYSTEM$OPT_OUT_MALICIOUS_IP_PROTECTION_BY_CATEGORY
SYSTEM$PIPE_FORCE_RESUME
SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT
SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSS
SYSTEM$REGISTER_CMK_INFO
SYSTEM$REGISTER_CMK_INFO_POSTGRES
SYSTEM$REGISTER_PRIVATELINK_ENDPOINT
SYSTEM$REMOVE_ALL_REFERENCES
SYSTEM$REMOVE_REFERENCE
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSS
SYSTEM$REVOKE_PRIVATELINK
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS
SYSTEM$REVOKE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS
SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH
SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG
SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS
SYSTEM$SET_CATALOG_INTEGRATION
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND
SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT
SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION
SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAME
SYSTEM$SET_REFERENCE
SYSTEM$SET_ROW_TIMESTAMP_ON_ALL_SUPPORTED_TABLES
SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUS
SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN
SYSTEM$START_OAUTH_FLOW
SYSTEM$START_USER_EMAIL_VERIFICATION
SYSTEM$TASK_DEPENDENTS_ENABLE
SYSTEM$TRIGGER_LISTING_REFRESH
SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS
SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS
SYSTEM$UNLINK_ORGANIZATION_USER
SYSTEM$UNLINK_ORGANIZATION_USER_GROUP
SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND
SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT
SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION
SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS
SYSTEM$WAIT
Information
EXTRACT_SEMANTIC_CATEGORIES
GET_ANACONDA_PACKAGES_REPODATA
SHOW_PYTHON_PACKAGES_DEPENDENCIES
SYSTEM$ALLOWLIST
SYSTEM$ALLOWLIST_PRIVATELINK
SYSTEM$APP_COMPATIBILITY_CHECK
SYSTEM$APPLICATION_GET_LOG_LEVEL
SYSTEM$APPLICATION_GET_METRIC_LEVEL
SYSTEM$APPLICATION_GET_TRACE_LEVEL
SYSTEM$AUTO_REFRESH_STATUS
SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS
SYSTEM$CATALOG_LINK_STATUS
SYSTEM$CKE_HASH_FUNCTION
SYSTEM$CLIENT_VERSION_INFO
SYSTEM$CLIENT_VULNERABILITY_INFO
SYSTEM$CLUSTERING_DEPTH
SYSTEM$CLUSTERING_INFORMATION
SYSTEM$CLUSTERING_RATIODeprecated; use the other clustering functions instead.
SYSTEM$CURRENT_USER_TASK_NAME
SYSTEM$DATA_METRIC_SCAN
SYSTEM$DATABASE_REFRESH_HISTORYDeprecated; use DATABASE_REFRESH_HISTORY instead.
SYSTEM$DATABASE_REFRESH_PROGRESS , SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOBDeprecated; use DATABASE_REFRESH_PROGRESS , DATABASE_REFRESH_PROGRESS_BY_JOB instead.
SYSTEM$DECODE_PAT
SYSTEM$DESC_ICEBERG_ACCESS_IDENTITY
SYSTEM$ENCODE_CKE_PRIMARY_KEY
SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS
SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS
SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS
EXPLAIN_PRIVILEGES
SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEW
SYSTEM$EXTERNAL_TABLE_PIPE_STATUS
SYSTEM$GENERATE_SAML_CSR
SYSTEM$GENERATE_SCIM_ACCESS_TOKEN
SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES
SYSTEM$GET_ALL_REFERENCES
SYSTEM$GET_AWS_SNS_IAM_POLICY
SYSTEM$GET_CATALOG_LINKED_DATABASE_CONFIG
SYSTEM$GET_CLASSIFICATION_RESULT
SYSTEM$GET_CMK_AKV_CONSENT_URL
SYSTEM$GET_CMK_CONFIG
SYSTEM$GET_CMK_CONFIG_POSTGRES
SYSTEM$GET_CMK_INFO
SYSTEM$GET_CMK_INFO_POSTGRES
SYSTEM$GET_CMK_KMS_KEY_POLICY
SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE
SYSTEM$GET_DBT_LOG
SYSTEM$GET_DEBUG_STATUS
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND
SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT
SYSTEM$GET_DIRECTORY_TABLE_STATUS
SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD
SYSTEM$GET_HASH_FOR_APPLICATION
SYSTEM$GET_ICEBERG_TABLE_INFORMATION
SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS
SYSTEM$GET_LOGIN_FAILURE_DETAILS
SYSTEM$GET_PREDECESSOR_RETURN_VALUE
SYSTEM$GET_PREVIEW_ACCESS_STATUS
SYSTEM$GET_PRIVATELINK
SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS
SYSTEM$GET_PRIVATELINK_CONFIG
SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO
SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS
SYSTEM$GET_PURCHASE_ATTRIBUTES
SYSTEM$GET_REFERENCED_OBJECT_ID_HASH
SYSTEM$GET_SERVICE_CALLER_TOKEN_EXPIRYReturns the expiration timestamp of a caller’s rights login token.
SYSTEM$GET_SERVICE_DNS_DOMAIN
SYSTEM$GET_SERVICE_LOGS
SYSTEM$GET_SERVICE_STATUS — DeprecatedDeprecated; use the SHOW SERVICE CONTAINERS IN SERVICE command instead.
SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGES
SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO
SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTS
SYSTEM$GET_TABLE_ARCHIVE_METADATA
SYSTEM$GET_TAG
SYSTEM$GET_TAG_ALLOWED_VALUES
SYSTEM$GET_TAG_ON_CURRENT_COLUMN
SYSTEM$GET_TAG_ON_CURRENT_TABLE
SYSTEM$GET_TASK_GRAPH_CONFIG
SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT
SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS
SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED
SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARING
SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT
SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER
SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT
SYSTEM$IS_LISTING_PURCHASED
SYSTEM$IS_LISTING_TRIAL
SYSTEM$LAST_CHANGE_COMMIT_TIME
SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES
SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG
SYSTEM$LIST_NAMESPACES_FROM_CATALOG
SYSTEM$LOCATE_DBT_ARCHIVE
SYSTEM$LOCATE_DBT_ARTIFACTS
SYSTEM$LOG, SYSTEM$LOG_<level> (for Snowflake Scripting)
SYSTEM$PIPE_STATUS
SYSTEM$QUERY_REFERENCE
SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW
SYSTEM$REFERENCE
SYSTEM$REGISTRY_LIST_IMAGESDeprecated; use the SHOW IMAGES IN IMAGE REPOSITORY command instead.
SYSTEM$REPORT_HEALTH_STATUS
SYSTEM$SET_RETURN_VALUE
SYSTEM$SET_SPAN_ATTRIBUTES (for Snowflake Scripting)
SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES
SYSTEM$SHOW_BUDGETS_FOR_RESOURCE
SYSTEM$SHOW_BUDGETS_IN_ACCOUNT
SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS
SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS
SYSTEM$SHOW_OAUTH_CLIENT_SECRETS
SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIES
SYSTEM$STREAM_BACKLOGThis function is a table function.
SYSTEM$STREAM_GET_TABLE_TIMESTAMP
SYSTEM$STREAM_HAS_DATA
SYSTEM$SUPPORTED_DBT_VERSIONS
SYSTEM$TASK_RUNTIME_INFO
SYSTEM$TYPEOF
SYSTEM$VALIDATE_STORAGE_INTEGRATION
SYSTEM$VERIFY_CATALOG_INTEGRATION
SYSTEM$VERIFY_CMK_INFO
SYSTEM$VERIFY_CMK_INFO_POSTGRES
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN
SYSTEM$VERIFY_EXTERNAL_VOLUME
SYSTEM$WHITELISTDeprecated; use SYSTEM$ALLOWLIST instead.
SYSTEM$WAIT_FOR_SERVICES
SYSTEM$WHITELIST_PRIVATELINKDeprecated; use SYSTEM$ALLOWLIST_PRIVATELINK instead.
Query Information
EXPLAIN_GRANTABLE_PRIVILEGES
EXPLAIN_JSON
GET_QUERY_OPERATOR_STATS
GET_PYTHON_PROFILER_OUTPUT (SNOWFLAKE.CORE)
SYSTEM$ESTIMATE_QUERY_ACCELERATION
SYSTEM$EXPLAIN_PLAN_JSON
SYSTEM$EXPLAIN_JSON_TO_TEXT
SYSTEM$GET_RESULTSET_STATUS