cURL
curl --request POST \ --url https://{db}.{region}.api.lancedb.com/v1/table/{name}/add_columns \ --header 'Content-Type: application/json' \ --header 'x-api-key: <api-key>' \ --data ' { "new_columns": [ { "name": "new_column", "expression": "old_column + 1" } ] } '
{}
Add new columns to a table using SQL expressions that can reference existing columns. You can generate computed columns or add null-filled columns with explicit type casting.
name of the table
Show child attributes
The name of the new column.
"new_column"
The SQL expression to generate the column.
"old_column + 1"
Update successful