类别：: 系统函数（系统控制）

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS¶

Revokes the authorization for Snowflake to access the private endpoint for 适用于内部暂存区的 Azure Private Endpoint and 用于内部暂存区的 Google Private Service Connect 端点 for the current account.

另请参阅：: SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS、 Revoking private endpoints to access Snowflake internal stages

语法¶

Azure

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS( '<private_endpoint_resource_id>' )

Copy

Google Cloud

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS( '<google_cloud_vpc_network_name>' )

Copy

实参¶

'private_endpoint_resource_id'

The unique identifier for the Azure Private Endpoint.

'google_cloud_vpc_network_name'

Google Cloud VPC 网络的完全限定路径值。

This value is the Google Cloud VPC network path that Snowflake uses to limit access to your internal stage through the cloud provider's internal network and avoid using the public internet.

For instructions on how to obtain these values on Azure, see 配置 Azure Private Endpoint 以访问 Snowflake 内部暂存区; for Google Cloud, see 配置专用端点以访问 Snowflake 内部暂存区.

使用说明¶

Only account administrators---that is, users with the ACCOUNTADMIN role---can call this function.
This function is not supported for Snowflake accounts on Amazon Web Services (AWS).

示例¶

Revoke Snowflake to access the Private Endpoint on Azure:

USE ROLE ACCOUNTADMIN;

SELECT SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS('/subscriptions/subId/resourceGroups/rg1/providers/Microsoft.Network/privateEndpoints/pe1');

Copy

Revoke Snowflake to access the private endpoint on Google Cloud:

USE ROLE ACCOUNTADMIN;

SELECT SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS('projects/vpc_network_name/global/networks/network_name');

Copy