System functions | Snowflake Documentation (original) (raw)

Control

SYSTEM$ABORT_SESSION

SYSTEM$ABORT_TRANSACTION

SYSTEM$ADD_EVENT (for Snowflake Scripting)

SYSTEM$ADD_REFERENCE

SYSTEM$AUTHORIZE_PRIVATELINK

SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS

SYSTEM$BEGIN_DEBUG_APPLICATION

SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS

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$DEPROVISION_PRIVATELINK_ENDPOINT

SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE

SYSTEM$DISABLE_DATABASE_REPLICATION

SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT

SYSTEM$DISABLE_PREVIEW_ACCESS

SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE

SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT

SYSTEM$ENABLE_PREVIEW_ACCESS

SYSTEM$FINISH_OAUTH_FLOW

SYSTEM$END_DEBUG_APPLICATION

SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER

SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT

SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME

SYSTEM$MIGRATE_SAML_IDP_REGISTRATION

SYSTEM$PIPE_FORCE_RESUME

SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL

SYSTEM$PROVISION_PRIVATELINK_ENDPOINT

SYSTEM$REGISTER_CMK_INFO

SYSTEM$REGISTER_PRIVATELINK_ENDPOINT

SYSTEM$REMOVE_ALL_REFERENCES

SYSTEM$REMOVE_REFERENCE

SYSTEM$RESTORE_PRIVATELINK_ENDPOINT

SYSTEM$REVOKE_PRIVATELINK

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS

SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH

SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG

SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS

SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION

SYSTEM$SET_REFERENCE

SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN

SYSTEM$START_OAUTH_FLOW

SYSTEM$TASK_DEPENDENTS_ENABLE

SYSTEM$TRIGGER_LISTING_REFRESH

SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS

SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT

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$APPLICATION_GET_LOG_LEVEL

SYSTEM$APPLICATION_GET_METRIC_LEVEL

SYSTEM$APPLICATION_GET_TRACE_LEVEL

SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS

SYSTEM$CLIENT_VERSION_INFO

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_INFORMATION

SYSTEM$CLUSTERING_RATIO

Deprecated; use the other clustering functions instead.

SYSTEM$CURRENT_USER_TASK_NAME

SYSTEM$DATA_METRIC_SCAN

SYSTEM$DATABASE_REFRESH_HISTORY

Deprecated; use DATABASE_REFRESH_HISTORY instead.

SYSTEM$DATABASE_REFRESH_PROGRESS , SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB

Deprecated; use DATABASE_REFRESH_PROGRESS , DATABASE_REFRESH_PROGRESS_BY_JOB instead.

SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS

SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS

SYSTEM$EXTERNAL_TABLE_PIPE_STATUS

SYSTEM$GENERATE_SAML_CSR

SYSTEM$GENERATE_SCIM_ACCESS_TOKEN

SYSTEM$GET_AWS_SNS_IAM_POLICY

SYSTEM$GET_ALL_REFERENCES

SYSTEM$GET_CLASSIFICATION_RESULT

SYSTEM$GET_CMK_AKV_CONSENT_URL

SYSTEM$GET_CMK_CONFIG

SYSTEM$GET_CMK_INFO

SYSTEM$GET_CMK_KMS_KEY_POLICY

SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE

SYSTEM$GET_DEBUG_STATUS

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_LOGIN_FAILURE_DETAILS

SYSTEM$GET_PREDECESSOR_RETURN_VALUE

SYSTEM$GET_PREVIEW_ACCESS_STATUS

SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS

SYSTEM$GET_PRIVATELINK_CONFIG

SYSTEM$GET_PRIVATELINK

SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO

SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS

SYSTEM$GET_REFERENCED_OBJECT_ID_HASH

SYSTEM$GET_SERVICE_DNS_DOMAIN

SYSTEM$GET_SERVICE_LOGS

SYSTEM$GET_SERVICE_STATUS — Deprecated

Deprecated; use the SHOW SERVICE CONTAINERS IN SERVICE command instead.

SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO

SYSTEM$GET_TAG_ALLOWED_VALUES

SYSTEM$GET_TAG_ON_CURRENT_COLUMN

SYSTEM$GET_TAG_ON_CURRENT_TABLE

SYSTEM$GET_TAG

SYSTEM$GET_TASK_GRAPH_CONFIG

SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS

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$LOG, SYSTEM$LOG_ (for Snowflake Scripting)

SYSTEM$PIPE_STATUS

SYSTEM$QUERY_REFERENCE

SYSTEM$REFERENCE

SYSTEM$REGISTRY_LIST_IMAGES

Deprecated; use the SHOW IMAGES IN IMAGE REPOSITORY command instead.

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$STREAM_BACKLOG

This function is a table function.

SYSTEM$STREAM_GET_TABLE_TIMESTAMP

SYSTEM$STREAM_HAS_DATA

SYSTEM$TASK_RUNTIME_INFO

SYSTEM$TYPEOF

SYSTEM$VALIDATE_STORAGE_INTEGRATION

SYSTEM$VERIFY_CATALOG_INTEGRATION

SYSTEM$VERIFY_CMK_INFO

SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN

SYSTEM$VERIFY_EXTERNAL_VOLUME

SYSTEM$WHITELIST

Deprecated; use SYSTEM$ALLOWLIST instead.

SYSTEM$WAIT_FOR_SERVICES

SYSTEM$WHITELIST_PRIVATELINK

Deprecated; use SYSTEM$ALLOWLIST_PRIVATELINK instead.

Query Information

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