NETWORK_POLICIES view¶

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

Columns¶

Column	Data Type	Description
`id`	NUMBER	Internal system-generated identifier for network policy.
`name`	VARCHAR	Network policy name
`owner`	VARCHAR	Name of role that owns the network policy.
`owner_role_type`	VARCHAR	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.
`comment`	VARCHAR	Comment for the network policy (if any).
`created`	TIMESTAMP_LTZ	Date and time that the network policy was created.
`last_altered`	TIMESTAMP_LTZ	Date and time that the network policy was last altered.
`deleted`	TIMESTAMP_LTZ	Date and time the network policy was dropped.
`allowed_ip_list`	VARCHAR	List of allowed IPv4 addresses and CIDR block ranges in the corresponding network policy.
`blocked_ip_list`	VARCHAR	List of blocked IPv4 addresses and CIDR block ranges in the corresponding network policy.

The view only displays objects for which the current role for the session has been granted access privileges.