Synapse csv sink quote only text fields

Heinrich Breedt 1 Reputation point
2022-03-15T22:15:24.243+00:00

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?

Azure FastTrack
Azure FastTrack
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.FastTrack: This tag is no longer in use. Please use 'Azure Startups' instead.
75 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. NWiddup-msft 1 Reputation point Microsoft Employee
    2022-03-31T04:29:38.473+00:00

    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

    0 comments No comments