The update policy is explained in MS Learn:
https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/updatepolicy
Or check out this blog:
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Objective: KQL query to send the records from SourceTable to targetTable_1 if Revenue < 200 & to send the records from SourceTable to targetTable_2 if Revenue >= 200
-> sourceTable, targetTable_1 and targetTable_2 can be create using below queries.
////////////////////////////////////////////////////////////////////////////////////
Source Table:
.create table sourceTable (EventName: string, Revenue: int, Loc: string)
.ingest inline into table sourceTable <|
"v1", 100, "ASD"
"v2", 120, "QWE"
"v3", 130, "SDDV"
"v4", 140, "DAFB"
"v5", 1880,"DVB"
"v6", 10, "DD"
"v7", 9900, "FR"
"v8", 1001, "DFB"
////////////////////////////////////////////////////////////////////////////////////
Target Tables:
-> .create table targetTable_1(Revenue: int, Loc: string)
-> .create table targetTable_2(Revenue: int, Loc: string)
The update policy is explained in MS Learn:
https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/updatepolicy
Or check out this blog: