Schema:

ORGANIZATION_USAGE

NETWORK_POLICIES view

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

This Organization Usage view returns one row for each network policy in an account.

Columns

Organization-level columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization.
ACCOUNT_LOCATORVARCHARSystem-generated identifier for the account.
ACCOUNT_NAMEVARCHARUser-defined identifier for the account.

Additional columns

ColumnData TypeDescription
IDNUMBERInternal system-generated identifier for network policy.
NAMEVARCHARNetwork policy name.
OWNERVARCHARName of role that owns the network policy.
OWNER_ROLE_TYPEVARCHAR

The type of role that owns the object, for example ROLE.
If a Snowflake Native App owns the object, the value is APPLICATION.
Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

COMMENTVARCHARComment for the network policy (if any).
CREATEDTIMESTAMP_LTZDate and time that the network policy was created.
LAST_ALTEREDTIMESTAMP_LTZDate and time that the network policy was last altered.
DELETEDTIMESTAMP_LTZDate and time that the network policy was dropped.
ALLOWED_IP_LISTVARCHAR

List of allowed IPv4 addresses and CIDR block ranges in the corresponding network policy.

BLOCKED_IP_LISTVARCHAR

List of blocked IPv4 addresses and CIDR block ranges in the corresponding network policy.

Usage notes

  • Latency for the view may be up to 24 hours.
  • The view only displays objects for which the current role for the session has been granted access privileges.