Hi, Kudos Team, Need help here 🚁 I'm trying to do a PoC on DMS using airbyte with MSSQL as the source and Postgres AWS RDS as a destination, however the datatypes like int and timestamp are getting converted to float and string respectively,

Hi @Vishnu K, The JDBC connectors, such as MSSQL, are converting types to JSON schema types, and all numbers are converted to a float type on destination. I understand that it's not ideal and I opened an issue for this (feel free to subscribe to receive updates). This should be handled pretty soon as our quarter priority is to improve database connectors. About the timestamp, they are indeed stored as string in the

raw

tables, because we store raw json and json does not handle date formats, but if you use normalization I think they should be converted to a timestamp type on the final table. Feel free to post on our forum if you need additional assistance on this topic or for the rest of your PoC