RECIPIENT_ALLOWED_IP_RANGES

Applies to: check marked yes Databricks SQL Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.RECIPIENT_ALLOWED_IP_RANGES lists allowed IP ranges for open recipients.

Information is displayed only for recipients the user has permission to interact with.

This is an extension to the SQL Standard Information Schema.

Definition

The RECIPIENT_ALLOWED_IP_RANGES relation contains the following columns:

Name	Data type	Nullable	Description
`RECIPIENT_NAME`	`STRING`	No	Name of the recipient.
`ALLOWED_IP_RANGE`	`STRING`	No	Allowed IP range in IP address or CIDR format.

The following constraints apply to the RECIPIENT_ALLOWED_IP_RANGES relation:

Class	Name	Column List	Description
Foreign key	`RANGES_RECIPIENTS_FK`	`RECIPIENT_NAME`	References RECIPIENTS

> SELECT recipient_name, allowed_ip_range
    FROM information_schema.recipient_allowed_ip_ranges