Error escaping backslash from SQL database to CSV Blob Storage

Question

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"

Answer 1

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.