---
title: "List Data Warehouse instances"
method: GET
path: "/gdc/datawarehouse/instances"
tags: ["datawarehouse"]
---

# List Data Warehouse instances

`GET /gdc/datawarehouse/instances`

## Request

- Base URL: `https://secure.gooddata.com`
- URL: `https://secure.gooddata.com/gdc/datawarehouse/instances`
- Auth: none declared

Lists all non-deleted Data Warehouse instances. Use the `status` parameter to filter for particular Data Warehouse statuses.<br/> **NOTE:** In the response body, the `next` link returns `null` when there is no more pages.

## Query parameters

- `status` string[]
- `offset` string
- `limit` integer

## Response `200`

Get instances the user can see (can be filtered by status parameter)

- Instances
  - `instances` object, required: List of all instances the user can access.
    - `items` InstanceResponse[], required
      - `instance` InstanceCommon, required
        - `title` string, required: The instance title
        - `description` string: The instance description
        - `environment` 'PRODUCTION' | 'DEVELOPMENT' | 'TESTING': Platform enviroment
        - `authorizationToken` string: Token used for instance creation
        - `status` string: Status of the instance
        - `created` string, date-time: Creation time
        - `updated` string, date-time: Last modification time
        - `createdBy` string, uri: URI of the creator's profile
        - `updatedBy` string, uri: URI of the updater's profile
        - `connectionUrl` string, uri: JDBC connection string for the instance
        - `links` object: Links related to this Data Warehouse instance
          - `self` string, uri, required: Self link
          - `parent` string, uri, required: Parent link
          - `users` string, uri, required: Link to instance's users
          - `schemas` string, uri, required: Link to instance's schemas
          - `jdbc` string, uri: Link to instance's JDBC connection info
          - `endpoints` string, uri, required: Link to instance's all available JDBC endpoints
        - `license` string: Data Warehouse license level
    - `links` SelfParentLinks, required: Self and parent links
      - `self` string, uri, required: Self link
      - `parent` string, uri, required: Parent link
    - `paging` Paging, required: Paging structure containing link to the next page.
      - `next` string, uri, nullable: Uri to next page, when such page exists.

---

[API](https://skmtc.dev/gooddata/apis/gooddata-api-documentation.md) - [All operations](https://skmtc.dev/gooddata/apis/gooddata-api-documentation/llms.txt) - [OpenAPI document](https://skmtc.dev/gooddata/apis/gooddata-api-documentation/revisions/e5dc0ee6ab00?raw)