Collate

Collate Tables API

`Table` organizes data in rows and columns and is defined in a `Database Schema`.

GitHub OpenAPI
Business capability
Information & Data Management BC-610

Operations 54

PUT /v1/tables/{id}/customMetric Add custom metrics #
PUT /v1/tables/{id}/dataModel Add data modeling information to a table #
PUT /v1/tables/{id}/tableProfile Add table profile data #
GET /v1/tables/{id}/tableProfilerConfig Get table profile config #
PUT /v1/tables/{id}/tableProfilerConfig Add table profile config #
DELETE /v1/tables/{id}/tableProfilerConfig Delete table profiler config #
PUT /v1/tables/{id}/followers Add a follower #
PUT /v1/tables/{id}/joins Add table join information #
GET /v1/tables/{id}/pipelineObservability Get pipeline observability data #
PUT /v1/tables/{id}/pipelineObservability Add pipeline observability data #
DELETE /v1/tables/{id}/pipelineObservability Delete pipeline observability data #
GET /v1/tables/{id}/sampleData Get sample data #
PUT /v1/tables/{id}/sampleData Add sample data #
DELETE /v1/tables/{id}/sampleData Delete sample data #
PUT /v1/tables/{id}/pipelineObservability/{pipelineFqn} Add or update single pipeline observability data #
DELETE /v1/tables/{id}/pipelineObservability/{pipelineFqn} Delete single pipeline observability data #
PUT /v1/tables/bulk Bulk create or update tables #
GET /v1/tables List tables #
PUT /v1/tables Create or update a table #
POST /v1/tables Create a table #
GET /v1/tables/{id} Get a table by Id #
DELETE /v1/tables/{id} Delete a table by Id #
PATCH /v1/tables/{id} Update a table #
GET /v1/tables/name/{fqn} Get a table by fully qualified name #
DELETE /v1/tables/name/{fqn} Delete a table by fully qualified name #
PATCH /v1/tables/name/{fqn} Update a table by name #
DELETE /v1/tables/async/{id} Asynchronously delete a table by Id #
DELETE /v1/tables/{id}/customMetric/{columnName}/{customMetricName} Delete custom metric from a column #
DELETE /v1/tables/{fqn}/{entityType}/{timestamp}/profile Delete table profile data #
DELETE /v1/tables/{id}/followers/{userId} Remove a follower #
DELETE /v1/tables/deleteStale Delete stale tables within a scope #
DELETE /v1/tables/{id}/customMetric/{customMetricName} Delete custom metric from a table #
GET /v1/tables/name/{name}/export Export table in CSV format #
GET /v1/tables/name/{name}/exportAsync Export table in CSV format #
GET /v1/tables/{id}/context Get the AI context for an entity by id #
GET /v1/tables/name/{fqn}/context Get the AI context for an entity by fully qualified name #
GET /v1/tables/{fqn}/tableProfile/latest Get the latest table profile #
GET /v1/tables/name/{fqn}/pipelineObservability Get pipeline observability data by table FQN #
GET /v1/tables/{id}/columns Get table columns with pagination #
GET /v1/tables/name/{fqn}/columns Get table columns with pagination by FQN #
GET /v1/tables/{id}/versions/{version} Get a version of the table #
PUT /v1/tables/name/{name}/import Import columns from CSV to update table (no creation allowed) #
PUT /v1/tables/name/{name}/importAsync Import columns from CSV to update table asynchronously (no creation allowed) #
GET /v1/tables/{fqn}/columnProfile List of column profiles #
GET /v1/tables/history List all entity versions within a time range #
GET /v1/tables/{fqn}/systemProfile List of system profiles #
GET /v1/tables/{fqn}/tableProfile List of table profiles #
GET /v1/tables/{id}/versions List table versions #
PUT /v1/tables/restore Restore a soft deleted table #
GET /v1/tables/entityRelationship Search Entity Relationship #
GET /v1/tables/entityRelationship/{direction} Search entity relationship with Direction #
GET /v1/tables/name/{fqn}/columns/search Search table columns with pagination by FQN #
GET /v1/tables/{id}/columns/search Search table columns with pagination by ID #
PUT /v1/tables/{id}/vote Update Vote for a Entity #

Documentation

📖
Documentation
https://docs.open-metadata.org/latest/api-reference
📖
APIReference
https://docs.open-metadata.org/latest/api-reference

Specifications

⚙
OpenAPI
https://artifacts.apis.io/collate/openapi/collate-tables-api-openapi.yml

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/collate:collate-tables-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

collate-tables-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: OpenMetadata Tables API
  description: Common types and API definition for OpenMetadata
  contact:
    name: OpenMetadata
    url: https://open-metadata.org
    email: openmetadata-dev@googlegroups.com
  license:
    name: Apache 2.0
    url: https://www.apache.org/licenses/LICENSE-2.0
  version: 2.0.5
servers:
- url: /api
  description: Current Host
- url: http://localhost:8585/api
  description: Endpoint URL
security:
- BearerAuth: []
tags:


# --- truncated at 32 KB (100 KB total) ---
# Full source: https://artifacts.apis.io/collate/openapi/collate-tables-api-openapi.yml