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

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS¶

Revokes the authorization for Snowflake to access the private endpoint for 내부 스테이지용 Azure Private Endpoint and 내부 스테이지용 Google Private Service Connect 엔드포인트 for the current account.

참고 항목:: SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS , Snowflake 내부 스테이지에 액세스하기 위한 비공개 엔드포인트 취소

구문¶

Azure

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS( '<private_endpoint_resource_id>' )

Copy

Google Cloud

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS( '<google_cloud_vpc_network_name>' )

Copy

인자¶

'private_endpoint_resource_id'

The unique identifier for the Azure Private Endpoint.

'google_cloud_vpc_network_name'

Google Cloud VPC 네트워크의 정규화된 경로 값입니다.

This value is the Google Cloud VPC network path that Snowflake uses to limit access to your internal stage through the cloud provider’s internal network and avoid using the public internet.

For instructions on how to obtain these values on Azure, see Snowflake 내부 스테이지에 액세스하기 위한 Private Endpoint 구성하기; for Google Cloud, see Snowflake 내부 스테이지에 액세스하기 위한 비공개 엔드포인트 구성하기.

사용법 노트¶

Only account administrators—that is, users with the ACCOUNTADMIN role—can call this function.
This function is not supported for Snowflake accounts on Amazon Web Services (AWS).

예¶

Revoke Snowflake to access the Private Endpoint on Azure:

USE ROLE ACCOUNTADMIN;

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

Copy

Revoke Snowflake to access the private endpoint on Google Cloud:

USE ROLE ACCOUNTADMIN;

SELECT SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS('projects/vpc_network_name/global/networks/network_name');

Copy