Hi everyone, I am using MySQL connector for syncing from a MariaDB. I encounter an issue where if a date column has an invalid date (i.e. '0000-11-30'), sync fails with error message "java.sql.SQLException: YEAR". Please check the Github issue below for more details What's strange is, if column has some valid value, and the invalid value is all zero '0000-00-00', sync works fine. Github issue I created for this: https://github.com/airbytehq/airbyte/issues/16574 I really appreciate all your help, I have been trying a lot of ways to deal with this, but still fail. This is really important for my customer

Hi. looking at the .txt file it seems that it did work but failed in the normalization step? am I correct? if so remove it for now as a temp solution or create your own dbt logic for that. it assumes you are using big query very odd