- 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¶
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 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 | +-------------------------------+----------+---------+----------------------------+----------------------------+