It's possible to use Kusto .set-or-append command to copy table between clusters.

Question

I'm trying to figure out a direct approach to copy multiple tables between 2 Kusto clusters. One option I have used in the past is to copy the data to cloud storage and then ingest that data into the new table in the secondary cluster. But I would like to know if by using the '.set-or-append' I can directly ingest data from the primary cluster into the secondary cluster without the need of cloud storage.

Answer 1

Hi Jose Gonzalez Gongora Welcome to Microsoft Q&A forum and posting your query.

You can try using cross-cluster queries to perform this:

.set-or-append NewTable <| cluster("<ClusterName>").database("<DatabaseName>").<TableInOtherCluster>

Note:  Please note you might need to split your data in order to achieve this without performance issues, depending on how large the table is.

Hope this info helps.

---Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.