Summary
When using csv source file connector and postgresql destination connector in Airbyte, the issue of data types being overwritten by Airbyte causing sync failures due to invalid data types can be resolved by configuring the json schema for the sync setup.
Question
Hi, I am trying to transform data from csv to Postgres destination table using csv source file connector and postgresql destination connector. Issue that I am facing is all data types of my target database table are over written by Airbyte and it creates new columns as well as with different datatypes mostly numeric ,Character type and during sync it finally fails while inserting to table due to invalid data type .Can you let me know is there a way to retain the actual column types of my target table or is there a way to configure json schema for the sync setup from Airbyte
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.