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 trust policies to allow Snowflake to connect to any of the following while denying requests that originate from outside the virtual network:

This security restriction can limit traffic to your cloud storage or proxy service 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();
Back to top