Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/functions/system_revoke_stage_privatelink_access below:

Website Navigation

• Reference
• Function and stored procedure reference
• System

SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS | Snowflake Documentation

Revokes the authorization for Snowflake to access the Microsoft Azure Private Endpoint for Azure private endpoints for internal stages for the current account.

See also:

SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS , Revoking Private Endpoints to access Snowflake internal stages

-- Azure
SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS( '<privateEndpointResourceID>' )

Copy

'privateEndpointResourceID'

The unique identifier for the Private Endpoint in Azure.

Snowflake uses this endpoint value to access the internal stage through the Azure internal network to avoid the public Internet.

For instructions on how to obtain this value, see Configuring private endpoints to access Snowflake internal stages.

• Only account administrators—that is, users with the ACCOUNTADMIN role—can run this function.

• This function can be used with Snowflake accounts on Azure. This function is not supported for Snowflake accounts on Amazon Web Services or Google Cloud Platform.

Revoke Snowflake to access the Private Endpoint in Azure:

use role accountadmin;

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

Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4