List Tables

List all tables with optional filtering and pagination

GET /v1/tables

GET /v1/tables

Python

from metadata.sdk import configure
from metadata.sdk.entities import Tables

configure(
    host="https://your-company.open-metadata.org/api",
    jwt_token="your-jwt-token"
)

# List with pagination
page = Tables.list(limit=50, fields=["columns", "owners", "tags"])
for t in page.entities:
    print(f"{t.fullyQualifiedName} ({len(t.columns or [])} columns)")

# List all with auto-pagination
all_tables = Tables.list_all(batch_size=100)
for table in all_tables:
    print(f"{table.fullyQualifiedName}")

Response

{
  "data": [
    {
      "id": "455e3d9d-dbbf-455e-b3be-7191daa825f3",
      "name": "agent_performance_summary",
      "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary",
      "description": "Summary of agent performance metrics derived from multiple tables including ssot_utilization_detail for comprehensive reporting.",
      "version": 0.1,
      "updatedAt": 1769982651320,
      "updatedBy": "admin",
      "href": "http://localhost:8585/api/v1/tables/455e3d9d-dbbf-455e-b3be-7191daa825f3",
      "tableType": "Regular",
      "columns": [
        {
          "name": "agent_id",
          "dataType": "VARCHAR",
          "dataLength": 100,
          "dataTypeDisplay": "varchar",
          "description": "Agent identifier",
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary.agent_id",
          "tags": [],
          "ordinalPosition": 1
        },
        {
          "name": "performance_score",
          "dataType": "DECIMAL",
          "dataTypeDisplay": "decimal",
          "description": "Overall performance score",
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary.performance_score",
          "tags": [],
          "ordinalPosition": 2
        }
      ],
      "owners": [],
      "databaseSchema": {
        "id": "4dd30184-009c-4792-b296-9562eaed651f",
        "type": "databaseSchema",
        "name": "shopify",
        "fullyQualifiedName": "sample_data.ecommerce_db.shopify",
        "description": "This **mock** database contains schema related to shopify sales and orders with related dimension tables.",
        "displayName": "shopify",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/databaseSchemas/4dd30184-009c-4792-b296-9562eaed651f"
      },
      "database": {
        "id": "0be090de-0941-48c4-af49-a6157c91cda0",
        "type": "database",
        "name": "ecommerce_db",
        "fullyQualifiedName": "sample_data.ecommerce_db",
        "description": "This **mock** database contains schemas related to shopify sales and orders with related dimension tables.",
        "displayName": "ecommerce_db",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/databases/0be090de-0941-48c4-af49-a6157c91cda0"
      },
      "service": {
        "id": "fd2193af-fe09-4366-92b7-1e0d01cd8c09",
        "type": "databaseService",
        "name": "sample_data",
        "fullyQualifiedName": "sample_data",
        "displayName": "sample_data",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/services/databaseServices/fd2193af-fe09-4366-92b7-1e0d01cd8c09"
      },
      "serviceType": "BigQuery",
      "tags": [],
      "deleted": false
    }
  ],
  "paging": {
    "after": "eyJsYXN0SWQiOiI0NTVlM2Q5ZC1kYmJmLTQ1NWUtYjNiZS03MTkxZGFhODI1ZjMifQ==",
    "total": 299
  }
}

List Tables

List all tables with optional filtering and pagination.

Query Parameters

database · string

Filter by database fully qualified name.

databaseSchema · string

Filter by database schema fully qualified name.

limit · integer · default: "10"

Maximum number of results to return (max: 1000000).

before · string

Cursor for backward pagination.

after · string

Cursor for forward pagination.

fields · string

Comma-separated list of fields to include. Valid fields: tableConstraints, tablePartition, usageSummary, owners, customMetrics, columns, sampleData, tags, followers, joins, schemaDefinition, dataModel, extension, testSuite, domains, dataProducts, lifeCycle, sourceHash.

include · string · default: "non-deleted"

Include all, deleted, or non-deleted entities.

includeEmptyTestSuite · boolean · default: "true"

Whether to include tables with empty test suites.

GET /v1/tables

Python

from metadata.sdk import configure
from metadata.sdk.entities import Tables

configure(
    host="https://your-company.open-metadata.org/api",
    jwt_token="your-jwt-token"
)

# List with pagination
page = Tables.list(limit=50, fields=["columns", "owners", "tags"])
for t in page.entities:
    print(f"{t.fullyQualifiedName} ({len(t.columns or [])} columns)")

# List all with auto-pagination
all_tables = Tables.list_all(batch_size=100)
for table in all_tables:
    print(f"{table.fullyQualifiedName}")

Response

{
  "data": [
    {
      "id": "455e3d9d-dbbf-455e-b3be-7191daa825f3",
      "name": "agent_performance_summary",
      "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary",
      "description": "Summary of agent performance metrics derived from multiple tables including ssot_utilization_detail for comprehensive reporting.",
      "version": 0.1,
      "updatedAt": 1769982651320,
      "updatedBy": "admin",
      "href": "http://localhost:8585/api/v1/tables/455e3d9d-dbbf-455e-b3be-7191daa825f3",
      "tableType": "Regular",
      "columns": [
        {
          "name": "agent_id",
          "dataType": "VARCHAR",
          "dataLength": 100,
          "dataTypeDisplay": "varchar",
          "description": "Agent identifier",
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary.agent_id",
          "tags": [],
          "ordinalPosition": 1
        },
        {
          "name": "performance_score",
          "dataType": "DECIMAL",
          "dataTypeDisplay": "decimal",
          "description": "Overall performance score",
          "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary.performance_score",
          "tags": [],
          "ordinalPosition": 2
        }
      ],
      "owners": [],
      "databaseSchema": {
        "id": "4dd30184-009c-4792-b296-9562eaed651f",
        "type": "databaseSchema",
        "name": "shopify",
        "fullyQualifiedName": "sample_data.ecommerce_db.shopify",
        "description": "This **mock** database contains schema related to shopify sales and orders with related dimension tables.",
        "displayName": "shopify",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/databaseSchemas/4dd30184-009c-4792-b296-9562eaed651f"
      },
      "database": {
        "id": "0be090de-0941-48c4-af49-a6157c91cda0",
        "type": "database",
        "name": "ecommerce_db",
        "fullyQualifiedName": "sample_data.ecommerce_db",
        "description": "This **mock** database contains schemas related to shopify sales and orders with related dimension tables.",
        "displayName": "ecommerce_db",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/databases/0be090de-0941-48c4-af49-a6157c91cda0"
      },
      "service": {
        "id": "fd2193af-fe09-4366-92b7-1e0d01cd8c09",
        "type": "databaseService",
        "name": "sample_data",
        "fullyQualifiedName": "sample_data",
        "displayName": "sample_data",
        "deleted": false,
        "href": "http://localhost:8585/api/v1/services/databaseServices/fd2193af-fe09-4366-92b7-1e0d01cd8c09"
      },
      "serviceType": "BigQuery",
      "tags": [],
      "deleted": false
    }
  ],
  "paging": {
    "after": "eyJsYXN0SWQiOiI0NTVlM2Q5ZC1kYmJmLTQ1NWUtYjNiZS03MTkxZGFhODI1ZjMifQ==",
    "total": 299
  }
}

---

Returns

Returns a paginated list of table objects. By default, only basic fields are included. Use the fields parameter to request additional data such as columns, tags, and owners.

Response

data · array

Array of table objects.

Show properties

id · string

Unique identifier for the table (UUID format).

name · string

Table name.

fullyQualifiedName · string

Fully qualified name in format service.database.schema.table.

displayName · string

Human-readable display name.

tableType · string

Type of table (e.g., Regular, View, MaterializedView).

databaseSchema · object

Reference to the parent database schema.

service · object

Reference to the parent database service.

serviceType · string

Type of database service.

columns · array

Column definitions. Only included when fields contains columns.

owners · array

List of owners. Only included when fields contains owners.

tags · array

Classification tags. Only included when fields contains tags.

paging · object

Pagination information.

Show properties

total · integer

Total count of tables matching the query.

after · string

Cursor for the next page of results.

before · string

Cursor for the previous page of results.