kqlazure-data-explorerkusto-explorer

Append New Row to Kusto Table


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"


Solution

  • 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.