Hi all, it's the first time i'm trying to setup a Meltano instance. I'm using the default tap-mysql and target-bigquery.
When i run the elt to load data, i'm getting 2 different issues with target bigquery:
1. If i have a datetime field i'm getting this message: JSON parsing error in row starting at position 0: Couldn't convert value to timestamp: Day 0-0-0 does not exist for timestamp: 0000-00-00 000000 Field: c_created_time
2. on another small table i did the load without issues. Then i tried to add a new field on mysql and when i run the elt i get this error message: Provided Schema does not match Table ...myDB-test_table. Cannot add fields (field: created_date)
Any help here would be much appreciated, thanks.