Databricks – Update rows in table action
The Update rows in table action modifies one or more rows in a selected Databricks table. Select the target table, define a WHERE condition to filter rows, and enter new values for the columns you plan to update.
Input
| Input field | Description |
|---|---|
| Table | Select the Databricks table where you plan to update 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 update. For example: currency = 'USD'. Enclose string values in single quotes. |
| Columns | Enter values for the columns you plan to update. Workato displays column fields based on the selected table’s schema. |
Additional input fields may appear based on the Table you select.
Output
| Output field | Description |
|---|---|
| Number of rows updated | The number of rows that matched the WHERE condition and were successfully updated. |
Last updated: