Forum Discussion
Kusto Direct Query - Pagination
Hello, I have a need to display millions of records using Kusto connected by Direct Query. Is there a way to implement pagination - where each page makes a kusto call to get restricted record cou...
Hi Anonymous ,
I have some suggestions for you:
1.Use the take operator:
Take operator allows you to retrieve a specified number of rows from the query results. It is useful for interactively viewing a small sample of rows.
2.Stored query results:
Kusto supports storing query results in tables. You can use this feature for paging
Below is the official link will help you:
take operator - Azure Data Explorer & Real-Time Analytics | Microsoft Learn
Stored query results - Azure Data Explorer & Real-Time Analytics | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.