I am testing Skyvia's Synchornzation package and I have run into an error while mapping a non-pk id column from Salesforce to an empty table in a postgresql DB.
I used the new runtime expression mapping int4(id) when mapping the DT_I4 DB id field to Salesforce but the following error always comes up:
Error evaluating 'id' from expression 'int4(Id)': Cannot convert 'string' to 'int4'.
The DB id field must be mapped according to the sync package and this id field is not the pk as I have created a new column "sync_id" which is an auto-generated pk column.
I am not sure how I can solve this and I hope you can help to provide a solution.