Databricks – Delete rows in table action
The Delete rows in table batch action removes one or more rows from a selected Databricks table. Select the target table and define a WHERE condition to filter the rows you plan to delete.
Input
| Input field | Description |
|---|---|
| Table | Select the Databricks table where you plan to delete rows. Only the first 1,000 tables are displayed. Enter the table name if it doesn't appear in the drop-down menu. |
| WHERE condition | Enter a SQL WHERE clause to filter the rows you plan to delete. For example: currency = 'USD'. Enclose string values in single quotes. |
Output
| Output field | Description |
|---|---|
| Number of rows deleted | The number of rows that matched the WHERE condition and were successfully deleted. |
Last updated: