Forum Discussion
Data transformation using PostgreSQL connection
Hi Team
Currently, I am working on a project where I need to incrementally load one table data from Schema A of Azure postgreSQL database to schema B. The table i am using have 100+ columns and few of them are numeric and whenever i am trying to read data from source table using data flows its generating Null values for all numeric columns. See following screenshot for reference.
Source:
Destination:
If you notice, the last row contains data for numeric data types as well. To ensure ADF reads numeric and decimal values correctly, I clicked on the "overwrite schema" button in the data flow source and reselected the same decimal data type, as ADF converts numeric data types to decimal.
I suspect this might be a bug in ADF. Could you please let me know where I can report this issue? Additionally, is there a better way to resolve it?
Thanks,
Dinesh