'Paging on ADX table. how to skip the records in kusto query language

I want to implement paging on ADX table (kql) like offset, fetch next some rows only we generally do in SQL Server, but I am unable to skip/offset option in kusto query lang. is there any alternative to achieve paging on ADX table records.

Please provide an alternative solution for applying paging on ADX Table records without using row_number().

we have | take or | limit options, looking for an option that skips the records.

azurekqladx


Solution 1:[1]

You could look at the example in the documentation, using stored query results: https://docs.microsoft.com/en-us/azure/data-explorer/kusto/management/stored-query-results#pagination

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Yoni L.

Related Questions