- Categories:
System functions (System Control)
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT¶
Restores a private connectivity endpoint in the Snowflake VPC or VNet to enable Snowflake to connect to an external service using private connectivity. The endpoint can be a service endpoint or a resource endpoint depending on the cloud platform that hosts your Snowflake account.
You can restore a private endpoint within 7 days of deprovisioning it. After 7 days, the endpoint cannot be restored and you need to recreate the endpoint with the SYSTEM$PROVISION_PRIVATELINK_ENDPOINT system function.
Syntax¶
Azure Private Link service¶
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT( '<provider_resource_id>' )
All other external services¶
SYSTEM$RESTORE_PRIVATELINK_ENDPOINT(
'<provider_resource_id>' ,
'<subresource>'
)
Arguments¶
provider_resource_id
Specifies the fully-qualified identifier for the resource or service in your VPC or VNet.
'subresource'
Specifies the name of the subresource in the
host_name
argument; thehost_name
value is used when provisioning the private endpoint.If you want to use outbound private connectivity with the following services, specify these values:
External network access on Microsoft Azure: If the hostname value is
externalaccessdemo.database.windows.net
, thesubresource
value issqlServer
.External stages on Microsoft Azure: If the hostname value is
storagedemo.blob.core.windows.net
, thesubresource
value isblob
.
For all supported values, see the Sub-resource table.
Returns¶
Returns a status message stating that the endpoint, with its identifier, is restored successfully.
Azure:
Private endpoint with id '/subscriptions/66666666-7777-8888-9999-0000000000/resourcegroups/rg/providers/microsoft.network/privateendpoints/00000000-1111-2222-3333-4444444444' restored successfully.
Usage notes¶
Only account administrators (users with the ACCOUNTADMIN role) can call this function.
An error message occurs if a private connectivity endpoint is not associated with the specified arguments.
Examples¶
Restore a private endpoint to allow Snowflake on Microsoft Azure to connect to the Azure API Management service in your Azure VNet:
SELECT SYSTEM$RESTORE_PRIVATELINK_ENDPOINT(
'/subscriptions/11111111-2222-3333-4444-5555555555/resourceGroups/my_rg/providers/Microsoft.Sql/servers/my_db_server',
'sqlServer'
);
Private endpoint with id ''/subscriptions/66666666-7777-8888-9999-0000000000/resourcegroups/rg/providers/microsoft.network/privateendpoints/00000000-1111-2222-3333-4444444444'' restored successfully.