Summary
User is facing issues with incremental sync for a table and encountering a data conversion error related to a DATE field during migration from Stitch Data to Airbyte.
Question
Hi, I’m migrating from Stitch Data to Airbyte.
However, I’ve encountered two issues in Airbyte that I didn’t have with Stitch Data:
-
There’s one table that I can’t sync incrementally.
-
I’m seeing the following error: “Failed to properly convert data value for ‘XXXXXX.XXXXX.billDate’ of type DATE org.apache.kafka.connect.errors.DataException: Invalid Java object for schema with type STRING: class java.lang.Integer for field: ‘billDate’.”
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.