SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS¶

Checks to see whether public IP addresses are allowed to access the internal stage of the current Snowflake account on Microsoft Azure.

See also:: SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS , SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS

Syntax¶

SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS()

None.

This function returns the following status messages:


Status Message	Description
Public Access to internal stages is blocked	Indicates that the Azure settings that control access to the internal stage are currently blocking all public IP addresses.
Public Access to internal stages is unblocked	Indicates that at least some public IP addresses can access the internal stage.

Only account administrators (i.e. users with the ACCOUNTADMIN role) can execute this function.
This function can take a few minutes to finish executing.
This function can be used with Snowflake accounts on Azure only. AWS and Google Cloud are not supported.

USE ROLE accountadmin;

SELECT SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS();
Public Access to internal stages is blocked