> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sequenzy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# List Warehouse Connections

> List connected warehouses

Returns every warehouse connection with its status, last test and number of syncs. Credentials are never returned. Requires `warehouse:read`; marketers cannot use warehouse routes.

```bash theme={null}
curl "https://api.sequenzy.com/api/v1/warehouse-connections" \
  -H "Authorization: Bearer YOUR_API_KEY"
```

## Response fields

<ResponseField name="connections" type="object[]">
  <Expandable title="connection">
    <ResponseField name="id" type="string" />

    <ResponseField name="name" type="string" />

    <ResponseField name="provider" type="string">
      `snowflake`, `bigquery`, `redshift` or `postgres`.
    </ResponseField>

    <ResponseField name="config" type="object">
      Non-secret settings. BigQuery connections also show `serviceAccountEmail`.
    </ResponseField>

    <ResponseField name="status" type="string">
      `connected`, or `error` when the last test failed.
    </ResponseField>

    <ResponseField name="lastTestedAt" type="string | null" />

    <ResponseField name="lastError" type="string | null">
      Reason from the warehouse for the last failed test.
    </ResponseField>

    <ResponseField name="syncCount" type="integer" />
  </Expandable>
</ResponseField>

<ResponseExample>
  ```json 200 theme={null}
  {
    "success": true,
    "connections": [
      {
        "id": "wconn_abc123",
        "name": "Snowflake prod",
        "provider": "snowflake",
        "config": {
          "account": "myorg-myaccount",
          "username": "SEQUENZY_READER",
          "warehouse": "ANALYTICS_WH",
          "database": "PROD",
          "schema": "PUBLIC",
          "role": "SEQUENZY_READ"
        },
        "status": "connected",
        "lastTestedAt": "2026-09-30T12:00:00.000Z",
        "lastError": null,
        "syncCount": 1,
        "createdAt": "2026-09-30T12:00:00.000Z",
        "updatedAt": "2026-09-30T12:00:00.000Z"
      }
    ]
  }
  ```

  ```json 403 theme={null}
  {
    "success": false,
    "error": "API key is missing required scope: warehouse:read"
  }
  ```
</ResponseExample>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.