RECIPIENTS

  • Article

Applies to: check marked yes Databricks SQL check marked yes 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