Categories:

Information Schema , Table Functions

NETWORK_RULE_REFERENCES

Returns a row for each object with which the specified network rule is associated or returns a row for each network rule associated with the specified container.

See also:

NETWORK_RULE_REFERENCES view (Account Usage View)

Syntax

NETWORK_RULE_REFERENCES(
  NETWORK_RULE_NAME => '<string>'
)

NETWORK_RULE_REFERENCES(
  CONTAINER_NAME => '<container_name>' ,
  CONTAINER_TYPE => { 'INTEGRATION' | 'NETWORK_POLICY' }
)
Copy

Arguments

NETWORK_RULE_NAME => 'string'

Specifies the identifier for the network rule.

  • The entire network rule name must be enclosed in single quotes.

  • If the network rule name is case-sensitive or includes any special characters or spaces, double quotes are required to process the case/characters. The double quotes must be enclosed within the single quotes, such as '"name"'.

CONTAINER_NAME => 'container_name'

Specifies the name of the external access integration or network policy to which the network rule is associated.

  • The entire network rule name must be enclosed in single quotes.

  • If the object name is case-sensitive or includes any special characters or spaces, double quotes are required to process the case/characters. The double quotes must be enclosed within the single quote, such as '"<name>"'.

CONTAINER_TYPE => { 'INTEGRATION' | 'NETWORK_POLICY' }

Specifies the object type (domain) to which the network rule is associated.

Output

The function returns the following columns:

Column

Data Type

Description

container_name

VARCHAR

The name of the container to which the network policy is associated.

container_type

VARCHAR

One of the following: NETWORK_POLICY or INTEGRATION.

network_rule_name

VARCHAR

Name of the network rule.

action_type

VARCHAR

One of the following: ALLOW or BLOCK.

database_name

VARCHAR

Name of the database that contains the network rule.

schema_name

VARCHAR

Name of the schema that contains the network rule.

Usage notes

Use one syntax or the other. Do not mix arguments.

Examples

Returns a row for each object to which the specified network rule is associated:

USE ROLE network_admin;
USE DATABASE securitydb;
SELECT *
  FROM TABLE(
    securitydb.INFORMATION_SCHEMA.NETWORK_RULE_REFERENCES(
      NETWORK_RULE_NAME => 'securitydb.myrules.cloud_rule'
    )
  );
Copy

Returns a row for each network rule associated to the specified container:

USE ROLE network_admin;
USE DATABASE securitydb;
SELECT *
  FROM TABLE(
    securitydb.INFORMATION_SCHEMA.NETWORK_RULE_REFERENCES(
      CONTAINER_NAME => 'my_network_policy' ,
      CONTAINER_TYPE => 'NETWORK_POLICY'
    )
  );
Copy