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.
Read more about network policies here.
Each row has the following columns with information about a network policy.
|The name of the network policy.
|List of allowed ips
|List of blocked ips
|Specifies if the network policy is active at the organization level .
|The description of the network policy.
|Time the service account was created.
|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.
|Time the service account was last altered.
|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.