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.root} ({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.root}")

import org.openmetadata.schema.entity.data.Table;
import org.openmetadata.sdk.models.ListParams;
import org.openmetadata.sdk.models.ListResponse;

// client is an initialized OpenMetadataClient.

// Retrieve by ID
Table table = client.tables().get(tableId);

// List tables
ListResponse<Table> result = client.tables().list(
    new ListParams()
        .setFields("columns,owners,tags")
        .setLimit(50)
);

for (Table t : result.getData()) {
    System.out.println(t.getFullyQualifiedName());
}

# List all
curl "{base_url}/api/v1/tables?limit=50" \
  -H "Authorization: Bearer {access_token}"

# Filter by schema
curl "{base_url}/api/v1/tables?databaseSchema=sample_data.ecommerce_db.shopify&limit=50" \
  -H "Authorization: Bearer {access_token}"

# With fields
curl "{base_url}/api/v1/tables?databaseSchema=sample_data.ecommerce_db.shopify&fields=columns,owners,tags&limit=50" \
  -H "Authorization: Bearer {access_token}"

{
  "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
  }
}