Error creating destination table on SQL Server during data sync

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

During a CDC sync between Postgresql and SQL Server, Airbyte is failing to create the destination table on SQL Server due to an error related to an invalid date-time format in one of the columns.


Question

Hi All,
I’m try running a cdc between Postgresql and a SQL Server.
Create the connectors, choose the tables and start the sync.
The Airbyte take a while, read the data on PG, create a schema on SQL, create a internal table on SQL with a json with the Data.
But don’t create the destination table on SQL, I monitoring the connection on SQL and he even try create the table.
At the Airbyte logs I identified a message about a error in one column, the error on platform is 2018-11-23T13:39:52 is a invalid date-time.
But the column on PG is a timestamp without a time zone and on PG I don’t have this T on the column data.


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["cdc", "postgresql", "sql-server", "data-sync", "destination-table", "error", "date-time-format"]
2

Is this happening to all tables from Postgres?
<@U070BSGH00P> did you have other connectors to SQL Server? (maybe use a sample Faker or PokeAPI to ensure the destination connector has the right permissions)

3

Hi <@U01MMSDJGC9> all tables with timestamp data type.
On destination database, the user is db_owner.
We user create a table on destination, _ airbyte_ some tables with all the records on json format.
But looks like when the airbyte try do the transformation go the error.

4

What version of both connectors are you using?

5

PG 3.3.27
SQL Server 1.0.0