---
title: "GET /api/table"
method: GET
path: "/api/table"
tags: ["/api/table"]
---

# GET /api/table

`GET /api/table`

Get all `Tables`.

  Optional filters:
  - `can-query=true` - filter to only tables the user can execute queries against
  - `can-write=true` - filter to only tables the user can edit metadata for

## Query parameters

- `term` string
- `visibility-type` string
- `data-layer` 'final' | 'internal' | 'hidden'
- `data-source` 'source-data' | 'transform' | 'unknown' | 'ingested' | 'metabase-transform' | 'upload'
- `owner-user-id` integer, nullable
- `owner-email` string
- `orphan-only` boolean, nullable
- `unused-only` boolean, nullable
- `can-query` boolean, nullable
- `can-write` boolean, nullable
- `include-transform-targets` boolean, nullable

## Response `2XX`

Successful response

## Other responses

- `4XX` — Client error response
- `5XX` — Server error response

## Changes

- **2026-05-22** `b1dc4ea67567` — 1 info
  - added the new optional `query` request parameter `include-transform-targets`
- **2026-03-09** `78297d193ca4` — 1 breaking, 1 info
  - api path removed without deprecation
  - endpoint added
- **2026-01-20** `bd1deee7eae2` — 2 info
  - added the new optional `query` request parameter `can-query`
  - added the new optional `query` request parameter `can-write`

[Change history](https://skmtc.dev/metabase/apis/metabase-api/changes/api/table/get.md)

---

[API](https://skmtc.dev/metabase/apis/metabase-api.md) · [All operations](https://skmtc.dev/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/metabase/metabase-api/revisions/b1dc4ea67567/schema)