.set-or-append command Log in Kusto

ADX 156 Reputation points
2021-12-16T04:21:58.403+00:00

Hi

I have a query like below.

.set-or-append async Test with(distributed=true) <|
stg_test

when i am running the above query thorigh Azure Data Explorer command activity from ADF pipeline the data is appending but in the output of activity it is showing only the status(completed) but how would i know how many records are appended in the Test table.

Appreciate your help on this.

Thanks,

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
503 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,321 Reputation points Microsoft Employee
    2021-12-20T09:52:23.673+00:00

    Hi @ADX ,

    Thank you for posting query in Microsoft Q& A Platform.

    Azure Data explorer command activity will simply run your passed commands and returns output of your query command in to activity output.

    In your case your command is not returning data related to how many records are appended in the table. Hence you are not seeing them in the activity output.

    Kindly make sure your query command returns the values what you are expecting in Activity output.

    Click here to know more about Azure data explorer command activity.

    Hope this will help. Please let us know if any queries further.

    --------------

    Please consider hitting Accept Answer. Accepted answers helps community as well.