CODEWITHSUNDEEP
kqlazure-data-explorerkusto-explorer
superninja
superninja

Reputation: 3401

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"

Upvotes: 1

Views: 1355

Answers (1)

Yoni L.
Yoni L.

Reputation: 25895

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.

Upvotes: 3

Related Questions