Data type transformation issue from MS SQL to PostgreSQL

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

Summary

Issue with data type transformation from ‘Money’ to ‘Numeric (38,4)’ in Airbyte connector when replicating a table from MS SQL to PostgreSQL, resulting in NULL values and ‘destination typecast error’.


Question

Hi All!. I have a connection from MS Sql (with CDC) –> PostgreSQL, replicating a Table. All fields are working fine, but in the source I have a subset with data type “Money” that Airbytes transforms to “Numeric (38,4)” in the Destination DB. The problem is that Airbyte saves NULL in these fields; while the error message is “destination typecast error” . Any thoughs? thanks. Daniel


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

["data-type-transformation", "ms-sql", "postgresql", "airbyte-connector", "null-values", "destination-typecast-error"]