Hello guys, It's so good to be part of the community. I am a newbie with airbyte and i really need the community's help. I am trying to replicate data from postgres to bigquery. However, tables with "timestamp without time zone" are not replicated. I am not allowed to change the source table. Is there any workaround?

Hi. In general: timestamp without time zone values, are not a point on the timeline. They represent a rough idea about potential moments, possible points on the timeline along a range of about 27+- hours (the range of time zones around the globe). They have no real meaning until you apply a time zone or offset-from-UTC. So no - you cannot not use it. either change the source table data or create logic in your connector

Thanks @Eli Sigal for the reply . I cannot go through the route for source table. How do i change the logic in the connector

just change the code behind the scenes go to: airbyte-integrations/connectors/source-postgres/src/main/java/io/airbyte/integrations/source/postgres

Thanks alot @Eli Sigal. I will check it out

@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 2684 to ensure timely resolution!

@Jamiu Afolabi let us know Eli’s suggestions worked for you so we can close this ticket!

Hi @Saj Dider (Airbyte), His suggestion works fine. Thanks for the timely resolution