Hi everyone, i'm starting with airbyte collecting ...
# ask-community-for-troubleshooting
g
Hi everyone, i'm starting with airbyte collecting data from hubspot to postgres (and tested to mysql as well). With postgres i'm having error with 3 tables relacted to timezone:
invalid input syntax for type timestamp with time zone: ""
I'm only using basic normalization. There is something to resolve this without write my own normaization?
1
s
It seems like we are trying to insert empty string
""
in a column with timestamp data type. Perhaps we should replace empty string with null values. @s what do you think?
s
this should have been fixed yesterday: https://github.com/airbytehq/airbyte/pull/5798/files @Gleidson Campos are you using the hubspot 0.1.12 version?
👍 2
g
This version is not marked as "latest" yet (at least to me) but i manually updated it and worked fine. Thanks @s and @Subodh (Airbyte)