Using server-side export to pull data
A very common pattern used in databases is to perform a query that writes its results to another table. In KQL, this pattern is called Ingest from Query. There are four KQL control commands that support Ingest from Query in Data Explorer pools:
.set
: This command can be used only if the destination table, that is, the table that will receive the data from a query result, doesn’t yet exist. If it does exist, the command fails..append
: Produces the opposite of the.set
command. If the destination table doesn’t yet exist, the command fails. If the table already exists, it appends the query results to the destination table..set-or-append
: This command combines the.set
and.append
commands. If the destination table exists, data is appended to the table. If it doesn’t, the table is created and data is ingested..set-or-replace
: Similar to.set-or-append
except that if the destination table already exists, the...