I have a kusto query that have two columns as shown below & size column is in Giga bytes

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]

I am attempting to join the processName of the first table into the event log output:

I would like to restrict viewer permissions of a specific Security Group to all database objects except few functions. In other words, the members of that one security Group should be only able to seeexecute 10 functions. Should not be able to directly query the table(s) schema.

I hope you can help me. That problem makes me crazy…
Given a table, which shows the booked services of devices. There is a new entry per device, if the booked services changed.

I have a dynamic list of strings that I want to compare with a value of a column in main_table. I want to make sure all the parts from this list match my column.