Categories:

User & Security DDL (Network Policies)

SHOW NETWORK POLICIES

Lists all network policies defined in the system. Only returns results for the SECURITYADMIN or ACCOUNTADMIN role.

See also:

ALTER NETWORK POLICY , CREATE NETWORK POLICY , DESCRIBE NETWORK POLICY , DROP NETWORK POLICY

Syntax

SHOW NETWORK POLICIES

Usage Notes

  • Only the network policy owner (i.e. role with the OWNERSHIP privilege on the network policy) or higher can execute this command.

  • The command does not require a running warehouse to execute.

  • The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.

    To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Snowflake Information Schema.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Examples

List all network policies:

SHOW NETWORK POLICIES;

+-------------------------------+----------+---------+----------------------------+----------------------------+
| created_on                    | name     | comment | entries_in_allowed_ip_list | entries_in_blocked_ip_list |
|-------------------------------+----------+---------+----------------------------+----------------------------|
| 2016-04-29 13:22:34.034 -0700 | Policy1  |         |                          2 |                          1 |
| 2016-04-28 17:31:59.269 -0700 | Policy2  |         |                          1 |                          0 |
+-------------------------------+----------+---------+----------------------------+----------------------------+
⇧
Back to top