Hello,
There is a file, test.csv in the container.
In the synapse studio, I right click on this file which is in the blobstorage, and select the top 100 and it generates the automated sql to execute to read the data inside it.
When the automated openrowset query is executed, it does show the data but the csv headers are in the second row and in the first row I see C1, C2, C3, etc.
Do you know how to remove those unwanted C1, C2, C3, etc. headings?
Thank you