RECIPIENTS

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.RECIPIENTS describes 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 RECIPIENTS relation contains the following columns:

Name	Data type	Nullable	Description
RECIPIENT_NAME	STRING	No	Name of the recipient.
RECIPIENT_ID	STRING	No	A GUID of the recipient.
RECIPIENT_OWNER	STRING	No	Owner of the recipient.
AUTHENTICATION_TYPE	STRING	No	Authentication type used with the recipient.
COMMENT	STRING	Yes	An optional comment that describes the recipient.
CLOUD	STRING	Yes	Cloud vendor of the recipient (Databricks-to-Databricks only).
REGION	STRING	Yes	Region of the recipient (Databricks-to-Databricks only).
DATA_RECIPIENT_GLOBAL_METASTORE_ID	STRING	Yes	Globally unique metastore ID of the recipient (Databricks-to-Databricks only).
CREATED	TIMESTAMP	No	Timestamp when the recipient was created.
CREATED_BY	STRING	No	Principal who created the recipient.
LAST_ALTERED	TIMESTAMP	No	Timestamp when the recipient was last altered in any way.
LAST_ALTERED_BY	STRING	No	Principal who last altered the recipient.

Constraints

The following constraints apply to the RECIPIENTS relation:

Class	Name	Column List	Description
Primary key	RECIPIENTS_PK	RECIPIENT_NAME	Unique identifier for the recipient.
Unique key	RECIPIENTS_ID	RECIPIENT_ID	GUID for the recipient.

Examples

> SELECT recipient_owner
    FROM information_schema.recipients

Related

• DESCRIBE RECIPIENT

• Information schema

• INFORMATION_SCHEMA.RECIPIENT_ALLOWED_IP_RANGES

• INFORMATION_SCHEMA.RECIPIENT_TOKENS

• SHOW RECIPIENTS