question

HeinrichBreedt-0225 avatar image
0 Votes"
HeinrichBreedt-0225 asked NWiddup-MSFT answered

Synapse csv sink quote only text fields

When I create a csv sink to output the datalake I only seem to have the option "quote all". Either everything is quoted or nothing. Is there a way to only quote text fields?

fasttrack-azure
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NWiddup-MSFT avatar image
0 Votes"
NWiddup-MSFT answered

Hi Heinrich, Thanks for your time on the call the other week. As discussed, at this point you do not have the option to choose which columns you encapsulate in quotes.
However, also as discussed, I will submit this feedback on your behalf to the product team & see whether we could get an option through the import schema interface to selectively choose to only quote single columns.
Thanks
Nathan

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.