---
title: "Controller Handle Introspect Connection"
method: POST
path: "/integrations/introspect/connection"
tags: ["integrations"]
---

# Controller Handle Introspect Connection

`POST /integrations/introspect/connection`

Introspects a connection, returning a list of all tables present in that connection.

## Request body

- IntrospectConnectionPayload
  - `connection` ConnectionPayload, required
    - `_owner` string, required — ID of user that created this entry.
    - `_org` string, required — ID of user's active organization when creating this entry.
    - `validated` boolean — Whether we've tested and validated these credentials actually work. Relevant due to us persisting credentials *before* we attempt imports (rather than how we used to do it, after) to help with bug triage, particularly when errors occur during the initial `/commit/import` call and not during the followup task doing the actual import.
    - `config` object, required — JSON object specifying config on the connection. This is a value whose format WE specify; it needs to have enough information that we can map it to either a Meltano extractor or loader, but is fully distinct from either of those concepts. Avoiding coupling both this and table specifiers to whether they are pulling data in or sending data out is very useful and gives us very powerful generalization capabilities.

## Response `200`

Successful Response

- Table[]
  - `name` string, required — Name of the table.
  - `schema` string, nullable — Schema of the table. Only provided for sources that have some concept of a 'wrapper' schema.
  - `columns` Column[], required — List of columns in the table.
    - `name` string, required — Name of the column.

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.net/akk/apis/fastapi.md) · [All operations](https://skmtc.net/akk/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/akk/fastapi/revisions/6662a407c637/schema)