You can use the information_schema.network_policies view to return information about network policies. You can use a SELECT query to return information about each network policy as shown in the example below.

SELECT
  *
FROM
  information_schema.network_policies;

Read more about network policies here.

Columns in information_schema.network_policies

Each row has the following columns with information about a network policy.

Column NameData TypeDescription
network_policy_nameTEXTThe name of the network policy.
allowed_ipsARRAY(TEXT)List of allowed ips
blocked_ipsARRAY(TEXT)List of blocked ips
is_organizationalBOOLEANSpecifies if the network policy is active at the organization level .
descriptionTEXTThe description of the network policy.
createdTIMESTAMPTZTime the service account was created.
network_policy_ownerTEXTThe name of the identity to whom this network policy belongs.
last_alteredTIMESTAMPTZTime the service account was last altered.
last_altered_byTEXTThe name of the login that edited the network policy. If the network policy was edited by a service account, the service account name appears instead.