カテゴリ：: システム関数（システム制御）

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS¶

Revokes the authorization for Snowflake to access the private endpoint for 内部ステージ用のAzureプライベートエンドポイント and Google Private Service Connect endpoints for internal stages 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'

The fully qualified path value for the Google Cloud VPC Network.

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内部ステージにアクセスするためのプライベートエンドポイントの構成; for Google Cloud, see Configure private endpoints to access Snowflake internal stages.

使用上の注意¶

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