Save the Kusto query result into a table

Question

Save the Kusto query result into a temp table and then do a swap..

Answer 1

you could look into using .set-or-replace (or a combination of .set-or-append and .rename tables)

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