CODEWITHSUNDEEP
azure-data-explorerkql
Brahmaiah Takkellapati
Brahmaiah Takkellapati

Reputation: 141

How to copy a table from one database to another database in same ADX Cluster

I want to copy table from One database to another database in same ADX (Azure Data Explorer) cluster.

From Microsoft document I could see table copy available within same database using below commands.

.set, .append, .set-or-append, .set-or-replace

https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/data-ingestion/ingest-from-query

I am looking for a table copy from one database to another database in same ADX Cluster. How can I achieve this?

Upvotes: 3

Views: 2544

Answers (1)

Avnera
Avnera

Reputation: 7608

You can use the database() function for example:

.set Table <| database("myOtherDatabase").Table

Upvotes: 5

Related Questions