Categories:

System functions (System Control)

SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS

Allows traffic from public IP addresses to access the Snowflake-managed storage volume of the current Snowflake account on Microsoft Azure.

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

Syntax

SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS()

Arguments

None.

Returns

This function returns the following status messages:

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.

Usage notes

  • Only account administrators (that is, 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.

Examples

Allow public IP addresses to access the Azure Snowflake-managed storage volume.

USE ROLE ACCOUNTADMIN;

SELECT SYSTEM$UNBLOCK_SNOWFLAKE_MANAGED_STORAGE_VOLUME_PUBLIC_ACCESS();