# Delete
##  Delete
### Description
The Delete transform deletes rows of data from a database.
This transform is similar to the update family of transforms in that it takes one or more key fields to determine the rows to delete.
| Hop Engine | ✓ |
| ---------- | ------------ |
| Spark | ? |
| Flink | ? |
| Dataflow | ? |
### Options
| Option | Description |
| ----------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| Transform name | Name of the transform. This name has to be unique in a single pipeline. |
| Connection | The database connection to which data is written. |
| Target schema | The name of the Schema for the table to which data is written. This is important for data sources that allow for table names with periods in them. |
| Target table | Name of the table in which you want to do the insert or update. |
| Commit size | The number of rows to change (insert / update) before running a commit. |
| The keys(s) to look up the value(s) | Specify fields to delete the corresponding rows for. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/delete.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.