---
title: "Get warehouse connection"
method: GET
path: "/warehouse-connections/{id}"
tags: ["Warehouse Sync"]
---

# Get warehouse connection

`GET /warehouse-connections/{id}`

## Request

- Base URL: `https://api.sequenzy.com/api/v1`
- URL: `https://api.sequenzy.com/api/v1/warehouse-connections/{id}`
- Auth: HTTP bearer

Returns one connection.

## Path parameters

- `id` string, required

## Response `200`

Connection returned

- object
  - `success` boolean
  - `connection` WarehouseConnection
    - `id` string
    - `name` string
    - `provider` 'snowflake' | 'bigquery' | 'redshift' | 'postgres'
    - `config` object: Non-secret settings. BigQuery also includes serviceAccountEmail.
    - `status` 'connected' | 'error'
    - `lastTestedAt` string, date-time, nullable
    - `lastError` string, nullable
    - `syncCount` integer
    - `createdAt` string, date-time
    - `updatedAt` string, date-time

## Other responses

- `401`: Unauthorized
- `403`: Missing scope, or the member role cannot manage workspace settings
- `404`: Not found

## Changes

- **2026-10-16** `db3873ca3d4d`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/sequenzy/apis/sequenzy-api/changes/warehouse-connections/:id/get.md)

---

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