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. |