Hi, I have just upgraded Airbyte from v0.26.1 to v0.35.64-alpha and a sync from Hubspot to BigQuery (denormalized destination) failed with this message:
Invalid format: "2020-04-27 08:18:38" is malformed at " 08:18:38". This did not happen before. I have also upgraded the source & destination to the latest version, so not sure what鈥檚 the source of the problem. Attached is a portion of the log for your reference
logs.txt (8.0 KB)
Can you update the schema of this connection, maybe after the updates there are some data type changes.
I have reset the sync but the problem persists. I suspect that this is a problem with BigQuery denormalized destination
Is it possible to you run the sync using the Bigquery with normalization to validate if works? Probably a field that is timestamp is trying to be cast to date.
I鈥檝e just checked, it works with normalization
There is a PR correcting the problem @hoanghapham 馃帀Destination-bigquery-denorm: fixed emittedAt timestamp by etsybaev 路 Pull Request #11978 路 airbytehq/airbyte 路 GitHub
Hi there from the Community Assistance team.
We鈥檙e letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you鈥檙e having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we鈥檒l follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.