add_columns
Add one or more columns to a table in a watsonx.data schema by providing column names, data types, and optional attributes such as precision or scale.
Instructions
Add one or more columns to a table in a watsonx.data schema.
Note: Data types are typically specified in lowercase (e.g., "varchar", "int", "decimal"). While the API pattern allows both cases, lowercase is recommended for compatibility.
Args: catalog_name: Catalog containing the table (e.g., "iceberg_data") schema_name: Schema containing the table table_name: Table to add columns to columns: List of column definitions, each with: name (required), type (required, lowercase recommended), comment (optional), extra (optional), precision (optional), scale (optional) engine_id: Engine ID to use for the operation (from list_engines)
Returns: Dict with: - columns: List of added column details - total_count: Number of columns added
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| catalog_name | Yes | ||
| schema_name | Yes | ||
| table_name | Yes | ||
| columns | Yes | ||
| engine_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||