Databases

Apply a database schema promotion

Applies the exact reviewed schema-only promotion SQL to the production database. The stored source and target schema hashes must still match, otherwise the request fails with 409.

post/api/v1/databases/{databaseId}/schema-promotions/{promotionId}/apply

Request

  • Base URL
    https://app.khotan.com
  • URL
    https://app.khotan.com/api/v1/databases/{databaseId}/schema-promotions/{promotionId}/apply
  • Auth
    • HTTP bearer
    • or API key in header x-api-key

Path parameters

databaseIdstring required
promotionIdstring required

Response

The applied promotion record.

idstring required
databaseIdstring required
branchIdstring required
status'planning' | 'ready' | 'blocked' | 'applying' | 'applied' | 'failed' required
sourceSchemaHashstring required
targetSchemaHashstring required
sqlstring required
failedStatementIndexinteger nullable required
createdAtstring required
updatedAtstring required
validatedAtstring nullable required
appliedAtstring nullable required
failedAtstring nullable required

Changes

No recorded changes to this operation across all 1 revision of this API.