Add table constraints
Appends one or more check constraints to the Delta Lake table. Constraints are SQL expressions evaluated on every write (insert/merge). Existing rows are not retroactively validated. **Required scope:** `tables:modify`
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 add check constraints to an existing 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}/constraints" \ -H "Content-Type: application/json" \ -d '{ "constraints": [ { "name": "string", "expr": "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" } ]}Delete a table
Permanently removes the Delta table and all associated Parquet/log files from the object store. This action is irreversible. **Required scope:** `tables:delete` (Builder and Admin)
Drop a table constraint
Removes a named check constraint from the Delta Lake table. The constraint name corresponds to the key used when the constraint was added. **Required scope:** `tables:modify`