SHOW NETWORK POLICIES¶
Lists all network policies defined in the system.
- 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.
Columns that start with the prefix
is_
return eitherY
(yes) orN
(no).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 | +-------------------------------+----------+---------+----------------------------+----------------------------+