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');