Append new rows

To add new rows to a live table, use insert_rows - the same tool you used for the first load. Use it when every row is new; if rows might already exist, use merge_rows instead.

Append

{ "table": "eddytor.cfg_xxx.<uuid>_products",
  "rows": [ { "product_id": "P300", "name": "Latest", "category": "Food", "price": 4.50, "status": "active" } ] }

eddytor insert table eddytor sales orders --file ./more-orders.csv

Batch your appends

Every appended row is validated against PK uniqueness, NOT NULL, CHECK constraints, and domains - a bad row rejects the whole batch.

Next

• Update existing rows via merge · Delete rows.