KQL datatable generator
A tool for generating Kusto Query Language (KQL) datatables, based on an existing variable generator.
Wilko van de Velde is a cloud data specialist focused on Azure Data Explorer, KQL, analytics, and IoT solutions. He shares practical guidance on organizing, documenting, and optimizing KQL, as well as building scalable data and digital twin architectures on Azure.
10 articles from this blog
A tool for generating Kusto Query Language (KQL) datatables, based on an existing variable generator.
A guide on documenting and organizing Kusto Query Language (KQL) code using comments, docstrings, and folders for better maintainability.
Explains how to integrate Azure Digital Twins into an existing IoT solution for enhanced device modeling, insights, and control.
A guide to installing and using LightIngest on Ubuntu for data ingestion into Azure Data Explorer, including managed identity authentication.
Explains how to implement backup and restore for Azure Data Explorer using continuous export to Azure Storage as a disaster recovery solution.
Announcing a free in-person workshop on Azure IoT basics, dashboarding, and data exploration using Azure IoT Hub and Data Explorer at the BitBash event.
Explores using Kusto update policies in Azure Data Explorer to implement Change Data Capture (CDC) for IoT data streams, as an alternative to Azure Functions.
Explores methods for handling Change Data Capture (CDC) patterns from IoT devices within Azure Data Explorer for data analysis.
A guide to implementing Attribute-Based Access Control (ABAC) for fine-grained authorization in Azure Storage Accounts.
Using Azure Data Explorer's geo_info_from_ip_address function to locate a hacker by mapping IP addresses on a scatter plot map.