azurekql

Inserting data in KQL

I have a table that I created using KQL. Now I want to populate it by inserting values inside but could not get the exact syntax. How to insert data in my table in KQL syntax?

Solution

  • https://learn.microsoft.com/en-us/azure/kusto/management/data-ingestion/ingest-inline

    .ingest inline into table Purchases <|
Shoes,1000
Wide Shoes,50
"Coats, black",20
"Coats with ""quotes""",5

    I assume that you know that single row ingests are usually not the way to ingest data into Azure Data Explorer.