---
title: "List all connection tables"
---

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

# List all connection tables

Path: Arroyo REST API › connection_tables

`GET /v1/connection_tables`

URL: `http://localhost:5115/api/v1/connection_tables`

## Query parameters

- `starting_after` (`get_connection_tables.query.starting_after`; string, optional)
- `limit` (`get_connection_tables.query.limit`; integer, optional)
  - format: `int32` · minimum: `0`

## Code samples

### cURL

```bash
curl --request GET \
  --url http://localhost:5115/api/v1/connection_tables
```

### TypeScript

```typescript
const url = 'http://localhost:5115/api/v1/connection_tables';
const options = {method: 'GET'};

fetch(url, options)
  .then(res => res.json())
  .then(json => console.log(json))
  .catch(err => console.error(err));
```

### Python

```python
import requests

url = "http://localhost:5115/api/v1/connection_tables"

response = requests.get(url)

print(response.text)
```

## Responses

### 200

Got connection table collection

#### Example

```json
{
  "data": [
    {
      "config": null,
      "connection_profile": {
        "config": null,
        "connector": "string",
        "description": "string",
        "id": "string",
        "name": "string"
      },
      "connector": "string",
      "consumers": 0,
      "created_at": 0,
      "id": "string",
      "name": "string",
      "schema": {
        "bad_data": {
          "behavior": "fail"
        },
        "definition": {
          "schema": "string",
          "type": "json_schema"
        },
        "fields": [
          {
            "type": "int32",
            "metadata_key": "string",
            "name": "string",
            "required": true,
            "sql_name": "string"
          }
        ],
        "format": {
          "compression": "uncompressed",
          "confluent_schema_registry": true,
          "debezium": true,
          "decimal_encoding": "number",
          "include_schema": true,
          "schema_id": 0,
          "timestamp_format": "rfc3339",
          "unstructured": true,
          "type": "json"
        },
        "framing": {
          "max_line_length": 0,
          "method": "newline"
        },
        "inferred": true,
        "primary_keys": [
          "string"
        ]
      },
      "table_type": "source"
    }
  ],
  "hasMore": true
}
```

- `data` (`get_connection_tables.response.200.data`; array of object, required)
  - `config` (`get_connection_tables.response.200.data.config`; unknown, required)
  - `connector` (`get_connection_tables.response.200.data.connector`; string, required)
  - `consumers` (`get_connection_tables.response.200.data.consumers`; integer, required)
    - format: `int32` · minimum: `0`
  - `created_at` (`get_connection_tables.response.200.data.created_at`; integer, required)
    - format: `int64` · minimum: `0`
  - `id` (`get_connection_tables.response.200.data.id`; string, required)
  - `name` (`get_connection_tables.response.200.data.name`; string, required)
  - `schema` (`get_connection_tables.response.200.data.schema`; object, required)
    - `bad_data` (`get_connection_tables.response.200.data.schema.bad_data`; one of, optional, nullable)
      - one of the following:
        - `Fail`
          - `behavior` (`get_connection_tables.response.200.data.schema.bad_data.1.behavior`; string, required)
            - one of `"fail"`
        - `Drop`
          - `behavior` (`get_connection_tables.response.200.data.schema.bad_data.2.behavior`; string, required)
            - one of `"drop"`
      - discriminator: `behavior`
    - `definition` (`get_connection_tables.response.200.data.schema.definition`; one of, optional, nullable)
      - every option has:
        - `schema` (`<option>.schema`; string, required)
      - one of the following, each adding:
        - `JsonSchema` (`get_connection_tables.response.200.data.schema.definition.1`)
          - `type` (`get_connection_tables.response.200.data.schema.definition.1.type`; string, required)
            - one of `"json_schema"`
        - `Protobuf` (`get_connection_tables.response.200.data.schema.definition.2`)
          - `type` (`get_connection_tables.response.200.data.schema.definition.2.type`; string, required)
            - one of `"protobuf_schema"`
          - `dependencies` (`get_connection_tables.response.200.data.schema.definition.2.dependencies`; map of string, optional)
        - `Avro` (`get_connection_tables.response.200.data.schema.definition.3`)
          - `type` (`get_connection_tables.response.200.data.schema.definition.3.type`; string, required)
            - one of `"avro_schema"`
      - discriminator: `type`
    - `fields` (`get_connection_tables.response.200.data.schema.fields`; array of SourceField, optional)
      - `name` (`get_connection_tables.response.200.data.schema.fields.name`; string, required)
      - `metadata_key` (`get_connection_tables.response.200.data.schema.fields.metadata_key`; string, optional, nullable)
      - `required` (`get_connection_tables.response.200.data.schema.fields.required`; boolean, optional)
      - `sql_name` (`get_connection_tables.response.200.data.schema.fields.sql_name`; string, optional, nullable)
      - and one of the following:
        - `Int32`
          - `type` (`get_connection_tables.response.200.data.schema.fields.1.type`; string, required)
            - one of `"int32"`
        - `Int64`
          - `type` (`get_connection_tables.response.200.data.schema.fields.2.type`; string, required)
            - one of `"int64"`
        - `UInt32`
          - `type` (`get_connection_tables.response.200.data.schema.fields.3.type`; string, required)
            - one of `"uint32"`
        - `UInt64`
          - `type` (`get_connection_tables.response.200.data.schema.fields.4.type`; string, required)
            - one of `"uint64"`
        - `Float32`
          - `type` (`get_connection_tables.response.200.data.schema.fields.5.type`; string, required)
            - one of `"float32"`
        - `Float64`
          - `type` (`get_connection_tables.response.200.data.schema.fields.6.type`; string, required)
            - one of `"float64"`
        - `Decimal128`
          - `precision` (`get_connection_tables.response.200.data.schema.fields.7.precision`; integer, required)
            - format: `int32` · minimum: `0`
          - `scale` (`get_connection_tables.response.200.data.schema.fields.7.scale`; integer, required)
            - format: `int32`
          - `type` (`get_connection_tables.response.200.data.schema.fields.7.type`; string, required)
            - one of `"decimal128"`
        - `Bool`
          - `type` (`get_connection_tables.response.200.data.schema.fields.8.type`; string, required)
            - one of `"bool"`
        - `String`
          - `type` (`get_connection_tables.response.200.data.schema.fields.9.type`; string, required)
            - one of `"string"`
        - `Bytes`
          - `type` (`get_connection_tables.response.200.data.schema.fields.10.type`; string, required)
            - one of `"bytes"`
        - `Timestamp`
          - `type` (`get_connection_tables.response.200.data.schema.fields.11.type`; string, required)
            - one of `"timestamp"`
          - `unit` (`get_connection_tables.response.200.data.schema.fields.11.unit`; string, optional)
            - one of `"second"`, `"millisecond"`, `"microsecond"`, `"nanosecond"`
        - `Json`
          - `type` (`get_connection_tables.response.200.data.schema.fields.12.type`; string, required)
            - one of `"json"`
        - `Struct`
          - `fields` (`get_connection_tables.response.200.data.schema.fields.13.fields`; array of SourceField, required)
            - `name` (`get_connection_tables.response.200.data.schema.fields.13.fields.name`; string, required)
            - `metadata_key` (`get_connection_tables.response.200.data.schema.fields.13.fields.metadata_key`; string, optional, nullable)
            - `required` (`get_connection_tables.response.200.data.schema.fields.13.fields.required`; boolean, optional)
            - `sql_name` (`get_connection_tables.response.200.data.schema.fields.13.fields.sql_name`; string, optional, nullable)
            - and one of the following:
              - `Int32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.1.type`; string, required)
                  - one of `"int32"`
              - `Int64`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.2.type`; string, required)
                  - one of `"int64"`
              - `UInt32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.3.type`; string, required)
                  - one of `"uint32"`
              - `UInt64`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.4.type`; string, required)
                  - one of `"uint64"`
              - `Float32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.5.type`; string, required)
                  - one of `"float32"`
              - `Float64`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.6.type`; string, required)
                  - one of `"float64"`
              - `Decimal128`
                - `precision` (`get_connection_tables.response.200.data.schema.fields.13.fields.7.precision`; integer, required)
                  - format: `int32` · minimum: `0`
                - `scale` (`get_connection_tables.response.200.data.schema.fields.13.fields.7.scale`; integer, required)
                  - format: `int32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.7.type`; string, required)
                  - one of `"decimal128"`
              - `Bool`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.8.type`; string, required)
                  - one of `"bool"`
              - `String`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.9.type`; string, required)
                  - one of `"string"`
              - `Bytes`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.10.type`; string, required)
                  - one of `"bytes"`
              - `Timestamp`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.11.type`; string, required)
                  - one of `"timestamp"`
                - `unit` (`get_connection_tables.response.200.data.schema.fields.13.fields.11.unit`; string, optional)
                  - one of `"second"`, `"millisecond"`, `"microsecond"`, `"nanosecond"`
              - `Json`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.12.type`; string, required)
                  - one of `"json"`
              - `Struct`
              - `List`
                - `items` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items`; ListFieldItem, required)
                  - `name` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.name`; string, optional)
                  - `required` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.required`; boolean, optional)
                  - `sql_name` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.sql_name`; string, optional, nullable)
                  - and one of the following:
                    - `Int32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.1.type`; string, required)
                        - one of `"int32"`
                    - `Int64`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.2.type`; string, required)
                        - one of `"int64"`
                    - `UInt32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.3.type`; string, required)
                        - one of `"uint32"`
                    - `UInt64`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.4.type`; string, required)
                        - one of `"uint64"`
                    - `Float32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.5.type`; string, required)
                        - one of `"float32"`
                    - `Float64`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.6.type`; string, required)
                        - one of `"float64"`
                    - `Decimal128`
                      - `precision` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.7.precision`; integer, required)
                        - format: `int32` · minimum: `0`
                      - `scale` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.7.scale`; integer, required)
                        - format: `int32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.7.type`; string, required)
                        - one of `"decimal128"`
                    - `Bool`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.8.type`; string, required)
                        - one of `"bool"`
                    - `String`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.9.type`; string, required)
                        - one of `"string"`
                    - `Bytes`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.10.type`; string, required)
                        - one of `"bytes"`
                    - `Timestamp`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.11.type`; string, required)
                        - one of `"timestamp"`
                      - `unit` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.11.unit`; string, optional)
                        - one of `"second"`, `"millisecond"`, `"microsecond"`, `"nanosecond"`
                    - `Json`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.items.12.type`; string, required)
                        - one of `"json"`
                    - `Struct`
                    - `List`
                  - discriminator: `type`
                - `type` (`get_connection_tables.response.200.data.schema.fields.13.fields.14.type`; string, required)
                  - one of `"list"`
            - discriminator: `type`
          - `type` (`get_connection_tables.response.200.data.schema.fields.13.type`; string, required)
            - one of `"struct"`
        - `List`
          - `items` (`get_connection_tables.response.200.data.schema.fields.14.items`; ListFieldItem, required)
            - `name` (`get_connection_tables.response.200.data.schema.fields.14.items.name`; string, optional)
            - `required` (`get_connection_tables.response.200.data.schema.fields.14.items.required`; boolean, optional)
            - `sql_name` (`get_connection_tables.response.200.data.schema.fields.14.items.sql_name`; string, optional, nullable)
            - and one of the following:
              - `Int32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.1.type`; string, required)
                  - one of `"int32"`
              - `Int64`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.2.type`; string, required)
                  - one of `"int64"`
              - `UInt32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.3.type`; string, required)
                  - one of `"uint32"`
              - `UInt64`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.4.type`; string, required)
                  - one of `"uint64"`
              - `Float32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.5.type`; string, required)
                  - one of `"float32"`
              - `Float64`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.6.type`; string, required)
                  - one of `"float64"`
              - `Decimal128`
                - `precision` (`get_connection_tables.response.200.data.schema.fields.14.items.7.precision`; integer, required)
                  - format: `int32` · minimum: `0`
                - `scale` (`get_connection_tables.response.200.data.schema.fields.14.items.7.scale`; integer, required)
                  - format: `int32`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.7.type`; string, required)
                  - one of `"decimal128"`
              - `Bool`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.8.type`; string, required)
                  - one of `"bool"`
              - `String`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.9.type`; string, required)
                  - one of `"string"`
              - `Bytes`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.10.type`; string, required)
                  - one of `"bytes"`
              - `Timestamp`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.11.type`; string, required)
                  - one of `"timestamp"`
                - `unit` (`get_connection_tables.response.200.data.schema.fields.14.items.11.unit`; string, optional)
                  - one of `"second"`, `"millisecond"`, `"microsecond"`, `"nanosecond"`
              - `Json`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.12.type`; string, required)
                  - one of `"json"`
              - `Struct`
                - `fields` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields`; array of SourceField, required)
                  - `name` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.name`; string, required)
                  - `metadata_key` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.metadata_key`; string, optional, nullable)
                  - `required` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.required`; boolean, optional)
                  - `sql_name` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.sql_name`; string, optional, nullable)
                  - and one of the following:
                    - `Int32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.1.type`; string, required)
                        - one of `"int32"`
                    - `Int64`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.2.type`; string, required)
                        - one of `"int64"`
                    - `UInt32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.3.type`; string, required)
                        - one of `"uint32"`
                    - `UInt64`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.4.type`; string, required)
                        - one of `"uint64"`
                    - `Float32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.5.type`; string, required)
                        - one of `"float32"`
                    - `Float64`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.6.type`; string, required)
                        - one of `"float64"`
                    - `Decimal128`
                      - `precision` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.7.precision`; integer, required)
                        - format: `int32` · minimum: `0`
                      - `scale` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.7.scale`; integer, required)
                        - format: `int32`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.7.type`; string, required)
                        - one of `"decimal128"`
                    - `Bool`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.8.type`; string, required)
                        - one of `"bool"`
                    - `String`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.9.type`; string, required)
                        - one of `"string"`
                    - `Bytes`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.10.type`; string, required)
                        - one of `"bytes"`
                    - `Timestamp`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.11.type`; string, required)
                        - one of `"timestamp"`
                      - `unit` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.11.unit`; string, optional)
                        - one of `"second"`, `"millisecond"`, `"microsecond"`, `"nanosecond"`
                    - `Json`
                      - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.fields.12.type`; string, required)
                        - one of `"json"`
                    - `Struct`
                    - `List`
                  - discriminator: `type`
                - `type` (`get_connection_tables.response.200.data.schema.fields.14.items.13.type`; string, required)
                  - one of `"struct"`
              - `List`
            - discriminator: `type`
          - `type` (`get_connection_tables.response.200.data.schema.fields.14.type`; string, required)
            - one of `"list"`
      - discriminator: `type`
    - `format` (`get_connection_tables.response.200.data.schema.format`; one of, optional, nullable)
      - one of the following:
        - `Json`
          - `type` (`get_connection_tables.response.200.data.schema.format.1.type`; string, required)
            - one of `"json"`
          - `compression` (`get_connection_tables.response.200.data.schema.format.1.compression`; string, optional)
            - one of `"uncompressed"`, `"gzip"`
          - `confluent_schema_registry` (`get_connection_tables.response.200.data.schema.format.1.confluent_schema_registry`; boolean, optional)
          - `debezium` (`get_connection_tables.response.200.data.schema.format.1.debezium`; boolean, optional)
          - `decimal_encoding` (`get_connection_tables.response.200.data.schema.format.1.decimal_encoding`; string, optional)
            - one of `"number"`, `"string"`, `"bytes"`
          - `include_schema` (`get_connection_tables.response.200.data.schema.format.1.include_schema`; boolean, optional)
          - `schema_id` (`get_connection_tables.response.200.data.schema.format.1.schema_id`; integer, optional, nullable)
            - format: `int32` · minimum: `0`
          - `timestamp_format` (`get_connection_tables.response.200.data.schema.format.1.timestamp_format`; string, optional)
            - one of `"rfc3339"`, `"unix_millis"`
          - `unstructured` (`get_connection_tables.response.200.data.schema.format.1.unstructured`; boolean, optional)
        - `Avro`
          - `type` (`get_connection_tables.response.200.data.schema.format.2.type`; string, required)
            - one of `"avro"`
          - `confluent_schema_registry` (`get_connection_tables.response.200.data.schema.format.2.confluent_schema_registry`; boolean, optional)
          - `into_unstructured_json` (`get_connection_tables.response.200.data.schema.format.2.into_unstructured_json`; boolean, optional)
          - `raw_datums` (`get_connection_tables.response.200.data.schema.format.2.raw_datums`; boolean, optional)
          - `reader_schema` (`get_connection_tables.response.200.data.schema.format.2.reader_schema`; string, optional)
          - `schema_id` (`get_connection_tables.response.200.data.schema.format.2.schema_id`; integer, optional, nullable)
            - format: `int32` · minimum: `0`
        - `Protobuf`
          - `type` (`get_connection_tables.response.200.data.schema.format.3.type`; string, required)
            - one of `"protobuf"`
          - `compiled_schema` (`get_connection_tables.response.200.data.schema.format.3.compiled_schema`; string, optional, nullable)
            - format: `binary`
          - `confluent_schema_registry` (`get_connection_tables.response.200.data.schema.format.3.confluent_schema_registry`; boolean, optional)
          - `into_unstructured_json` (`get_connection_tables.response.200.data.schema.format.3.into_unstructured_json`; boolean, optional)
          - `length_delimited` (`get_connection_tables.response.200.data.schema.format.3.length_delimited`; boolean, optional)
          - `message_name` (`get_connection_tables.response.200.data.schema.format.3.message_name`; string, optional, nullable)
        - `Parquet`
          - `type` (`get_connection_tables.response.200.data.schema.format.4.type`; string, required)
            - one of `"parquet"`
          - `compression` (`get_connection_tables.response.200.data.schema.format.4.compression`; string, optional)
            - one of `"uncompressed"`, `"snappy"`, `"gzip"`, `"zstd"`, `"lz4"`, `"lz4_raw"`
          - `row_group_bytes` (`get_connection_tables.response.200.data.schema.format.4.row_group_bytes`; integer, optional, nullable)
            - format: `int64` · minimum: `0`
        - `RawString`
          - `type` (`get_connection_tables.response.200.data.schema.format.5.type`; string, required)
            - one of `"raw_string"`
        - `RawBytes`
          - `type` (`get_connection_tables.response.200.data.schema.format.6.type`; string, required)
            - one of `"raw_bytes"`
      - discriminator: `type`
    - `framing` (`get_connection_tables.response.200.data.schema.framing`; one of, optional, nullable)
      - one of the following:
        - `Newline`
          - `method` (`get_connection_tables.response.200.data.schema.framing.1.method`; string, required)
            - one of `"newline"`
          - `max_line_length` (`get_connection_tables.response.200.data.schema.framing.1.max_line_length`; integer, optional, nullable)
            - format: `int64` · minimum: `0`
      - discriminator: `method`
    - `inferred` (`get_connection_tables.response.200.data.schema.inferred`; boolean, optional, nullable)
    - `primary_keys` (`get_connection_tables.response.200.data.schema.primary_keys`; array of string, optional)
  - `table_type` (`get_connection_tables.response.200.data.table_type`; string, required)
    - one of `"source"`, `"sink"`, `"lookup"`
  - `connection_profile` (`get_connection_tables.response.200.data.connection_profile`; object, optional, nullable)
    - `config` (`get_connection_tables.response.200.data.connection_profile.config`; unknown, required)
    - `connector` (`get_connection_tables.response.200.data.connection_profile.connector`; string, required)
    - `description` (`get_connection_tables.response.200.data.connection_profile.description`; string, required)
    - `id` (`get_connection_tables.response.200.data.connection_profile.id`; string, required)
    - `name` (`get_connection_tables.response.200.data.connection_profile.name`; string, required)
- `hasMore` (`get_connection_tables.response.200.hasMore`; boolean, required)


Source: https://www.arroyo.dev/docs/api/get-connection-tables/index.md
