Kusto Queries and GraphQL
25/02/2023 11:23
I've been using GraphQL and Kusto language on Postman project limiting the number of records:
{
"query": "customEvents | where timestamp > (datetime('2023-01-01T00:00:00+00:00')) | top 1500 by timestamp asc"
}
Between:
{
"query": "customEvents | where timestamp between(datetime('2023-02-20T06:30:00+00:00') .. datetime('2023-02-20T06:40:00+00:00')) "
}
Selecting the fields:
{
"query": "customEvents | where timestamp > (datetime('2023-01-30T04:30:00+00:00')) | project timestamp"
}
That Kusto language provide very powerful functions for queries that were very relevant for my development, so, I'm sharing with the team in case of anyone needs it in the future:
https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/samples?pivots=azuredataexplorer
Samples for Kusto Queries - Azure Data Explorer
Learn how to use Kusto Query Language to accomplish specific scenarios.