247 votesstarted · 29 comments · Azure Synapse Analytics » SQL/Loading · Flag idea as inappropriate… · Admin →
An error occurred while saving the commentCharlie Cook commented
Voting for this as well. Scenarios where a text input file has tabs, newlines, embedded double quotes all should be able to be handled by having double quotes around the field. This type of file is processed fine by say Excel, but not by polybase / ADW external tables. This makes it impossible to simply ingest data into ADLA and put polybase external tables on them if there is any data from text fields that may be user entered comments for instance.
232 votesstarted · 26 comments · Azure Synapse Analytics » SQL/Loading · Flag idea as inappropriate… · Admin →