Error with MySQL connector schema validation

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Error message related to schema validation in MySQL connector when syncing to Snowflake


Question

Hi all, we recently updated the MySQL connector. Now we have this error for the first time:
Schema validation errors found for stream "table here". Error messages: [$.updated_at: 2024-02-07T01:24:05 is an invalid date-time,

Syncing from MySQL to Snowflake. The source tables are completely fine, and nothing has changed. Yet every single table fails with the same error as above. I was wondering anyone else recently faced this?


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.

Join the conversation on Slack

["mysql-connector", "schema-validation", "syncing", "snowflake"]
2

fyi, this was fixed by downgrading the connector

3

What version did you see this issue with?

4

It was the Snowflake connector v 3.3.1, we went down to v2.xx