Synapse Polybase ignores new line charater

Somu, Darthick (Cognizant) 1 Reputation point

Hi All, We are loading data from BLOB storage using synapse POLYBASE. We have a scenario, where the new line characters are ignored while loading the data. instead of having it as new line, the polybase appends the data with the previous texts. This is causing a huge problem in downstreams. is there a solution where we can load the data AS IS in the source. (with new line / with vertical tab). Any inputs would be highly appreciated. !!! Thanks in advance

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,818 questions
{count} votes