Categories:: System functions (Information)

SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUS¶

检查是否允许公共 IP 地址访问当前 Snowflake 账户在 Microsoft Azure 上的托管存储卷。

See also:: SYSTEM$BLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS, SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS

语法

SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUS()

实参

无。

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

Status Message	Description
Public Access to Snowflake-managed storage volumes is blocked	Indicates that the Azure settings that control access to the Snowflake-managed storage volume are currently blocking all public IP addresses.
Public Access to Snowflake-managed storage volumes is unblocked	Indicates that at least some public IP addresses can access the Snowflake-managed storage volume.
No interop volumes configured on account	Indicates 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.

示例

USE ROLE ACCOUNTADMIN;

SELECT SYSTEM$SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS_STATUS();
Public Access to Snowflake-managed storage volumes is blocked