> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/information-schema/network_policies",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Use this reference to learn about the metadata available about network policies using the information schema.

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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
  *
FROM
  information_schema.network_policies;
```

Read more about network policies [here](/guides/security/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. |