Categories:

System Functions (System Information)

SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO

Returns the IDs of the virtual network in which your Snowflake account is located. Depending on whether your account is hosted on Amazon Web Services (AWS) or Microsoft Azure, the function returns the Amazon Virtual Private Cloud (Amazon VPC) IDs or Azure Virtual Network (VNet) IDs.

A cloud administrator in your company can specify this ID in the trust policies for your cloud storage to allow Snowflake to connect to it while denying requests that originate from outside the virtual network. This security restriction can be used to limit traffic to your cloud storage on the same cloud platform.

For more information, see the following information for your cloud platform:

AWS

Allowing the Virtual Private Cloud IDs

Azure

Allowing the VNet Subnet IDs

Syntax

SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO()

Arguments

None.

Usage Notes

Only returns results for account administrators (users with the ACCOUNTADMIN role).

Examples

Query the IDs of the virtual network in which your Snowflake account is located:

SELECT SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO();