---
title: "List Lakehouse tables for a DuckLake integration"
method: GET
path: "/v4/catalog/integrations/{integration_id}/tables"
tags: ["v4", "Catalog"]
---

# List Lakehouse tables for a DuckLake integration

`GET /v4/catalog/integrations/{integration_id}/tables`

## Path parameters

- `integration_id` union, required
  - string, uuid
  - string

## Response `200`

Success

- SuccessResponseCatalogTablesResponse
  - `success` true, required — Flag for it request was successful
  - `data` CatalogTablesResponse, required
    - `integration_id` union, required
      - string, uuid
      - string
    - `tables` CatalogTableSummary[], required
      - `schema_name` string, required — Lakehouse schema name
      - `table_name` string, required
      - `table_id` integer, required
      - `kind` 'table' | 'view' — DuckLake object kind. Views have no storage / snapshots / partitions.
      - `file_format` string, nullable — parquet | iceberg | ...
      - `size_bytes` integer — Live storage in bytes (alias for live_size_bytes; kept for back-compat)
      - `row_count` integer — Live row count (sum of record_count across live data files)
      - `live_size_bytes` integer — Live storage in bytes (current snapshot)
      - `total_size_bytes` integer — Total storage across all snapshots (live + tombstoned)
      - `live_file_count` integer — Number of live data files
      - `total_file_count` integer — Total data files across all snapshots
      - `total_inserted_rows` integer — Sum of record_count across ALL data files (lifetime inserts)
      - `partition_columns` CatalogPartitionColumn[]
        - `column_name` string, required
        - `transform` string, nullable
      - `partition_count` integer
      - `snapshot_count` integer
      - `last_write` string, date-time, nullable
  - `meta` ResponseMeta
    - `requestId` string — Unique request identifier for tracing
    - `timestamp` string, date-time — Response timestamp (UTC)
    - `durationMs` integer, nullable — Request processing time in milliseconds

## Other responses

- `401` — Auth Invalid Token
- `403` — Forbidden Insufficient Permissions
- `404` — Resource Not Found
- `422` — Validation Failed
- `426` — Business Quota Exceeded
- `500` — Internal Error

---

[API](https://skmtc.dev/definite/apis/defapi.md) · [All operations](https://skmtc.dev/definite/apis/defapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/definite/defapi/revisions/5ea378187147/schema)