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

configure(
    host="https://your-company.getcollate.io/api",
    jwt_token="your-jwt-token"
)

# Soft delete by ID
Tables.delete("a1b2c3d4-e5f6-7890-abcd-ef1234567890")

# Hard delete
Tables.delete(
    "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
    recursive=True,
    hard_delete=True
)

# Delete by name (look up the ID first)
entity = Tables.retrieve_by_name("snowflake_prod.analytics.public.customers")
Tables.delete(entity.id)

# Restore a soft-deleted table
Tables.restore("a1b2c3d4-e5f6-7890-abcd-ef1234567890")

import java.util.Map;

// client is an initialized OpenMetadataClient.

// Soft delete
client.tables().delete("a1b2c3d4-e5f6-7890-abcd-ef1234567890");

// Hard delete with recursive
client.tables().delete("a1b2c3d4-e5f6-7890-abcd-ef1234567890", Map.of("recursive", "true", "hardDelete", "true"));

# Soft delete by ID
curl -X DELETE "{base_url}/api/v1/tables/455e3d9d-dbbf-455e-b3be-7191daa825f3" \
  -H "Authorization: Bearer {access_token}"

# Hard delete with recursive
curl -X DELETE "{base_url}/api/v1/tables/455e3d9d-dbbf-455e-b3be-7191daa825f3?recursive=true&hardDelete=true" \
  -H "Authorization: Bearer {access_token}"

# Delete by name
curl -X DELETE "{base_url}/api/v1/tables/name/sample_data.ecommerce_db.shopify.agent_performance_summary?recursive=true" \
  -H "Authorization: Bearer {access_token}"

# Restore soft-deleted table
curl -X PUT "{base_url}/api/v1/tables/restore" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{"id": "455e3d9d-dbbf-455e-b3be-7191daa825f3"}'

{
  "id": "455e3d9d-dbbf-455e-b3be-7191daa825f3",
  "name": "agent_performance_summary",
  "fullyQualifiedName": "sample_data.ecommerce_db.shopify.agent_performance_summary",
  "version": 0.2,
  "updatedAt": 1769982700000,
  "updatedBy": "admin",
  "tableType": "Regular",
  "serviceType": "BigQuery",
  "deleted": true
}