---
title: "Search Tabulars"
method: POST
path: "/management/v1/warehouse/{warehouse_id}/search-tabular"
tags: ["warehouse"]
---

# Search Tabulars

`POST /management/v1/warehouse/{warehouse_id}/search-tabular`

## Request

- Base URL: `https://localhost`
- URL: `https://localhost/management/v1/warehouse/{warehouse_id}/search-tabular`
- Auth: HTTP bearer
- TypeScript: <https://skmtc.dev/lakekeeper/apis/lakekeeper-management-api/docs/management/v1/warehouse/:warehouse_id/search-tabular/post.ts> (a function with typed inputs; its response is checked against the schema)

Performs a fuzzy search for tabulars based on the provided criteria. If the search string
can be parsed as uuid:
- if there is tabular with that uuid, the tabular is in the response
- if there is a namespace with that uuid, tables in that namespace are in the response

## Path parameters

- `warehouse_id` string, uuid, required

## Request body

- SearchTabularRequest
  - `search` string, required: Search string for fuzzy search. Length is truncated to 64 characters.

## Response `200`

List of tabulars

- SearchTabularResponse: Search result for tabulars
  - `tabulars` SearchTabular[], required: List of tabulars matching the search criteria
    - `distance` number, float, nullable: Better matches have a lower distance
    - `namespace-name` string[], required: Namespace name
    - `tabular-id` union, required
      - object
        - `id` string, uuid, required
        - `type` 'table', required
      - object
        - `id` string, uuid, required
        - `type` 'view', required
      - object
        - `id` string, uuid, required
        - `type` 'generic-table', required
    - `tabular-name` string, required: Tabular name

## Other responses

- `4XX`

---

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