---
title: "Handle Sql Transform Commit"
method: POST
path: "/sql-transforms/commit"
tags: ["Transforms (SQL)"]
---

# Handle Sql Transform Commit

`POST /sql-transforms/commit`

Fully commit a transform.

## Request body

- SQLTransformCommitRequest
  - `flow_id` string, required — The ID of the flow for this transform.
  - `transform_plan_ids` integer[] — A list of transform plans ids to formally commit. This performs these transform plans in sequence and hard-bakes the result, pointing the flow to the result instead.

## Response `200`

Successful Response

- AsyncJobRecord — Do NOT access this table directly.
  - `id` integer, nullable — ID of this object.
  - `created_at` string, date-time, nullable — datetime object representing when this object was created.
  - `updated_at` string, date-time, nullable — datetime object representing when this object was updated.
  - `deleted_at` string, date-time, nullable — datetime object representing when this object was deleted.
  - `status` 'RUNNING' | 'COMPLETED' | 'FAILED'
  - `endpoint` string — Endpoint spawning async job
  - `request` union — request sent to endpoint
    - object
    - unknown[]
      - unknown
  - `sync_response` union — sync response
    - object
    - unknown[]
      - unknown
  - `error` string, nullable — error message
  - `response` unknown

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.net/akkio/apis/fastapi.md) · [All operations](https://skmtc.net/akkio/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/akkio/fastapi/versions/6662a407c637/schema)