execute_update
Execute UPDATE SQL queries against watsonx.data tables. Returns query ID, rows updated, execution time, and status.
Instructions
Execute UPDATE queries against watsonx.data.
Args: sql: SQL UPDATE query to execute (must start with UPDATE) catalog_name: Target catalog (e.g., "iceberg_data", "hive_data") schema_name: Default schema for unqualified table names engine_id: Engine to run query on (from list_engines, must be running)
Returns: Dict with: - query_id: Unique query identifier - rows_updated: Number of rows updated (if available) - execution_time_ms: Query duration in milliseconds - status: Query execution status - catalog_name, schema_name: Echo of inputs Note: Iceberg table updates require at least format version 2 and update mode must be merge-on-read. Use ALTER TABLE to configure: SET PROPERTIES 'format-version' = '2', 'write.update.mode' = 'merge-on-read'
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| catalog_name | Yes | ||
| schema_name | Yes | ||
| engine_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||