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;

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.
description	TEXT	The description of the network policy.
created	TIMESTAMPTZ	Time the service account was created.
network_policy_owner	TEXT	The name of the identity to whom this network policy belongs.
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.

Service accounts

Manage organization

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Columns in information_schema.network_policies

​Columns in information_schema.network_policies

Columns in information_schema.network_policies