execute_insert
Insert data into watsonx.data by executing INSERT SQL queries on a specified engine, with required catalog and schema names.
Instructions
Execute INSERT queries against watsonx.data.
Args: sql: SQL INSERT query to execute (must start with INSERT) 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_inserted: Number of rows inserted (if available) - execution_time_ms: Query duration in milliseconds - status: Query execution status - catalog_name, schema_name: Echo of inputs
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 | |||