Network rules¶

Supported network identifiers¶

Administrators need to be able to restrict access based on the network identifier associated with the origin or destination of a request. Network rules allow administrators to allow or block the following network identifiers:

Incoming requests:

• IPv4 addresses. Snowflake supports ranges of IP addresses using Classless Inter-Domain Routing (CIDR) notation (https://tools.ietf.org/html/rfc4632). For example, 192.168.1.0/24 represents all IPv4 addresses in the range of 192.168.1.0 to 192.168.1.255.

• VPCE IDs of AWS VPC endpoints (https://docs.aws.amazon.com/vpc/latest/privatelink/concepts.html#concepts-service-consumers) . VPC IDs are not supported.

• LinkIDs of Azure private endpoints (https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-overview). Execute the SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS function to retrieve the LinkID associated with an account.

Outgoing requests:

Domains, including a port range.

The valid port range is 1-65535. If you do not specify a port, it defaults to 443. If an external network location supports dynamic ports, you need to specify all possible ports.

To allow access to all ports, define the port as 0. For example, company.com:0.

Each network rule contains a list of one or more network identifiers of the same type. The network rule’s TYPE property indicates the type of identifiers that are included in the rule. For example, if the TYPE property is IPV4, then the network rule’s value list must contain valid IPv4 addresses or address ranges in CIDR notation.

Incoming vs. outgoing requests¶

The mode of a network rule indicates whether the Snowflake feature that uses the rule restricts incoming or outgoing requests.

Creating a network rule¶

You need the CREATE NETWORK RULE privilege on the schema to create a network rule. By default, only the ACCOUNTADMIN and SECURITYADMIN roles, along with the schema owner, have this privilege.

You can create a network rule using Snowsight or by executing a SQL command:

Snowsight:

1. Sign in to Snowsight.

2. Select Admin » Security.

3. Select the Network Rules tab.

4. Select + Network Rule.

5. Enter the name of the network rule.

6. Select the schema of the network rule. Network rule are schema-level objects.

7. Optionally, add a descriptive comment for the network rule to help organize and maintain network rules in the schema.

8. In the Type drop-down, select the type of identifier being defined in the network rule.

9. In the Mode drop-down, select the mode of the network rule. The INGRESS and INTERNAL STAGE modes indicate the network rule will be used with a network policy to restrict incoming requests and the EGRESS mode indicates the network rule will be used with an external access integration to restrict outgoing requests.

10. Enter a comma-separated list of the identifiers that will be allowed or blocked when the network rule is added to a network policy. The identifiers in this list must all be of the type specified in the Type drop-down.

11. Select Create Network Policy.

SQL:

An administrator can execute the CREATE NETWORK RULE command to create a new network rule, specifying a list of network identifiers along with the type of those identifiers.

For example, to use a custom role to create a network rule that can be used to allow or block traffic from a range of IP addresses:

GRANT USAGE ON DATABASE securitydb TO ROLE network_admin;
GRANT USAGE ON SCHEMA securitydb.myrules TO ROLE network_admin;
GRANT CREATE NETWORK RULE ON SCHEMA securitydb.myrules TO ROLE network_admin;
USE ROLE network_admin;

CREATE NETWORK RULE cloud_network TYPE = IPV4 MODE = INGRESS VALUE_LIST = ('47.88.25.32/27');

Copy

Identifying network rules in your account¶

You can identify the network rules in your account using Snowsight or SQL.

Snowsight:

1. Sign in to Snowsight.

2. Select Admin » Security.

3. Select the Network Rules tab.

SQL:

Call the NETWORK_RULE_REFERENCES Information Schema table function, or query the NETWORK_RULES or NETWORK_RULE_REFERENCES Account Usage view.

Modifying a network rule¶

You can modify the identifiers and comment of an existing network rule, but you cannot modify its type, mode, name, or schema.

To add or remove identifiers and comments from an existing network rule using Snowsight or SQL, do one of the following:

Snowsight:

1. Sign in to Snowsight.

2. Select Admin » Security.

3. Select the Network Rules tab.

4. Find the network rule, select the … button, and then select Edit.

5. Modify the comma-delimited list of identifiers or the comment.

6. Select Update Network Rule.

SQL:

Execute an ALTER NETWORK RULE statement.

Replication of network rules¶

Network rules are schema-level objects and are replicated with the database in which they are contained.

For information about replicating the network policies that use network rules, see Replicating network policies.

Snowflake-managed network rules¶

Snowflake provides the following pre-defined, Snowflake-managed network rules:

SNOWFLAKE.EXTERNAL_ACCESS.PYPI_RULE

An EGRESS network rule used with an external access integration to provide a connection from Snowflake to PyPi. You might want to use the network rule to allow Notebook users on Container Runtime to install pip packages using the pip install command.

To see an example on how to use this network rule, see Accessing PyPi to install packages in Snowpark Container.

Only the ACCOUNTADMIN role has access to this network rule.

Privileges and commands¶