Implementation of Update Policy

Bexy Morgan 260 Reputation points
2023-07-26T20:29:33.62+00:00

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)

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
547 questions
0 comments No comments
{count} votes

Accepted answer
  1. Wilko van de Velde 2,226 Reputation points
    2023-07-27T06:14:08.59+00:00

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.