---
title: "Execute a DML query on external or lakehouse schemas"
method: POST
path: "/v1/dataapps/data/executeDML"
tags: ["Data Apps"]
---

# Execute a DML query on external or lakehouse schemas

`POST /v1/dataapps/data/executeDML`

## Request body

- ExecuteDMLRequest
  - `appId` string, required
  - `statement` string, required
  - `parameters` object[], required
    - `name` string, required
    - `value` unknown, required
    - `type` string, required

## Response `200`

OK

- DMLResult
  - `chunk` DMLResultChunk, required
    - `statementId` string, required
    - `chunkIndex` integer, required
    - `nextChunkIndex` integer, nullable, required
    - `data` unknown[], required
      - unknown
    - `rowCount` integer, required
  - `resultSchema` DMLResultSchema, required
    - `columnCount` integer, required
    - `columns` DMLResultSchemaColumn[], required
      - `name` string, required
      - `position` integer, required
      - `type` string, required
  - `statementId` string, required
  - `totalChunks` integer, required
  - `totalRowCount` integer, required

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `500` — Internal Server Error

---

[API](https://skmtc.net/tetrascience/apis/tetra-data-lake.md) · [All operations](https://skmtc.net/tetrascience/apis/tetra-data-lake/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/tetrascience/tetra-data-lake/versions/0205e2bace53/schema)