RECIPIENT_TOKENS

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.RECIPIENT_TOKENS lists tokens 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_TOKENS relation contains the following columns:

Name	Data type	Nullable	Description
`RECIPIENT_NAME`	`STRING`	No	Name of the recipient.
`RECIPIENT_TOKEN_ID`	`STRING`	No	ID of the recipient token.
`ACTIVATION_URL`	`STRING`	Yes	Full activation URL used to retrieve the recipient token. It will be null if the token is already retrieved.
`EXPIRATION_TIME`	`TIMESTAMP`	No	Expiration timestamp of the recipient token.
`CREATED`	`TIMESTAMP`	No	Timestamp when the recipient token was created.
`CREATED_BY`	`STRING`	No	Principal who created the recipient token.
`LAST_ALTERED`	`TIMESTAMP`	No	Timestamp when the recipient token was last altered in any way.
`LAST_ALTERED_BY`	`STRING`	No	Principal who last altered the recipient token.

Name	Data type	Nullable	Description
`RECIPIENT_NAME`	`STRING`	No	Name of the recipient.
`RECIPIENT_TOKEN_ID`	`STRING`	No	ID of the recipient token.
`ACTIVATION_URL`	`STRING`	Yes	Full activation URL used to retrieve the recipient token. It will be null if the token is already retrieved.
`EXPIRATION_TIME`	`TIMESTAMP`	No	Expiration timestamp of the recipient token.
`CREATED`	`TIMESTAMP`	No	Timestamp when the recipient token was created.
`CREATED_BY`	`STRING`	No	Principal who created the recipient token.
`LAST_ALTERED`	`TIMESTAMP`	No	Timestamp when the recipient token was last altered in any way.
`LAST_ALTERED_BY`	`STRING`	No	Principal who last altered the recipient token.

The following constraints apply to the RECIPIENT_TOKENS relation:

Class	Name	Column List	Description
Primary key	`RECIPIENT_TOKENS_PK`	`RECIPIENT_TOKEN_ID`	Unique identifier for the recipient token.
Foreign key	`TOKENS_RECIPIENTS_FK`	`RECIPIENT_NAME`	References RECIPIENTS

SQL
> SELECT recipient_name, activation_url
    FROM information_schema.recipient_tokens