Merge Insert
Create a "merge insert" operation This operation can add rows, update rows, and remove rows all in a single transaction. See python method lancedb.table.Table.merge_insert for examples.
Path parameters
name of the table
Query parameters
The column to use as the primary key for the merge operation.
Rows that exist in both the source table (new data) and the target table (old data) will be updated, replacing the old row with the corresponding matching row.
If present then only rows that satisfy the filter expression will be updated
Rows that exist only in the source table (new data) will be inserted into the target table (old data).
Rows that exist only in the target table (old data) will be deleted. An optional condition (when_not_matched_by_source_delete_filt) can be provided to limit what data is deleted.
The filter expression that specifies the rows to delete.
Response
Merge Insert successful