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. |
Constraints
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 |
Examples
> SELECT recipient_name, activation_url
FROM information_schema.recipient_tokens