DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • AI Functions
              1. AI_AGG
                • AI_CLASSIFY
                  • AI_COMPLETE
                  • AI_COUNT_TOKENS
                    • AI_EMBED
                      • AI_EXTRACT
                      • AI_FILTER
                        • AI_MULTI_EMBED
                          • AI_PARSE_DOCUMENT
                            • AI_REDACT
                              • AI_SENTIMENT
                                • AI_SIMILARITY
                                  • AI_SUMMARIZE_AGG
                                    • AI_TRANSCRIBE
                                      • AI_TRANSLATE
                                        • FINETUNE (SNOWFLAKE.CORTEX)
                                        • SENTIMENT (SNOWFLAKE.CORTEX)
                                          • SUMMARIZE (SNOWFLAKE.CORTEX)
                                            • Helper functions
                                              1. AGENT_RUN (SNOWFLAKE.CORTEX)
                                                • DATA_AGENT_RUN (SNOWFLAKE.CORTEX)
                                                  • EXECUTE_AI_EVALUATION
                                                    • GET_AI_EVALUATION_DATA (SNOWFLAKE.LOCAL)
                                                      • GET_AI_OBSERVABILITY_LOGS (SNOWFLAKE.LOCAL)
                                                        • GET_AI_OBSERVABILITY_EVENTS (SNOWFLAKE.LOCAL)
                                                          • GET_AI_RECORD_TRACE (SNOWFLAKE.LOCAL)
                                                            • SEARCH_PREVIEW (SNOWFLAKE.CORTEX)
                                                              • SPLIT_TEXT_MARKDOWN_HEADER (SNOWFLAKE.CORTEX)
                                                                • SPLIT_TEXT_RECURSIVE_CHARACTER (SNOWFLAKE.CORTEX)
                                                              • Bitwise expression
                                                              • Conditional expression
                                                              • Context
                                                              • Conversion
                                                              • Data generation
                                                              • Data metric
                                                              • Date & time
                                                              • Differential privacy
                                                              • Encryption
                                                              • File
                                                              • Geospatial
                                                              • Hash
                                                              • Metadata
                                                              • ML Model Monitors
                                                              • Notification
                                                              • Numeric
                                                              • Organization users and organization user groups
                                                              • Regular expressions
                                                              • Semi-structured and structured data
                                                              • Snowpark Container Services
                                                              • String & binary
                                                              • System
                                                                  1. Control
                                                                  2. SYSTEM$ABORT_SESSION
                                                                    • SYSTEM$ABORT_TRANSACTION
                                                                      • SYSTEM$ACTIVATE_CMK_INFO
                                                                        • SYSTEM$ACTIVATE_CMK_INFO_POSTGRES
                                                                          • SYSTEM$ADD_EVENT
                                                                            • 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_FEATURE_GROUPS
                                                                                                                              • SYSTEM$DISABLE_FEATURE_GROUPS_PREVIEW
                                                                                                                                • SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT
                                                                                                                                  • SYSTEM$DISABLE_PREVIEW_ACCESS
                                                                                                                                    • SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLY
                                                                                                                                      • SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE
                                                                                                                                        • SYSTEM$ENABLE_FEATURE_GROUPS
                                                                                                                                          • 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
                                                                                                                                                        • SYSTEM$ISSUE_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$CLIENT_VERSION_INFO
                                                                                                                                                                                                                                                                                  • SYSTEM$CLIENT_VULNERABILITY_INFO
                                                                                                                                                                                                                                                                                    • SYSTEM$CLUSTERING_DEPTH
                                                                                                                                                                                                                                                                                      • SYSTEM$CLUSTERING_INFORMATION
                                                                                                                                                                                                                                                                                        • SYSTEM$CLUSTERING_RATIO
                                                                                                                                                                                                                                                                                          • SYSTEM$CURRENT_USER_TASK_NAME
                                                                                                                                                                                                                                                                                            • SYSTEM$DATA_METRIC_SCAN
                                                                                                                                                                                                                                                                                              • SYSTEM$DATABASE_REFRESH_HISTORY
                                                                                                                                                                                                                                                                                                • SYSTEM$DATABASE_REFRESH_PROGRESS
                                                                                                                                                                                                                                                                                                  • SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB
                                                                                                                                                                                                                                                                                                    • SYSTEM$DECODE_PAT
                                                                                                                                                                                                                                                                                                      • SYSTEM$DESC_ICEBERG_ACCESS_IDENTITY
                                                                                                                                                                                                                                                                                                        • SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS
                                                                                                                                                                                                                                                                                                          • SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS
                                                                                                                                                                                                                                                                                                            • SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS
                                                                                                                                                                                                                                                                                                              • SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS_PERSIST_RESULT
                                                                                                                                                                                                                                                                                                                • 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_ALERT_CONFIG
                                                                                                                                                                                                                                                                                                                              • 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_APP
                                                                                                                                                                                                                                                                                                                                                                • 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_EXPIRY
                                                                                                                                                                                                                                                                                                                                                                                          • SYSTEM$GET_SERVICE_DNS_DOMAIN
                                                                                                                                                                                                                                                                                                                                                                                            • SYSTEM$GET_SERVICE_LOGS
                                                                                                                                                                                                                                                                                                                                                                                              • SYSTEM$GET_SERVICE_STATUS
                                                                                                                                                                                                                                                                                                                                                                                                • SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGES
                                                                                                                                                                                                                                                                                                                                                                                                  • SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO
                                                                                                                                                                                                                                                                                                                                                                                                    • SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTS
                                                                                                                                                                                                                                                                                                                                                                                                      • SYSTEM$GET_TAG
                                                                                                                                                                                                                                                                                                                                                                                                        • SYSTEM$GET_TAG_ALLOWED_VALUES
                                                                                                                                                                                                                                                                                                                                                                                                          • SYSTEM$GET_TAG_ON_CURRENT_COLUMN
                                                                                                                                                                                                                                                                                                                                                                                                            • SYSTEM$GET_TAG_ON_CURRENT_TABLE
                                                                                                                                                                                                                                                                                                                                                                                                              • SYSTEM$GET_TABLE_ARCHIVE_METADATA
                                                                                                                                                                                                                                                                                                                                                                                                                • 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_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED
                                                                                                                                                                                                                                                                                                                                                                                                                          • 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$PIPE_STATUS
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • SYSTEM$QUERY_REFERENCE
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW
                                                                                                                                                                                                                                                                                                                                                                                                                                                        • SYSTEM$REFERENCE
                                                                                                                                                                                                                                                                                                                                                                                                                                                          • SYSTEM$REGISTRY_LIST_IMAGES
                                                                                                                                                                                                                                                                                                                                                                                                                                                            • SYSTEM$REPORT_HEALTH_STATUS
                                                                                                                                                                                                                                                                                                                                                                                                                                                              • SYSTEM$RESOLVE_PYTHON_PACKAGES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                • SYSTEM$SET_RETURN_VALUE
                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • SYSTEM$SET_SPAN_ATTRIBUTES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • SYSTEM$SHOW_BUDGETS_FOR_RESOURCE
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • SYSTEM$SHOW_BUDGETS_IN_ACCOUNT
                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • SYSTEM$SHOW_BUDGET_SHARED_RESOURCE_CANDIDATES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • SYSTEM$SHOW_DYNAMIC_TABLES_CREATED_FOR_RESHARING
                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • SYSTEM$SHOW_OAUTH_CLIENT_SECRETS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • SYSTEM$STREAM_BACKLOG
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • 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$WHITELIST
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • SYSTEM$WAIT_FOR_SERVICES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • SYSTEM$WHITELIST_PRIVATELINK
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Query information
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • EXPLAIN_GRANTABLE_PRIVILEGES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • EXPLAIN_JSON
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • EXPLAIN_PRIVILEGES
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • GET_QUERY_OPERATOR_STATS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • GET_PYTHON_PROFILER_OUTPUT
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • SYSTEM$CKE_HASH_FUNCTION
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • SYSTEM$ENCODE_CKE_PRIMARY_KEY
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • SYSTEM$ESTIMATE_QUERY_ACCELERATION
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • SYSTEM$EXPLAIN_PLAN_JSON
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • SYSTEM$EXPLAIN_JSON_TO_TEXT
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • SYSTEM$GET_RESULTSET_STATUS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • Snowflake Postgres
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • GENERATE_POSTGRES_ACCESS_TOKEN_FOR_USER
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Table
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Vector
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Window
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Stored procedures
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Class reference
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Scripting reference
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • General reference
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • API reference
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      ReferenceFunction and stored procedure referenceSystemSYSTEM$GET_DEBUG_STATUS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Categories:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      System functions (System Information)

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      SYSTEM$GET_DEBUG_STATUS¶

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Preview Feature — Open

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Available to all accounts.

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Returns the session debug mode status of the current session.

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Syntax¶

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      SYSTEM$GET_DEBUG_STATUS()
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Was this page helpful?

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Visit Snowflake
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Join the conversation
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Develop with Snowflake
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Share your feedback
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Read the latest on our blog
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Get your own certification
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Privacy NoticeSite TermsCookies Settings© 2026 Snowflake, Inc. All Rights Reserved.

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Alternative interfaces

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Snowflake Python APIsSnowflake REST APIsSnowflake CLI
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      1. Syntax
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      1. Session debug mode
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      2. SYSTEM$BEGIN_DEBUG_APPLICATION
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      3. SYSTEM$END_DEBUG_APPLICATION