Categories:: System functions (System Control)

SYSTEM$AUTHORIZE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS¶

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

See also:: SYSTEM$REVOKE_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PRIVATELINK_ACCESS

Syntax¶

SYSTEM$AUTHORIZE_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¶

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

USE ROLE ACCOUNTADMIN;

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