Forum Discussion

gsingh_'s avatar
gsingh_
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's avatar
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_'s avatar
    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