- 类别：
系统函数 （系统控制）
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS¶
撤消提供给 Snowflake 的以下授权：访问 Microsoft Azure Private Endpoint，以访问当前账户的 适用于内部暂存区的 Azure Private Endpoint。
- 另请参阅：
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS、 Revoking private endpoints to access Snowflake internal stages
语法¶
Azure
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS( '<private_endpoint_resource_id>' )
实参¶
'private_endpoint_resource_id'The unique identifier for the Azure Private Endpoint.
Snowflake uses this value to access the internal stage through the cloud provider's internal network and avoid using the public internet.
有关如何获取该值的说明，请参阅 配置 Azure Private Endpoint 以访问 Snowflake 内部暂存区。
使用说明¶
只有账户管理员（即具有 ACCOUNTADMIN 角色的用户）可执行此函数。
This function can be used with Snowflake accounts on Azure. This function is not supported for Snowflake accounts on Amazon Web Services and Google Cloud.
示例¶
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');