Categories:

System functions (System Control)

SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS

允许来自公共 IP 地址的流量访问 Microsoft Azure 上当前 Snowflake 账户的 Snowflake 托管的存储卷。

This function reverses the Azure settings on the managed storage volume’s Azure storage account that were made when SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS was executed. For details about these Azure settings, refer to Blocking public access.

See also:

SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS, SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUS

语法

SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS()

实参

无。

返回

该函数返回以下状态消息：

Status MessageDescription
Public Access to Snowflake-managed storage volumes is unblockedIndicates that the function successfully unblocked public access.
Azure Error when attempting to unblock public access to Snowflake-managed storage volumes. Please contact Snowflake support.Indicates that the function was unable to change the Azure settings in order to unblock public access.
No interop volumes configured on accountIndicates that there are no Snowflake-managed storage volumes configured for the account.

使用说明

  • 只有账户管理员（即具有 ACCOUNTADMIN 角色的用户）可执行此函数。
  • 此函数可能需要几分钟才能完成执行。
  • This function can be used with Snowflake accounts on Azure only. AWS and Google Cloud are not supported.

示例

允许公开 IP 地址访问 Azure Snowflake 托管存储卷。

USE ROLE ACCOUNTADMIN;

SELECT SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS();