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
Synapse Polybase ignores new line charater
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 93%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
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
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 21,191 Reputation points Microsoft Employee2021-02-18T20:21:26.86+00:00 @Somu, Darthick (Cognizant) Thanks for using Microsoft Q&A !!
Is it a CSV file ? Can you please share sample data against which you are seeing this behavior ? -
Saurabh Sharma 21,191 Reputation points Microsoft Employee
2021-02-22T17:18:19.367+00:00 @Somu, Darthick (Cognizant) Following up as I have not heard back from you.
-
Saurabh Sharma 21,191 Reputation points Microsoft Employee
2021-02-24T15:55:01.307+00:00 @Somu, Darthick (Cognizant) Did you get a chance to look into my previous ask.
Sign in to comment