azure-data-explorerkqlkusto-exploreradx

How to insert current timestamp value into kusto table using inline command


I am trying to insert current timestamp value into KUSTO table using now(), its not working as the inline command doesn't support functions or variables. Is there any way I can insert current timestamp value into KUSTO table.


Solution

  • Inline functions doesn't support functions and variables. You can use .set-or-append command.

    If table doesn't exists then .set-or-append command will create a table and insert the data else it will append the data to the existing table.

    Sample Query

    .set-or-append  myTable <| print  data = todatetime(now())
    

    Result

    enter image description here