Categories:: System functions (System Control)

SYSTEM$REVOKE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS¶

Revokes the authorization for Snowflake to access the private endpoint for Azure private endpoints for Snowflake-managed storage volumes for the current account.

See also:: SYSTEM$AUTHORIZE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS, Revoking private endpoints to access Snowflake-managed storage volumes

Syntax¶

SYSTEM$REVOKE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS( '<private_endpoint_resource_id>' )

Arguments¶

'private_endpoint_resource_id'

The unique identifier for the Azure Private Endpoint.

For instructions on how to obtain this value, see Configuring private endpoints to access Snowflake-managed storage volumes.

Usage notes¶

Only account administrators (that is, users with the ACCOUNTADMIN role) can call this function.
This function is supported for Snowflake accounts on Microsoft Azure only.

Examples¶

Revoke access to an Azure private endpoint for a Snowflake-managed storage volume:

USE ROLE ACCOUNTADMIN;

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