Schema:

ACCOUNT_USAGE

NETWORK_RULES view

This Account Usage view returns one row for each network rule in your account.

Columns

Column

Data Type

Description

id

NUMBER

Internal system-generated identifier for network rule.

name

VARCHAR

Network rule name

schema_id

NUMBER

Internal system-generated identifier for the schema that contains the network rule.

schema_name

VARCHAR

Name of the schema that contains the network rule.

database_id

NUMBER

Internal system-generated identifier for the database that contains the network rule.

database_name

VARCHAR

Name of the database that contains the network rule.

owner

VARCHAR

Name of role that owns the network rule.

owner_role_type

VARCHAR

The type of role that owns the object, either ROLE or DATABASE_ROLE. . If a Snowflake Native App owns the object, the value is APPLICATION. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

comment

VARCHAR

Comment for the network rule (if any).

created

TIMESTAMP_LTZ

Date and time that the network rule was created.

last_altered

TIMESTAMP_LTZ

Date and time that the network rule was last altered.

deleted

TIMESTAMP_LTZ

Date and time the network rule was dropped.

Usage notes

  • Latency for the view may be up to 120 minutes (2 hours).

  • The view only displays objects for which the current role for the session has been granted access privileges.