Schema:

ACCOUNT_USAGE

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.

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.