NETWORK POLICIES and NETWORK RULES views (Account Usage): New columns¶
Attention
This behavior change is in the 2024_06 bundle.
For the current status of the bundle, refer to Bundle History.
When this behavior change bundle is enabled, the SNOWFLAKE.ACCOUNT_USAGE.NETWORK_POLICIES and SNOWFLAKE.ACCOUNT_USAGE.NETWORK_RULES views include the following new columns:
| View name | Column name | Data type | Description |
|---|---|---|---|
| NETWORK_POLICIES | ALLOWED_IP_LIST | VARCHAR | The list of allowed IPv4 addresses and CIDR block ranges in the corresponding network policy. |
| BLOCKED_IP_LIST | VARCHAR | The list of blocked IPv4 addresses and CIDR block ranges in the corresponding network policy. | |
| NETWORK_RULES | MODE | VARCHAR | The mode of the network rule. For supported values, see CREATE NETWORK RULE. |
| TYPE | VARCHAR | The type of network rule. For supported values, see CREATE NETWORK RULE. | |
| VALUE_LIST | VARCHAR | The list of values for the network rule. For supported values, see CREATE NETWORK RULE. |
These columns are added as the last columns, in order, for each view.
Ref: 1661