Hello, context : BigQuery Target. Is there a way to deal with date or timestamp that have "0" for value? For exemple : 0000-00-00 or 0000-00-00 000000 ? Because for BigQuery it's making errors and the data is not loaded, I have that issue on XXX fields in XXXX tables and I can't do "manual" fix 😕

do you have a callstack? I know at least tap-postgres has a

dates_as_string

which, bear with me here, will read the date information from the tap and not attempt to pointlessly cast it into the restrictive Python datetime structure and then it will send it along to the target as a string as well