Skip to content
/
Get database

Get database

Request

Retrieves a specified database.

Security
ApiKeyAuth
Path
database_namestring(name)required

database name

Example:Alpha
Query
require_permissionsstringtrue
curl -i -X GET \
  'https://api.treasuredata.com/v3/database/show/Alpha?require_permissions=string' \
  -H 'Authorization: TD1 <YOUR_TOKEN_HERE>'

Responses

OK

Bodyapplication/json
countintegerrequired

???

Example:5
created_atstring(DateTimeAsString)\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}\s(([+-]\...required

Datetime in custom format (2020-12-31 11:22:33 -0500 or 2020-12-31 11:22:33 UTC for UTC)

Example:"2020-12-31 11:22:33 UTC"
delete_protectedbooleanrequired

wheter the database is delete protected

Example:true
datatankboolean
idstring(DatabaseIdAsString)
Example:"7"
namestringrequired

database name

Example:"Alpha"
organizationstring or nullrequired

the organization

Example:"Treasure Data"
permissionstring or nullrequired

permissions

database_permissionsobject

permissions

updated_atstring(DateTimeAsString)\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}\s(([+-]\...required

Datetime in custom format (2020-12-31 11:22:33 -0500 or 2020-12-31 11:22:33 UTC for UTC)

Example:"2020-12-31 11:22:33 UTC"
Response
{
  "count": 5,
  "created_at": "2020-12-31 11:22:33 UTC",
  "delete_protected": true,
  "datatank": true,
  "id": "7",
  "name": "Alpha",
  "organization": "Treasure Data",
  "permission": "string",
  "database_permissions": {
    "edit": true,
    "delete": true,
    "query": true,
    "import": true,
    "download": true
  },
  "updated_at": "2020-12-31 11:22:33 UTC"
}