Error escaping backslash from SQL database to CSV Blob Storage

Vincent Kim 1 Reputation point
2022-09-12T23:37:02.397+00:00

External organization's SQL Database has set up a Data Share with our organization, which we receive and map to a CSV in Blob Storage.
They have a field that is a single backslash, which is incorrectly escaped when it is turned to a CSV through Data Share.

Source SQL table:
Column A: \
Column B: Foo
Column C: Bar

CSV file we receive when we trigger a Snapshot:
""",Foo""","Bar"

When read by any CSV parser, this results in:
Column A: ",Foo"
Column B: Bar
Column C:

CSV file as it SHOULD be:
"\","Foo","Bar"

Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
43 questions
Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,414 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Takahito Iwasa 4,841 Reputation points MVP
    2022-09-13T08:01:43.207+00:00

    Hi, @Vincent Kim

    When I confirmed that the snapshot was acquired in CSV format to the storage with Data File, it was acquired with the following contents. 

       ColumnA,ColumnB,ColumnC  
   "\","Foo","Bar"

    Please review the steps again.
    I will also organize the procedure and guide you with additional information.