Schema:

ACCOUNT_USAGE

NETWORK_POLICIES view

This Account Usage view returns one row for each network policy in your account.

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 120 minutes (2 hours).
  • The view only displays objects for which the current role for the session has been granted access privileges.