Data
Merge-insert data to a table
Data
Merge-insert data to a table
Perform a merge-insert SQL query against a table. This can be used
to perform upserts. To perform an upsert, set when_matched_update_all
and when_not_matched_insert_all to true.
POST
https://{db}.{region}.api.lancedb.com
/
v1
/
table
/
{name}
/
merge_insert
/
Authorizations
Path Parameters
name of the table
Query Parameters
The column to match on.
If true, update all columns when a match is found with the new values.
An additional filter to apply when updating all columns.
If true, insert all columns when no match is found.
If true, delete rows in the target table when there is no match in the source table.
An additional filter to apply when deleting rows in the target table.
Body
application/vnd.apache.arrow.stream · file
The body is of type file.