Kusto Detective Agency, Season 2, Onboarding

It's time for season 2 of Kusto Detective Agency, a fun way to test and hone your Kusto Query Language (KQL) skills! The first mission of season 2 (Onboarding) asks you to find the id of the detective that earned the most money in 2022, based on the data present in the DetectiveCases table. After …

Continue reading Kusto Detective Agency, Season 2, Onboarding

Search in all tables and columns in Kusto / Azure Data Explorer

Say you have a piece of information from the telemetry of your services. You'd like to know more about the data it references, but you don't know exactly where it fits in the schema. Maybe it's an operation id, a correlation id, a GUID, or something else. It might be the entire value of a …

Continue reading Search in all tables and columns in Kusto / Azure Data Explorer