> ## Documentation Index
> Fetch the complete documentation index at: https://docs.open-metadata.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Schema Versions

> List and retrieve historical versions of a database schema

# Database Schema Versions

Every change to a database schema entity creates a new version. Use these endpoints to view the version history and retrieve specific versions.

## List Versions

<ParamField path="id" type="string" required>
  UUID of the database schema.
</ParamField>

## Get Specific Version

Use `GET /v1/databaseSchemas/{id}/versions/{version}` to retrieve a specific version.

<ParamField path="id" type="string" required>
  UUID of the database schema.
</ParamField>

<ParamField path="version" type="string" required>
  Version number to retrieve (e.g., `0.2`).
</ParamField>

<RequestExample dropdown>
  ```python GET /v1/databaseSchemas/{id}/versions theme={null}
  from metadata.sdk import configure
  from metadata.sdk.entities import DatabaseSchemas

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

  # List all versions
  versions = DatabaseSchemas.get_versions("770e8400-e29b-41d4-a716-446655440000")
  for v in versions:
      print(f"Version {v.version}: {v.description}")

  # Get a specific version
  schema_v1 = DatabaseSchemas.get_specific_version(
      "770e8400-e29b-41d4-a716-446655440000",
      "0.1"
  )
  print(f"Original description: {schema_v1.description}")
  ```

  ```java GET /v1/databaseSchemas/{id}/versions theme={null}
  import static org.openmetadata.sdk.fluent.DatabaseSchemas.*;

  // List all versions
  var versions = DatabaseSchemas.getVersions("770e8400-e29b-41d4-a716-446655440000");

  // Get a specific version
  DatabaseSchema v1 = DatabaseSchemas.getSpecificVersion(
      "770e8400-e29b-41d4-a716-446655440000",
      "0.1"
  );
  System.out.println("Description: " + v1.getDescription());
  ```

  ```bash GET /v1/databaseSchemas/{id}/versions theme={null}
  # List all versions
  curl "{base_url}/api/v1/databaseSchemas/f681432b-e66c-4096-a1cd-7771358c5323/versions" \
    -H "Authorization: Bearer {access_token}"

  # Get a specific version
  curl "{base_url}/api/v1/databaseSchemas/f681432b-e66c-4096-a1cd-7771358c5323/versions/0.1" \
    -H "Authorization: Bearer {access_token}"
  ```
</RequestExample>

<ResponseExample>
  ```json Response (List Versions) theme={null}
  {
    "entityType": "databaseSchema",
    "versions": [
      "{\"id\":\"f681432b-e66c-4096-a1cd-7771358c5323\",\"name\":\"information_schema\",\"version\":0.2,\"description\":\"Updated schema for Glue service tables\"}",
      "{\"id\":\"f681432b-e66c-4096-a1cd-7771358c5323\",\"name\":\"information_schema\",\"version\":0.1,\"description\":\"This **mock** database contains tables related to the Glue service\"}"
    ]
  }
  ```
</ResponseExample>

***

## Returns

**List versions** returns an object with `entityType` and a `versions` array of serialized entity snapshots (newest first).

**Get specific version** returns the full database schema object as it existed at that version.

***

## Error Handling

| Code  | Error Type     | Description                               |
| ----- | -------------- | ----------------------------------------- |
| `401` | `UNAUTHORIZED` | Invalid or missing authentication token   |
| `404` | `NOT_FOUND`    | Database schema or version does not exist |