Add a column

Add columns to a live table without downtime. Existing rows get NULL for the new column, so a newly added column must be nullable (or backfilled before you make it required).

Add

eddytor create column eddytor sales orders --schema-file ./new-columns.json

{ "table": "eddytor.cfg_xxx.<uuid>_products", "columns": [
    { "name": "weight_kg", "data_type": "Float64", "nullable": true }
]}

After adding

Run the validation loop:

1. get_table_schema - confirm the column applied.
2. validate_constraints - existing data still passes.

To make the new column required later, backfill it first (e.g. via merge_rows), then set is_nullable: false - which is rejected if any NULLs remain.

Next

• Tune column settings · Govern with domains.