Categories:

System functions (System Information)

SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO

返回您预置的所有专用连接端点的状态。端点可以是服务端点或资源端点，具体取决于托管 Snowflake 账户的云平台。

语法

SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO()

返回

返回具有以下字段的 JSON 对象：

AWS：

provider_service_name

服务或资源的名称。

snowflake_endpoint_name

The VPC endpoint ID in your Snowflake account. This field contains a temporary name while the endpoint is being created. After the endpoint is created, and endpoint_state changes to CREATED, then this name changes.

endpoint_state

Snowflake 中的端点状态。此字段可以包含以下状态之一：

  • PENDING_CREATION: The endpoint is still being created.
  • CREATED: Indicates that Snowflake received a response from the cloud provider that the endpoint was successfully created and is ready to use.
  • FAILED: The endpoint is in an unexpected state on the cloud provider, and cannot be used.
  • PENDING_DELETION: The endpoint is on the deletion queue, but can be restored.
  • DELETING: The endpoint is being deleted on the cloud provider and cannot be restored.
host

用于连接到服务的主机名。

status

AWS 上的端点配置状态。此字段可以包含以下状态之一：

  • Pending: The endpoint is still being created.
  • Available: The endpoint is created and ready to use.

Azure：

provider_resource_id

端点所连接资源的 Azure 资源 ID。

subresource

端点所连接的 Azure 资源的子资源。

snowflake_resource_id

连接到 Azure 资源的专用端点的 Azure 资源 ID。

host

用于连接资源的主机名。

endpoint_state

Snowflake 中的端点状态。此字段可以包含以下状态之一：

  • PENDING_CREATION: The endpoint is still being created.
  • CREATED: Indicates that Snowflake received a response from the cloud provider that the endpoint was successfully created and is ready to use.
  • FAILED: The endpoint is in an unexpected state on the cloud provider, and cannot be used.
  • PENDING_DELETION: The endpoint is on the deletion queue, but can be restored.
  • DELETING: The endpoint is being deleted on the cloud provider and cannot be restored.
status

The endpoint provisioning status on Microsoft Azure. Use this field to determine if Microsoft Azure has approved the private endpoint connection to the resource. This field can contain one of the following statuses:

  • APPROVED
  • PENDING
  • DISCONNECTED
  • REJECTED

Google Cloud：

provider_resource_id

专用连接端点连接到的资源 ID（服务附件 ID）。

snowflake_resource_id

专用连接端点的标识符。

host

访问使用此端点的提供商服务或资源时使用的主机名。

endpoint_state

Snowflake 侧端点状态。

status

The connection status on Google Cloud. NO CONNECTION might appear shortly after creating the private connectivity endpoint, because the cloud provider takes time to complete the connection setup. This field can contain one of the following statuses:

  • ACCEPTED
  • NO CONNECTION
  • REJECTED

使用说明

  • This function can take approximately five minutes to run because it depends on the process to retrieve the private connectivity endpoints in the cloud platform that are outside of Snowflake.

示例

AWS：

执行以下 SQL 语句，列出具有 Amazon S3 外部访问权限的所有 PrivateLink 端点：

SELECT SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO();

Azure：

对于 Microsoft Azure 上的 Snowflake 账户，请列出已配置的专用连接端点以及每个端点关联的服务名称：

SELECT SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO();

Google Cloud

For your Snowflake account on Google Cloud, list the private connectivity endpoints that you provisioned and the service names that each endpoint is associated with:

SELECT SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO();