---
title: "Search Table Inventory Api"
method: GET
path: "/tables/inventory"
tags: ["TABLES"]
---

# Search Table Inventory Api

`GET /tables/inventory`

Name-searchable table inventory, read from `table_metadata` (AI-8314).

The Studio opportunity picker used `/tabledata`, a Snowflake cost rollup
that lists strictly fewer tables than the publish gate accepts — 1,253 of
2,920 on prod megatenant, and nothing at all on a new-pipeline tenant. This
reads the same table the gate verifies against, so anything listed here can
be published, and it searches server-side rather than filtering one
already-fetched page.

## Query parameters

- `search` string — Table name or database.schema.table
- `page` integer
- `size` integer
- `instance_ids` integer[]
- `navigationSource` string, nullable

## Response `200`

Successful Response

- PaginatedFilterResponse
  - `items` AppSchemasTablesFilterResponse[], required
    - `label` string, required
    - `value` string, required
    - `database` string, nullable
    - `table_schema` string, nullable
  - `total` integer, required
  - `page` integer, required
  - `size` integer, required
  - `pages` integer, required

## Other responses

- `400` — Not supported for public user
- `403` — Not supported for public user
- `422` — Validation Error

## Changes

- **2026-09-11** `70e0a3e5cb0d` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/myaltimate/apis/fastapi/changes/tables/inventory/get.md)

---

[API](https://skmtc.dev/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.dev/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc.dev/myaltimate/apis/fastapi/revisions/4dfe86ff412c?raw)