- Categories:
System functions (System Control)
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS¶
Revokes the authorization for Snowflake to access the Microsoft Azure Private Endpoint for Azure private endpoints for internal stages for the current account.
- See also:
SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS , Revoking private endpoints to access Snowflake internal stages
Syntax¶
Azure
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS( '<private_endpoint_resource_id>' )
Arguments¶
'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.
For instructions on how to obtain this value, see Configuring private endpoints to access Snowflake internal stages.
Usage notes¶
Only account administrators—that is, users with the ACCOUNTADMIN role—can run this function.
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.
Examples¶
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');