Using Azure Polybase data copy- empty string becomes NULL, NULL becomes empty string #sqldatawarehouse #polybase #datafactory #usetypedefault

Question

Hi I see an issue while loading data from source to target using polybase in ADF copy activity. issue detail:

1. Nulls in the source are converted to empty strings
2. I tried the option #usetypedefault in the sink and now Blanks in the source are converted to Nulls.

Also I found a relevant thread for the same issue in the forum where it was suggested to go with DFT but i cannot since we have hundreds of tables to copy the data. reference link: https://social.msdn.microsoft.com/Forums/en-US/a3cb56e4-2851-4c51-88d2-01d4efccddc8/polybase-empty-string-becomes-null-sqldatawarehouse-polybase-datafactory-usetypedefault?forum=AzureDataFactory Thank you, Bharat

Answer 1

Hello @Bharat Thatipally , Thanks for the question and using MS Q&A platform. I did test the scenario and if sink is SQL it does works fine .

If the sink is blob then you will have to set the NULL value property

and this gives the correct output.

Thanks Himanshu
Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.