Compare two versions of a table
Performs a diff between two Delta Lake table versions, returning rows that were inserted, deleted, or updated. Uses a FULL OUTER JOIN on the primary key columns to identify changes. Similar to a `git diff` for table data. **Required scope:** `tables:read`
Authorization
BearerAuth Security scheme for OpenAPI endpoints. Validates both JWT tokens and API keys.
In: header
Request Body
application/json
TypeScript Definitions
Use the request body type in TypeScript.
Request to compare two versions of a table.
Response Body
application/json
application/json
application/json
application/json
application/json
application/json
application/json
application/json
application/json
application/json
curl -X POST "https://example.com/v1/tables/{catalog}/{schema}/{table_name}/diff" \ -H "Content-Type: application/json" \ -d '{ "versionFrom": 0, "versionTo": 0 }'{ "versionFrom": 0, "versionTo": 0, "totalChanges": 0, "rowsInserted": 0, "rowsDeleted": 0, "rowsUpdated": 0, "rows": [ { "changeType": "string", "current": { "property1": null, "property2": null }, "previous": { "property1": null, "property2": null }, "changedColumns": [ "string" ] } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}{ "code": "string", "message": "string", "request_id": "string", "details": [ { "field": "string", "message": "string" } ]}Get table version history
Returns the Delta Lake transaction log for the table, listing each version with its timestamp, operation type, and commit metadata. Use this for audit trails or to select a version for time-travel / rollback. **Required scope:** `tables:read`
Rollback table to a previous version
Restores the Delta Lake table to the state at the specified version number by creating a new commit that reverts all subsequent changes. The rollback itself is recorded as a new version in the transaction log. **Required scope:** `tables:modify`