DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • Bitwise expression
            • Conditional expression
            • Context
            • Conversion
            • Data generation
            • Data metric
            • Date & time
            • Differential privacy
            • Encryption
            • File
            • Geospatial
            • Hash
            • Metadata
            • ML Model Monitors
            • Notification
            • Numeric
            • Regular expressions
            • Semi-structured and structured data
            • String & binary
            • System
                1. Control
                2. SYSTEM$ABORT_SESSION
                  • SYSTEM$ABORT_TRANSACTION
                    • SYSTEM$ADD_EVENT
                      • SYSTEM$ADD_REFERENCE
                        • SYSTEM$AUTHORIZE_PRIVATELINK
                          • SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS
                            • SYSTEM$BEGIN_DEBUG_APPLICATION
                              • SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS
                                • SYSTEM$CANCEL_ALL_QUERIES
                                  • SYSTEM$CANCEL_QUERY
                                    • SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS
                                      • SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT
                                        • SYSTEM$CONVERT_PIPES_SQS_TO_SNS
                                          • SYSTEM$CREATE_BILLING_EVENT
                                            • SYSTEM$CREATE_BILLING_EVENTS
                                              • SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT
                                                • SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE
                                                  • SYSTEM$DISABLE_DATABASE_REPLICATION
                                                    • SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT
                                                      • SYSTEM$DISABLE_PREVIEW_ACCESS
                                                        • SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE
                                                          • SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT
                                                            • SYSTEM$ENABLE_PREVIEW_ACCESS
                                                              • SYSTEM$END_DEBUG_APPLICATION
                                                                • SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER
                                                                  • SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT
                                                                    • SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME
                                                                      • SYSTEM$MIGRATE_SAML_IDP_REGISTRATION
                                                                        • SYSTEM$PIPE_FORCE_RESUME
                                                                          • SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL
                                                                            • SYSTEM$PROVISION_PRIVATELINK_ENDPOINT
                                                                              • SYSTEM$REGISTER_PRIVATELINK_ENDPOINT
                                                                                • SYSTEM$REMOVE_ALL_REFERENCES
                                                                                  • SYSTEM$REMOVE_REFERENCE
                                                                                    • SYSTEM$RESTORE_PRIVATELINK_ENDPOINT
                                                                                      • SYSTEM$REVOKE_PRIVATELINK
                                                                                        • SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS
                                                                                          • SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH
                                                                                            • SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG
                                                                                              • SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS
                                                                                                • SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION
                                                                                                  • SYSTEM$SET_REFERENCE
                                                                                                    • SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN
                                                                                                      • SYSTEM$TASK_DEPENDENTS_ENABLE
                                                                                                        • SYSTEM$TRIGGER_LISTING_REFRESH
                                                                                                          • SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS
                                                                                                            • SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT
                                                                                                              • SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION
                                                                                                                • SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS
                                                                                                                  • SYSTEM$WAIT
                                                                                                                    • Information
                                                                                                                    • EXTRACT_SEMANTIC_CATEGORIES
                                                                                                                      • GET_ANACONDA_PACKAGES_REPODATA
                                                                                                                        • SHOW_PYTHON_PACKAGES_DEPENDENCIES
                                                                                                                          • SYSTEM$ALLOWLIST
                                                                                                                            • SYSTEM$ALLOWLIST_PRIVATELINK
                                                                                                                              • SYSTEM$APPLICATION_GET_LOG_LEVEL
                                                                                                                                • SYSTEM$APPLICATION_GET_METRIC_LEVEL
                                                                                                                                  • SYSTEM$APPLICATION_GET_TRACE_LEVEL
                                                                                                                                    • SYSTEM$AUTO_REFRESH_STATUS
                                                                                                                                      • SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS
                                                                                                                                        • SYSTEM$CLIENT_VERSION_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$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS
                                                                                                                                                            • SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS
                                                                                                                                                              • SYSTEM$EXTERNAL_TABLE_PIPE_STATUS
                                                                                                                                                                • SYSTEM$FINISH_OAUTH_FLOW
                                                                                                                                                                  • SYSTEM$GENERATE_SAML_CSR
                                                                                                                                                                    • SYSTEM$GENERATE_SCIM_ACCESS_TOKEN
                                                                                                                                                                      • SYSTEM$GET_AWS_SNS_IAM_POLICY
                                                                                                                                                                        • SYSTEM$GET_ALL_REFERENCES
                                                                                                                                                                          • SYSTEM$GET_CLASSIFICATION_RESULT
                                                                                                                                                                            • SYSTEM$GET_CMK_AKV_CONSENT_URL
                                                                                                                                                                              • SYSTEM$GET_CMK_CONFIG
                                                                                                                                                                                • SYSTEM$GET_CMK_INFO
                                                                                                                                                                                  • SYSTEM$GET_CMK_KMS_KEY_POLICY
                                                                                                                                                                                    • SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE
                                                                                                                                                                                      • SYSTEM$GET_DEBUG_STATUS
                                                                                                                                                                                        • SYSTEM$GET_DIRECTORY_TABLE_STATUS
                                                                                                                                                                                          • SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD
                                                                                                                                                                                            • SYSTEM$GET_HASH_FOR_APP
                                                                                                                                                                                              • SYSTEM$GET_ICEBERG_TABLE_INFORMATION
                                                                                                                                                                                                • 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_REFERENCED_OBJECT_ID_HASH
                                                                                                                                                                                                                  • SYSTEM$GET_SERVICE_DNS_DOMAIN
                                                                                                                                                                                                                    • SYSTEM$GET_SERVICE_LOGS
                                                                                                                                                                                                                      • SYSTEM$GET_SERVICE_STATUS
                                                                                                                                                                                                                        • SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO
                                                                                                                                                                                                                          • SYSTEM$GET_TAG
                                                                                                                                                                                                                            • SYSTEM$GET_TAG_ALLOWED_VALUES
                                                                                                                                                                                                                              • SYSTEM$GET_TAG_ON_CURRENT_COLUMN
                                                                                                                                                                                                                                • SYSTEM$GET_TAG_ON_CURRENT_TABLE
                                                                                                                                                                                                                                  • SYSTEM$GET_TASK_GRAPH_CONFIG
                                                                                                                                                                                                                                    • SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS
                                                                                                                                                                                                                                      • SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT
                                                                                                                                                                                                                                        • SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER
                                                                                                                                                                                                                                          • SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT
                                                                                                                                                                                                                                            • SYSTEM$IS_LISTING_PURCHASED
                                                                                                                                                                                                                                              • SYSTEM$IS_LISTING_TRIAL
                                                                                                                                                                                                                                                • SYSTEM$LAST_CHANGE_COMMIT_TIME
                                                                                                                                                                                                                                                  • SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES
                                                                                                                                                                                                                                                    • SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG
                                                                                                                                                                                                                                                      • SYSTEM$LIST_NAMESPACES_FROM_CATALOG
                                                                                                                                                                                                                                                        • SYSTEM$LOG
                                                                                                                                                                                                                                                          • SYSTEM$PIPE_STATUS
                                                                                                                                                                                                                                                            • SYSTEM$QUERY_REFERENCE
                                                                                                                                                                                                                                                              • SYSTEM$REFERENCE
                                                                                                                                                                                                                                                                • SYSTEM$REGISTER_CMK_INFO
                                                                                                                                                                                                                                                                  • SYSTEM$REGISTRY_LIST_IMAGES
                                                                                                                                                                                                                                                                    • 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_EVENT_SHARING_ACCOUNTS
                                                                                                                                                                                                                                                                                • SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS
                                                                                                                                                                                                                                                                                  • SYSTEM$SHOW_OAUTH_CLIENT_SECRETS
                                                                                                                                                                                                                                                                                    • SYSTEM$START_OAUTH_FLOW
                                                                                                                                                                                                                                                                                      • SYSTEM$STREAM_BACKLOG
                                                                                                                                                                                                                                                                                        • SYSTEM$STREAM_GET_TABLE_TIMESTAMP
                                                                                                                                                                                                                                                                                          • SYSTEM$STREAM_HAS_DATA
                                                                                                                                                                                                                                                                                            • SYSTEM$TASK_RUNTIME_INFO
                                                                                                                                                                                                                                                                                              • SYSTEM$TYPEOF
                                                                                                                                                                                                                                                                                                • SYSTEM$VALIDATE_STORAGE_INTEGRATION
                                                                                                                                                                                                                                                                                                  • SYSTEM$VERIFY_CATALOG_INTEGRATION
                                                                                                                                                                                                                                                                                                    • SYSTEM$VERIFY_CMK_INFO
                                                                                                                                                                                                                                                                                                      • SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN
                                                                                                                                                                                                                                                                                                        • SYSTEM$VERIFY_EXTERNAL_VOLUME
                                                                                                                                                                                                                                                                                                          • SYSTEM$WHITELIST
                                                                                                                                                                                                                                                                                                            • SYSTEM$WAIT_FOR_SERVICES
                                                                                                                                                                                                                                                                                                              • SYSTEM$WHITELIST_PRIVATELINK
                                                                                                                                                                                                                                                                                                                • Query information
                                                                                                                                                                                                                                                                                                                • EXPLAIN_JSON
                                                                                                                                                                                                                                                                                                                  • GET_QUERY_OPERATOR_STATS
                                                                                                                                                                                                                                                                                                                    • GET_PYTHON_PROFILER_OUTPUT
                                                                                                                                                                                                                                                                                                                      • SYSTEM$ESTIMATE_QUERY_ACCELERATION
                                                                                                                                                                                                                                                                                                                        • SYSTEM$EXPLAIN_PLAN_JSON
                                                                                                                                                                                                                                                                                                                          • SYSTEM$EXPLAIN_JSON_TO_TEXT
                                                                                                                                                                                                                                                                                                                            • SYSTEM$GET_RESULTSET_STATUS
                                                                                                                                                                                                                                                                                                                          • Table
                                                                                                                                                                                                                                                                                                                          • Vector
                                                                                                                                                                                                                                                                                                                          • Window
                                                                                                                                                                                                                                                                                                                          • Stored procedures
                                                                                                                                                                                                                                                                                                                      • Class reference
                                                                                                                                                                                                                                                                                                                      • Scripting reference
                                                                                                                                                                                                                                                                                                                      • General reference
                                                                                                                                                                                                                                                                                                                      • API reference
                                                                                                                                                                                                                                                                                                                        ReferenceFunction and stored procedure referenceSystemSYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS

                                                                                                                                                                                                                                                                                                                        SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS¶

                                                                                                                                                                                                                                                                                                                        Snowflake logo in black (no text) Business Critical Feature

                                                                                                                                                                                                                                                                                                                        This feature requires Business Critical (or higher).

                                                                                                                                                                                                                                                                                                                        To inquire about upgrading, please contact Snowflake Support.

                                                                                                                                                                                                                                                                                                                        Returns the registered private endpoints that can route your connection to the Snowflake service.

                                                                                                                                                                                                                                                                                                                        Syntax¶

                                                                                                                                                                                                                                                                                                                        SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS()
                                                                                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                                                        Copy

                                                                                                                                                                                                                                                                                                                        Arguments¶

                                                                                                                                                                                                                                                                                                                        None.

                                                                                                                                                                                                                                                                                                                        Returns¶

                                                                                                                                                                                                                                                                                                                        Returns a list of JSON objects, with each JSON object specifying a registered private connectivity endpoint. A string containing an empty JASON array ("[]") is returned if the account doesn’t have any registered private connectivity endpoints to the Snowflake Service.

                                                                                                                                                                                                                                                                                                                        Where:

                                                                                                                                                                                                                                                                                                                        consumerEndpointId

                                                                                                                                                                                                                                                                                                                        Specifies the AWS account id containing the registered VPC endpoint, or the Azure resource group identifier containing the registered private endpoint.

                                                                                                                                                                                                                                                                                                                        consumerEndpointType

                                                                                                                                                                                                                                                                                                                        Specifies the type of registered private connectivity endpoint.

                                                                                                                                                                                                                                                                                                                        pinnedConsumerEndpointId

                                                                                                                                                                                                                                                                                                                        Specifies the private connectivity endpoint identifier that is registered with Snowflake.

                                                                                                                                                                                                                                                                                                                        providerServiceEndpoint

                                                                                                                                                                                                                                                                                                                        Specifies the identifier for the private connectivity service endpoint in the Snowflake VPC.

                                                                                                                                                                                                                                                                                                                        Usage notes¶

                                                                                                                                                                                                                                                                                                                        Only account administrators (users with the ACCOUNTADMIN role) can call this function.

                                                                                                                                                                                                                                                                                                                        Examples¶

                                                                                                                                                                                                                                                                                                                        Return the registered private connectivity endpoints that route your connection to the Snowflake service:

                                                                                                                                                                                                                                                                                                                        AWS:

                                                                                                                                                                                                                                                                                                                         use role accountadmin;
                                                                                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                                                        SELECT SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS();
                                                                                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                                                        Copy
                                                                                                                                                                                                                                                                                                                        [
                                                                                                                                                                                                                                                                                                                          {
                                                                                                                                                                                                                                                                                                                            "consumerEndpointId": "148896251...",
                                                                                                                                                                                                                                                                                                                            "consumerEndpointType": "Aws Id",
                                                                                                                                                                                                                                                                                                                            "pinnedConsumerEndpointId": "vpce-0be92fc5953c0...",
                                                                                                                                                                                                                                                                                                                            "providerServiceEndpoint": "vpce-svc-0dcda6d2e9d14..."
                                                                                                                                                                                                                                                                                                                          }
                                                                                                                                                                                                                                                                                                                        ]
                                                                                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                                                        Copy

                                                                                                                                                                                                                                                                                                                        Azure:

                                                                                                                                                                                                                                                                                                                         use role accountadmin;
                                                                                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                                                        SELECT SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS();
                                                                                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                                                        Copy
                                                                                                                                                                                                                                                                                                                        [
                                                                                                                                                                                                                                                                                                                          {
                                                                                                                                                                                                                                                                                                                            "consumerEndpointId": "/subscriptions/a92a429f-83ba-4249.../..../snowflake-private-link",
                                                                                                                                                                                                                                                                                                                            "consumerEndpointType": "Azure Endpoint Connection Id",
                                                                                                                                                                                                                                                                                                                            "pinnedConsumerEndpointId": "184549...",
                                                                                                                                                                                                                                                                                                                            "providerServiceEndpoint": "sf-pvlinksvc-azcanadacentral.70f..."
                                                                                                                                                                                                                                                                                                                          }
                                                                                                                                                                                                                                                                                                                        ]
                                                                                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                                                        Copy

                                                                                                                                                                                                                                                                                                                        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 Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                                                                                                                                                                                                                                                                                                        1. Syntax
                                                                                                                                                                                                                                                                                                                        2. Arguments
                                                                                                                                                                                                                                                                                                                        3. Returns
                                                                                                                                                                                                                                                                                                                        4. Usage notes
                                                                                                                                                                                                                                                                                                                        5. Examples
                                                                                                                                                                                                                                                                                                                        Language: English
                                                                                                                                                                                                                                                                                                                        • English
                                                                                                                                                                                                                                                                                                                        • Français
                                                                                                                                                                                                                                                                                                                        • Deutsch
                                                                                                                                                                                                                                                                                                                        • 日本語
                                                                                                                                                                                                                                                                                                                        • 한국어
                                                                                                                                                                                                                                                                                                                        • Português