---
title: "List warehouse credentials"
method: GET
path: "/api/v1/user/warehouseCredentials"
tags: ["My Account"]
---

# List warehouse credentials

`GET /api/v1/user/warehouseCredentials`

Get user warehouse credentials

## Response `200`

Ok

- object
  - `results` UserWarehouseCredentials[], required
    - `project` UserWarehouseCredentialsProject, required
      - `type` 'DEFAULT' | 'PREVIEW', required
      - `name` string, required
      - `projectUuid` string, required
    - `credentials` union, required
      - PickCreateRedshiftCredentialsTypeOrUserOrAuthenticationTypeOrAssumeRoleArn — From T, pick a set of properties whose keys are in the union K
        - `type` 'redshift', required
        - `user` string, required
        - `authenticationType` 'password' | 'iam' | 'iam_browser'
        - `assumeRoleArn` string
      - PickCreatePostgresCredentialsOrCreateSnowflakeCredentialsOrCreateTrinoCredentialsOrCreateClickhouseCredentialsTypeOrUser — From T, pick a set of properties whose keys are in the union K
        - `type` union, required
          - 'postgres'
          - 'snowflake'
          - 'trino'
          - 'clickhouse'
        - `user` string, required
      - PickCreateBigqueryCredentialsType — From T, pick a set of properties whose keys are in the union K
        - `type` 'bigquery', required
      - PickCreateDatabricksCredentialsType — From T, pick a set of properties whose keys are in the union K
        - `type` 'databricks', required
      - PickCreateAthenaCredentialsType — From T, pick a set of properties whose keys are in the union K
        - `type` 'athena', required
      - PickCreateDuckdbCredentialsType — From T, pick a set of properties whose keys are in the union K
        - `type` 'duckdb', required
    - `updatedAt` string, date-time, required
    - `createdAt` string, date-time, required
    - `name` string, required
    - `userUuid` string, required
    - `uuid` string, required
  - `status` 'ok', required

## Other responses

- `default` — Error

---

[API](https://skmtc.net/lightdash/apis/lightdash-api.md) · [All operations](https://skmtc.net/lightdash/apis/lightdash-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/lightdash/lightdash-api/versions/40c933755c9a/schema)