How to add dynamic data into a table using ‘.ingest inline into table’ command

This post has been republished via RSS; it originally appeared at: Azure Data Explorer articles.

Let's start with table definition 

 

.create table ExpensiveKustoQueries_Test (User: string, TimeStamp: datetime, CpuTime: timespan) 

Now Ingestion with dynamic Value 

 

 

.set-or-append ExpensiveKustoQueries_Test <| print User = "xx@Kusto.com", Timestamp = now(),CpuTime = totimespan("06:48:02.2656250")

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.