Non updatable columns. mysql -> mailchimp

  • 154Views
  • Last Post 04 September 2017
0
votes
Tamás Ángyán posted this 01 September 2017

Hey guys!

I'm trying to sync my mysql table (one ID column and one e-mail column), but when I'm creating a task and I select my table it says that "Table does not have updatable columns.".

What do you think, what is wrong with the solution? Thanks for you help!

0
votes
Mariia Zaharova posted this 04 September 2017

Please refer to: https://skyvia.com/resources/docs/index.html?connecting_to_mailchimp.htm

Synchronization and replication with Incremental Updates enabled are not supported for objects without CreatedDate or LastUpdate fields. Both fields must be present for this functionality. 

When performing synchronization repeatedly, Skyvia synchronizes only data that was changed since the previous synchronization. For this, it uses the fields storing information about when a record was created and modified in cloud applications and creates special tracking tables and triggers in relational databases for data modification tracking. In some cloud applications, certain objects don't have such fields, and synchronization is not supported for these objects.

Thus, you are selecting some object without CreatedDate or LastUpdate fields and, due to this fact, you are getting this error.

Best regards,

Mariia

Close