Skip to main content

Token

Personal access tokens (PATs) provide an easy way for an individual to connect to Dremio Cloud securely using client tools or JDBC. The PAT gets passed in in place of a password. If the client tool requires a username, enter $token as the username and the generated PAT in the password field.

Token Object 
{
  "label": "PATforAPI",
  "createdAt": 1623837492475,
  "expiresAt": 1624701492475,
  "tid": "6c2cda83-f2be-43ea-bf51-adda9c101023",
  "uid": "f3cf7b44-69c6-4008-b319-b297559c9040"
}

Token Attributes​

label String

A user-defined description of the token.

Example: PAT for this week

createdAt Integer

The time at which the token was created.

Example: 1623837492475

expiresAt Integer

The time when the token expires.

Example: 1624701492475

tid String (UUID)

The generated UUID to identify a token.

Example: 6c2cda83-f2be-43ea-bf51-adda9c101023

uid String

The ID of the user for whom the token is generated.

Example: f3cf7b44-69c6-4008-b319-b297559c9040

Listing All Tokens​

List tokens associated with the specified user.

note

You cannot view tokens for another user. Tokens may only be viewed for the user performing the API call.

Method and URL 
GET /v0/user/{user-id}/token

Parameters​

user-id Path   String

The ID of the user whose tokens you want to retrieve.

Example: f3cf7b44-69c6-4008-b319-b297559c9040

Example Request 
curl -X GET \
'https://api.dremio.cloud/v0/user/f3cf7b44-69c6-4008-b319-b297559c9040/token' \
-H 'Authorization: Bearer <personal access token>' \
-H 'Content-Type: application/json'
Example Response 
{
  "data": [
    {
      "label": "PATforAPI",
      "createdAt": 1623837492475,
      "expiresAt": 1624701492475,
      "tid": "6c2cda83-f2be-43ea-bf51-adda9c101023",
      "uid": "f3cf7b44-69c6-4008-b319-b297559c9040"
    },
    {
      "label": "PAT for today",
      "createdAt": 1623846858124,
      "expiresAt": 1624710858124,
      "tid": "f95ae8f7-5634-49d7-ba38-f77f3ce45341",
      "uid": "f3cf7b44-69c6-4008-b319-b297559c9040"
    },
    {
      "label": "PAT for the account",
      "createdAt": 1623862177513,
      "expiresAt": 1624294177513,
      "tid": "0852f85f-394e-4ad8-9f05-f64955f4df3a",
      "uid": "f3cf7b44-69c6-4008-b319-b297559c9040"
    }
  ]
}

Response Status Codes​

200   OK

400   Bad Request

401   Unauthorized

Creating a Token​

Create a token associated with a specific user.

Method and URL 
POST /v0/user/{user-id}/token

Parameters​

user-id Path   String (UUID)

The ID of the user for whom you want to create a token.

Example: f3cf7b44-69c6-4008-b319-b297559c9040

label Body   String

A user-defined description for your token.

Example: Pat for API

millisecondsToExpire Body   Integer

The lifespan of the token in milliseconds. The maximum expiry time is 15552000000 milliseconds (180 days).

Example: 432000000

Example Request 
curl -X POST 'https://api.dremio.cloud/v0/user/f3cf7b44-69c6-4008-b319-b297559c9040/token' \
-H 'Authorization: Bearer <personal access token>' \
-H 'Content-Type: application/json' \
-d '{"label": "Pat for API", "millisecondsToExpire": 432000000 }'
Example Response 
CFL4XzlOStifBfZJVfTfOrrop6hOJuM4DN6TPtnpwRzWB995+tWQbC/GLn2MCQ==

Response Status Codes​

403   Forbidden

404   Not Found

Deleting a Token​

Delete a specific token for a user.

Method and URL 
DELETE /v0/user/{user-id}/token/{id}

Parameters​

user-id Path   String (UUID)

The ID of the user whose token you want to delete.

Example: f3cf7b44-69c6-4008-b319-b297559c9040

id Path   String

The ID of the token that you want to delete.

Example: 0852f85f-394e-4ad8-9f05-f64955f4df3a

Example Request 
curl -X DELETE \
'https://api.dremio.cloud/v0/user/f3cf7b44-69c6-4008-b319-b297559c9040/token/0852f85f-394e-4ad8-9f05-f64955f4df3a' \
-H 'Authorization: Bearer <personal access token>' \
-H 'Content-Type: application/json'
Example Response 
No response

Response Status Codes​

403   Forbidden

404   Not Found

Deleting All Tokens​

Delete all tokens associated with a user.

Method and URL 
DELETE /v0/user/{user-id}/token

Parameters​

user-id Path   String (UUID)

The ID of the user whose tokens you want to delete.

Example: f3cf7b44-69c6-4008-b319-b297559c9040

Example Request 
curl -X DELETE \
'https://api.dremio.cloud/v0/user/f3cf7b44-69c6-4008-b319-b297559c9040/token' \
-H 'Authorization: Bearer <personal access token>' \
-H 'Content-Type: application/json'
Example Response 
No response

Response Status Codes​

403   Forbidden

404   Not Found