Migration from CSV: how to define a default value for autoincremental id field?
I finally understood that keys in source is the way to make each row of the csv file unique. It may be anything.
So I changed to:  

  keys:
    - contract_id
    - member_id


I removed id: idfrom processand it works!
The value of id field in the database is properly auto-incremented.