Query an external CSV file

[gsingh_]

Hi, I am trying to query an external CSV file via KQL using externaldata() operator.

As a POC, I created a test storage account with a simple container and then uploaded a CSV file to it. I am using a SAS token & URL to fetch the data.

When I run the query it gives an error:

"Some aspects of the query had errors so the results are not complete
If the issue persists, please open a support ticket. Request id: *****"

Any pointers on what could be the possible issue here?

thanks

[#2]

Its hard to help without seeing the query used. I will say though if I have issues, I tend to use Azure Data Explorer (free cluster) to run the same command, as I often find that the error returned are more detailed)

https://dataexplorer.azure.com/publicfreecluster

[#3]

Hi @Clive_Watson , I am trying with the below command:

externaldata (columnA:string, columnB:string)
[@"https://BLOB SAS URL?BLOB SAS Token]
with(format="csv")

thanks