Help on Kusto runtime output to local csv.

[KalyanKakumanu]

Hi All,

I'm trying to generate runtime Kusto query output to local CSV file on my desktop using the below syntax but the desired output is not seen in the file.

.export async compressed to csv (h@"C:\\\\TestExport.csv") with (includeHeaders="all")

<| Table

Kindly help with steps to copy query output more than 500000 rows to CSV output as the Kusto Query output doesn't scale more than 500000 rows output in output window.

[#2]

I would export the data directly to a storage account using this link. 

The problem you are facing is due to the limitation of the UI and the result set in the window.

With the above approach you can store the data to a csv file and then download the csv from the storage account once it has completed.

In this way you are also not dependent on your own internet connection to generate the file.

I hope you succeed with the task.