Categories:: System functions (System Control)

SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS¶

Authorizes Snowflake to access the private endpoint for Azure private endpoints for internal stages

See also:: SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS

Syntax¶

Azure

SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS( '<private_endpoint_resource_id>' )

Copy

Arguments¶

'private_endpoint_resource_id': The unique identifier for the Azure Private Endpoint.

Usage notes¶

Only account administrators (that is, users with the ACCOUNTADMIN role) can execute this function.
This function can be used with Snowflake accounts on Azure. This function is not supported for Snowflake accounts on Amazon Web Services (AWS) and Google Cloud.

Examples¶

Azure

Authorize Snowflake to access an Azure private endpoint:

USE ROLE ACCOUNTADMIN;

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

Copy