azure-data-explorer

DORSETRIGS

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

Azure Data Explorer-Use scalar input as column name argument in extend operator in a user-defined function

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

Is it possible to update rows in Azure Data Explorer (Kusto)

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

Azure Data Explorer C# querying and ORM

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

Build a tree / run recursive query in Kusto Azure Data Explorer

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

Print custom message when there is no data in table return by kusto query

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

Where do Kusto dashboard definitions live

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

ADX Kusto how to merge two large tables

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

Microsoft Fabric Eventhouse Azure Blob JSON Sync Strange Behavior

"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

"requests.exceptions.HTTPError: 400 Client Error: BadRequest for url" when querying an Azure Data Explorer table

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

Grafana - Combining Azure Data Explorer Datasource with a static source

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

Kusto query for time between records by group in one result list

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

Fluent Bit JSON to Kusto ingestion: All fields mapped to log column instead of respective columns

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

Generate Chart by Type and State

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

Create a function to calculate power of tens with a loop and reuse them in another query

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

Kusto: Query execution has exceeded the allowed limits (80DA0003):

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

KustoIngestFactory fails to load dependent assembly at runtime with FileNotFoundException

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

Union the results with loop to call function for each table row

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

Azure Virtual Desktop KQL (Kusto) query

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

KQL: How to reference columns within a let query in the next query

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

KQL : How to take the query result by batch?

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

KQL - extract property value from an array of JSON objects, based on the value of another property

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

Cache the result of a scalar function during query execution in Azure Data Explorer

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

Kusto - fetch data from one table where matching records do not exist in another table

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

Adding external delta table in Kusto does not work, table too big?

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

Kusto multiple summarize in single query