Why am I getting the "Account: bad field names on insert/update call: Name" on Heroku Connect with Person Accounts?

Issue

"Account: bad field names on insert/update call: Name" is logged when updating the name column of the Contact mapping object on the database. Note that Person Account is enabled in this Account object.

Resolution

Please use firstname and lastname instead of name column because Person Account names consist of First Name and Last Name.