Forum Discussion

Copper Contributor

May 22, 2024

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...

Log Data

Clive_Watson

Bronze Contributor

May 24, 2024

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

gsingh_

Copper Contributor

May 25, 2024

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