Insert rows directly

insert_rows appends rows to an existing table. Use it when all rows are new and you want a simpler call than merge_rows.

Insert

{ "table": "eddytor.cfg_xxx.<uuid>_products",
  "rows": [
    { "product_id": "P200", "name": "New Item", "category": "Clothing", "price": 19.99, "status": "active" },
    { "product_id": "P201", "name": "Another",  "category": "Clothing", "price": 24.99, "status": "active" }
  ]}

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

Every write is validated

All inserts enforce PK uniqueness, NOT NULL, CHECK constraints, and domains. If any row fails, the entire batch is rejected - fix the offending rows and retry the whole batch.

Insert vs merge

• insert_rows - all rows are new. Simpler.
• merge_rows - mix of insert/update/delete, or upsert-by-key. Use it when rows might already exist.

Next

• Upsert / merge by key · Edit data over time.