Forum Discussion
Query an external CSV file
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 Replies
- 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/publicfreeclusterHi 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
