Append New Row to Kusto Table

Question

I want to manually add a new row to kusto table called "StudentTable". I was wondering what's the syntax? Assuming the table already exists and has column names of StudentID and StudentName

The documentation doesn't have any instruction: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/data-ingestion/ingest-from-query

Would this be the syntax? .append async StudentTable <| StudentID = "12345", StudentName = "John Doe"

Answer 1

you're missing the print operator.

.append StudentTable <| print StudentID = "12345", StudentName = "John Doe"

another options is to use the .ingest inline command.

e.g.: .ingest inline into table StudentTable <|12345,John Doe

NOTE that ingesting single records using either of the options above isn't recommended for frequent operations in Production environments.

• you can use streaming ingestion for scenarios in which data 'trickles' infrequently and in small volumes.