Categories:

System Functions (System Control)

SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS

Allows traffic from public IP addresses to access the internal stage of the current Snowflake account on Microsoft Azure.

This function reverses the Azure settings on the internal stage’s Azure storage account that were made when SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS was executed. For details about these Azure settings, refer to Unblocking Public Access.

See also:

SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS, SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS

Syntax

SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS()
Copy

Arguments

None.

Returns

This function returns the following status messages:

Status Message

Description

Public Access to internal stages is unblocked

Indicates that the function successfully unblocked public access.

Azure Error when attempting to unblock public access to internal stages. Please contact Snowflake support.

Indicates that the function was unable to change the Azure settings in order to unblock public access.

Usage Notes

  • 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 Platform are not supported.

Examples

Allow public IP addresses to access the Azure internal stage.

USE ROLE accountadmin;

SELECT SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS();
Copy