Chelabase
ManagementMerges

Export a merge's plan as SQL

GET
/v1/databases/{id}/merges/{merge_id}/plan.sql

The final plan as a .sql file: phase headers as comments, the plan's transaction in BEGIN/COMMIT starting with SET LOCAL lock_timeout and statement_timeout from the merge's options (its stale guard and recovery marker are left out), the online phase marked "run outside a transaction", roles as comments (never passwords). Never cached.

Authorization

bearer
AuthorizationBearer <token>

In: header

Path Parameters

id*string

Database id

Formatuuid
merge_id*string

Merge id

Formatuuid

Response Body

text/plain

application/json

application/json

application/json

application/json

application/json

application/json

curl -X GET "https://example.com/v1/databases/497f6eca-6276-4993-bfeb-53cbbbba6f08/merges/497f6eca-6276-4993-bfeb-53cbbbba6f08/plan.sql"
"string"