Azure Data Explorer-Use scalar input as column name argument in extend operator in a user-defined function Dynamic Column Names in Azure Data Explorer Using Scalar Inputs with the extend Operator Azure Data Explorer ADX is a powerful tool for analyzing data at scale 2 min read 06-10-2024 9
Is it possible to update rows in Azure Data Explorer (Kusto) Updating Data in Azure Data Explorer Kusto A Deep Dive Azure Data Explorer Kusto is a powerful data exploration and analysis platform that excels at ingesting a 2 min read 06-10-2024 4
Azure Data Explorer C# querying and ORM Unleashing the Power of Azure Data Explorer with C and ORMs Azure Data Explorer ADX is a powerful scalable and highly efficient data analytics platform Its abil 3 min read 06-10-2024 9
Build a tree / run recursive query in Kusto Azure Data Explorer Building a Tree and Running Recursive Queries in Kusto Azure Data Explorer Kusto Azure Data Explorer is a powerful query language and data exploration tool One 3 min read 06-10-2024 11
Print custom message when there is no data in table return by kusto query No Data No Problem Displaying Custom Messages in Kusto Queries Kusto queries are incredibly powerful for extracting insights from your data However sometimes yo 2 min read 05-10-2024 13
Where do Kusto dashboard definitions live Where Do Kusto Dashboard Definitions Live Unlocking Your Azure Data Explorer Visualizations Kusto also known as Azure Data Explorer is a powerful data analytics 2 min read 05-10-2024 4
ADX Kusto how to merge two large tables Merging Two Large Tables in Azure Data Explorer Kusto When working with big data in Azure Data Explorer ADX you may often find yourself needing to combine infor 3 min read 30-09-2024 12
Microsoft Fabric Eventhouse Azure Blob JSON Sync Strange Behavior Understanding the Strange Behavior of Microsoft Fabric Eventhouse Azure Blob JSON Sync In the realm of cloud computing Microsoft Fabric has become a cornerstone 2 min read 28-09-2024 8
"requests.exceptions.HTTPError: 400 Client Error: BadRequest for url" when querying an Azure Data Explorer table Resolving the requests exceptions HTTP Error 400 Client Error Bad Request for url Error in Azure Data Explorer Queries When querying Azure Data Explorer tables 2 min read 27-09-2024 12
Grafana - Combining Azure Data Explorer Datasource with a static source Grafana Combining Azure Data Explorer Datasource with a Static Source In the world of data visualization and monitoring Grafana stands out as a powerful tool th 3 min read 25-09-2024 15
Kusto query for time between records by group in one result list Kusto Query Finding Time Between Records by Group When working with Kusto Query Language KQL one common task is to analyze time intervals between records within 2 min read 20-09-2024 15
Fluent Bit JSON to Kusto ingestion: All fields mapped to log column instead of respective columns Fluent Bit JSON to Kusto Ingestion Mapping Fields to Columns Correctly In the realm of data ingestion Fluent Bit is a versatile and powerful tool used to collec 3 min read 17-09-2024 25
Generate Chart by Type and State Generating Charts by Type and State A Comprehensive Guide When working with data visualization one common requirement is to generate charts based on different t 2 min read 14-09-2024 25
Create a function to calculate power of tens with a loop and reuse them in another query Creating a Function to Calculate Powers of Ten In programming one of the common tasks is to compute powers of numbers efficiently For instance calculating power 2 min read 14-09-2024 25
Kusto: Query execution has exceeded the allowed limits (80DA0003): Kusto Tackling Query Execution Has Exceeded the Allowed Limits 80 DA 0003 This article dives into a common issue encountered in Kusto queries the dreaded Query 3 min read 05-09-2024 12
KustoIngestFactory fails to load dependent assembly at runtime with FileNotFoundException Kusto Ingest Factory File Not Found Exception Troubleshooting and Workarounds This article delves into a common issue encountered when using the Microsoft Azure 2 min read 02-09-2024 9
Union the results with loop to call function for each table row Dynamically Unioning Results in Azure Data Explorer Kusto with Looping This article explores how to dynamically union results from a Kusto function by iterating 2 min read 02-09-2024 14
Azure Virtual Desktop KQL (Kusto) query Diving Deep into Azure Virtual Desktop User Metrics with KQL Azure Virtual Desktop AVD provides a powerful platform for delivering virtual desktops and applicat 2 min read 01-09-2024 18
KQL: How to reference columns within a let query in the next query KQL Referencing Columns from a let Query in the Next Query In KQL Kusto Query Language let statements allow you to define reusable queries or variables This is 3 min read 31-08-2024 14
KQL : How to take the query result by batch? KQL Batch Processing Breaking Down Large Result Sets Working with large datasets in KQL can be computationally expensive and difficult to manage Often its more 2 min read 31-08-2024 18
KQL - extract property value from an array of JSON objects, based on the value of another property Extracting Property Values from JSON Arrays in KQL A Comprehensive Guide This article explores a common challenge in KQL extracting specific property values fro 2 min read 29-08-2024 38
Cache the result of a scalar function during query execution in Azure Data Explorer Caching Scalar Functions in Azure Data Explorer for Enhanced Query Performance Azure Data Explorer ADX is a powerful data exploration service that provides effi 2 min read 29-08-2024 22
Kusto - fetch data from one table where matching records do not exist in another table Identifying Inactive Users in Azure Data Explorer A Kusto Query Guide This article provides a comprehensive guide to identifying users who havent sent a heartbe 2 min read 29-08-2024 12
Adding external delta table in Kusto does not work, table too big? Overcoming the Table Too Big Error When Adding External Delta Tables to Azure Data Explorer Azure Data Explorer ADX is a powerful tool for analyzing massive dat 2 min read 28-08-2024 14
Kusto multiple summarize in single query Combining Multiple Summarizations in a Single Kusto Query A Comprehensive Guide Kusto Query Language KQL is a powerful tool for analyzing data in Azure Data Exp 2 min read 28-08-2024 23