Information schema for network_policies

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 Name	Data Type	Description
network_policy_name	TEXT	The name of the network policy.
allowed_ips	ARRAY(TEXT)	List of allowed ips
blocked_ips	ARRAY(TEXT)	List of blocked ips
is_organizational	BOOLEAN	Specifies if the network policy is active at the organization level .
network_policy_description	TEXT	The description of the network policy.
created	TIMESTAMPTZ	Time the service account was created.
network_policy_owner	TEXT	The name of the login that created the network policy. If the network policy was created by a service account, the service account name appears instead.
last_altered	TIMESTAMPTZ	Time the service account was last altered.
last_altered_by	TEXT	The 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.