- Categories:
System functions (System Control)
SYSTEM$BLOCK_
阻止所有公共流量访问 Microsoft Azure 上当前 Snowflake 账户的 Snowflake 托管存储卷。
This function uses settings for the managed storage volume’s Azure storage account to block public IP addresses. For details on which Azure settings are affected, refer to Blocking public access.
Important
Confirm that traffic via private connectivity is successfully reaching the managed storage volume before blocking public access. Blocking public access without configuring private connectivity can cause unintended disruptions.
语法
实参
无。
返回
该函数返回以下状态消息：
| Status Message | Description |
|---|---|
| Public Access to Snowflake-managed storage volumes is blocked. | Indicates that the function successfully blocked public access. |
| Network config is not found, Please contact support | Indicates that there is a problem with the system parameters. |
| No interop volumes configured on account | Indicates that there are no Snowflake-managed storage volumes configured for the account. |
| Azure Error when attempting to block 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 block public access. |
使用说明
- 只有账户管理员（即具有 ACCOUNTADMIN 角色的用户）可执行此函数。
- 此函数可能需要几分钟才能完成执行。
- This function can be used with Snowflake accounts on Azure only. AWS and Google Cloud are not supported.
示例
阻止所有试图访问 Azure 账户的 Snowflake 托管存储卷的公共流量。