Greenplum/Postgres DB: databases API

Get a specific database

GET /api/databases/:id

Parameters

Name Description
id The id of a database

Request

Headers

Host: example.org
Cookie: _session_id=QnExazBYVWlyTnlST3JGU0kxYW5xV0lWSytmRzJsT1JFa1Ntbk0vK2UxVXJpc29ERG1nTUlIa0NKbmgvYUVndWRUT21hYXJzWVBxa0Z0NWNxK3Q5VlZvREJSS0k5c0FPWDZDMUhRUmtQZVlWeVJERkVtWk1yY0xPdXplZllCenJyL2dtUUVqSnpkb1FJUnVYTDIzSmxTSFBrL3hEQzNkNTJlRnhoakFUd1BzV2lrbGcyVVhNVXRKK2FselBOL21QdWJtakFxWWRRYUFUZWF1MGNaTmFRS1lzRmh5OEMxQU1ka2l5VkZXWU1Qc1VodDJRbjV1bEJOQmlqNFBzYS9Fbnh5dE4ya2dNY0ZwOFpxZG1UeDB3LzlQaWlKRmNlS0RLZDFTeGNQZFRCWm1XWTNCZEs1QzBudWFuUjl5TFlXeFB3SEY2Qll6ZTl0TEx4UEFzTnJlaGM3TEtDbUF4Z3JLbFczN1ZhMkhQb2V1NzBneXZYM0JsVXZXeWV1V0NWV2F6WkR6K0RNWWdiNjZBczdtd2Y0SnkyYjVyaGkyUGN3MnU0VDE3TjlXZmFPST0tLXFPazdYQ3RIQUFqbnJ5R2pXMzFzbVE9PQ%3D%3D--3f61594cfc718203aab5e9d80b5684a33d0579f0

Route

GET /api/databases/1000001

Response

Headers

X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff
Content-Type: application/json; charset=utf-8
ETag: W/"6fea68bdc653a5cca0d827beb7871bfd"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=MEdmSlUyRUlIK3dLV05IeWJ4cFovMGNoajVEcjBBRjlKd1hObWJReDNHSURkMkVPbVBiRGR0V0libTZXcUZYWWU4UnVRSi9iS0EzdmRCUHRSbDlBOGtzanBDc1NmUC93ODBtdlRDeXh2cGRoY0ZuQzFLOENZTFN5bktEWGNnMVpOQ0N3MDlNb1VSQkFtZ24wVlBNRDd6M0VyWW91NnhJMnNJejVVdXQvaGcwVGw5ZUxXRTR1ak5FM2tGMmFJWVZaeDRZeGVGSkt6L0JPWTVHR3M4a245a2h6YWpRbWFhSzJ3bXFMSGVleVJYNjg4VGZ2cUN4RGwzdzdPcDZ6MEZZV0Q5Rk9RN0pzY1J4SUVtamExMnBUL2xKYnhzeC9scGcrb3dUK1p1Sm0zVlBPVW9laG9jeE9OQkJrN3ZVSllKcUVXSGlwMnJhSGtZeWVQT0U3UzByQVpxeXg4NkVpczBjTG5HeUN3RkpJY002bDNYWVhFcFRySFgwK0tKWVBETkVzVE8vMTlRWHIxdVJGblVSZW44YVRlSDZ4Ty9MTzFTL2EvNTV2TCsydndEeUVYMXJMMllHQ2VXbFgzUElkTStlLy0tZlBaWW81WnhsNFFnVGtTTkkrVGM4Zz09--92074ef6364d41c2ef617df5b4f1870d99f05086; path=/; HttpOnly
X-Request-Id: 7e7d0872-20d7-46bc-971a-8b67923f9cea
X-Runtime: 0.034382
Content-Length: 1277

Status

200 OK

Body

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
 
{
  "response": {
    "id": 1000001,
    "name": "default",
    "data_source": {
      "id": 1000002,
      "name": "Owners",
      "entity_type": "gpdb_data_source",
      "is_deleted": false,
      "shared": false,
      "owner_id": 1000006,
      "version": "9.1.2 - FactoryVersion",
      "is_hawq": null,
      "state": "online",
      "public": false,
      "host": "data_source.emc.com",
      "port": 5000,
      "ssl": false,
      "online": true,
      "db_name": "postgres",
      "description": null,
      "db_username": "username",
      "owner": {
        "id": 1000006,
        "username": "owner",
        "first_name": "searchquery",
        "last_name": "User_1",
        "image": {
          "original": "/paperclip/users/images/001/000/006/original/User.png?1554329366",
          "icon": "/paperclip/users/images/001/000/006/icon/User.png?1554329366",
          "entity_type": "image",
          "complete_json": true
        },
        "is_deleted": null,
        "auth_method": "internal",
        "ldap_group_id": null,
        "user_type": "analytics_developer",
        "entity_type": "user",
        "using_default_image": false,
        "active_license": true,
        "is_siteadmin": false,
        "roles": [
          "data_admin"
        ],
        "email": "chorususer282295@alpinenow.com",
        "title": "Chief Data Scientist",
        "dept": "Corporation Corp., Inc.",
        "notes": "One of our top performers",
        "admin": false,
        "subscribed_to_emails": true,
        "tags": [],
        "deactivated_at": null,
        "complete_json": true
      },
      "tags": [],
      "schema_blacklist": [],
      "data_source_provider": "Greenplum Database",
      "complete_json": true
    },
    "entity_type": "gpdb_database",
    "complete_json": true
  }
}