CODEWITHSUNDEEP
azure-data-explorerkqlkusto-explorer
Jerald Baker
Jerald Baker

Reputation: 1359

Kusto - How to put results into another table in another cluster?

Suppose I have a table, I run a query like below :-

let data = orders | where zip == "11413" | project timestamp, name, amount ; inject data into newOrdersInfoTable in another cluster // ==> How can i achieve this?

Upvotes: 1

Views: 2609

Answers (1)

Avnera
Avnera

Reputation: 7608

There are many ways to do it. If it is a manual task and with not too much data you can simply do something like this in the target cluster:

.set-or-append TargetTable <| cluster("put here the source cluster url").database("put here the source database").orders 
| where zip == "11413" | project timestamp, name, amount

Note that if the dataset is larger you can use the "async" flavor of this command. If the data size is bigger then you should consider exporting the data and importing it to the other cluster.

Upvotes: 2

Related Questions