Inserting data in KQL

Question

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?

Answer 1

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.