카테고리:: 시스템 함수 (시스템 제어)

SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS¶

Authorizes Snowflake to access the private endpoint for 내부 스테이지용 Azure Private Endpoint

참고 항목:: SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS

구문¶

Azure

SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS( '<private_endpoint_resource_id>' )

Copy

인자¶

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

사용법 노트¶

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.

예¶

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