the example in iceberg/ingest-from-iceberg#periodic-full-reload-with-create-table is incorrect. Users should always set a primary key in the table definition only like
create table iceberg_batch_table ( primary key (id) ) with (......)
Define a table with columns is incorrect.
CREATE TABLE iceberg_batch_table (
id int primary key,
name varchar
)