RECIPIENT_ALLOWED_IP_RANGES
Applies to: 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. |
Constraints
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 |
Examples
> SELECT recipient_name, allowed_ip_range
FROM information_schema.recipient_allowed_ip_ranges
Related
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for