Category "kql"

How to calculate time grain based on selected period from azure dashboard in a custom chart

While writing a kusto query to create a custom chart on my azure dashboard, I want to be able to calculate the time grain based on the period the user selected

How to get only distinct values from list

What I have: A datasource with a string column, let's call it "name". There are more, but those are not relevant to the question. The "name" column in the conte

SQL OLAP vs KQL || row_number() over partition by in SQL vs KQL

I have OLAP Query in SQL and requirement is same query result need to fetch in ADX(Azure Data explorer) using KQL. I'm new to KQL and trying to convert same SQL

How query data use offset in kusto (Azure Data Explorer) KQL for paging

How can I realize below SQL query use offset for paging query in KQL. select * from testtable where code = '88580' limit 1000 offset 111 I can't find any funct

Insert data into kusto table using flow

Can we insert data into kusto table using flow? I tried to insert data into kusto table using .ingest inline command but it throws a bad request error shown be

Consider the where condition based on the parameter value in KQL

I'm using Azure Log Analytics. //Below is the Log Analytics Function (e.g Function Name is "TestFunction")SynapseIntegrationPipelineRuns | where Level == Level

Excel removes my query connection on it's own and gives me several error messages

I know that this is a really long post but I'm not sure of what part of my process is making my file crash, so I tried to detail everything about what I did to

Kusto for sliding window

I am new to Kusto Query language. Requirement is to alert when the continuous 15 minute value of machine status is 1. I have two columns with column1:(timestamp

Convert query to KQL

I have an application that contains an object. It has 2 guid values, guid1 and guid2. At any given time only 1 is populated. Firstly guid1 and at a later point

Does materialize function not work with tabular function argument in Kusto?

I created a simple function MaterializeRemoteInputTable below which accepts the output of a table as an input. To test if the input is materialized, I am using

Kusto make-series by month

I'm really struggling to figure out how to use the Kusto make-series function but output the results by month. The current example below is set to 1d (i.e. 1 da

How to remove time part from a datetime in Kusto

If I've got a Kusto datetime and I want to remove the time portion, leaving just a date at midnight, what's the best way? I can do this todatetime(format_dateti