0

I have an Excel file people use to edit data outside Azure Data Explorer (Kusto). What is the Kusto code I would use to ingest this data as needed into Kusto query?

So far it seems I need to use:

.create table (Name:type, Name:type)

to create a table.

If my CSV file is stored in OneDrive, what is the syntax to fill the table? Assume the file name is Sample.csv.

user2151027
  • 203
  • 1
  • 3
  • 5

1 Answers1

2

OneDrive location is not supported directly by Azure Data Explorer. However there are other options:

  1. Using ingestion commands - you will need to place the files first in Azure Storage.
  2. One Click Ingestion - is a feature of the Web Explorer tool, it will also can create the table for you. you can either download the files to your local computer or place it in Azure storage.
  3. Using Import data from local file feature of Kusto Explorer (Windows client) (only works for local files)
Avnera
  • 7,088
  • 9
  • 14