ADX Web updates – Jan 2024
Introducing Data Profile
We are extremely pleased to introduce the new Data Profile feature.
Whether you’re a seasoned KQL writer or new to the language, our Data Profile feature is designed with you in mind. For KQL experts, it provides quick access to schema details and column statistics, enhancing query writing efficiency.
If you’re new to the language, use this feature as a steppingstone, to quickly gain basic insights and build confidence on your journey to becoming a proficient query writer.
Data Profile features (1) dynamic time chart showcasing data distribution based on ingestion time (or your chosen datetime field), alongside a comprehensive display of each table (2) columns with key statistics. For each column, there is a (3) display of top values.
View query of a dashboard tile
We’ve been actively listening to your feedback, and today, we’re thrilled to introduce a new experience for viewing a dashboard tile’s underlying KQL query without disrupting your workflow.
This enhancement directly addresses long-standing requests:
Effortless query viewing
Now, you can view the query (read-only) right from the dashboard without the need to navigate away, preserving your valuable context.
Query tab management made easy
No more creating new query tabs each time you explore a tile’s query. Our update ensures a streamlined experience, optimizing your dashboard navigation.
Base query
A very common use case is to build and maintain dashboards where numerous tiles draw insights from the same tables and parameters. Traditionally, each tile’s query starts from scratch, redundantly repeating query snippets. Not only is this process time-consuming, but it also invites inconsistencies across tiles.
With Base Queries, you can create query snippets and define them as foundational elements within the context of a single dashboard – Base queries.
Such a base query can be used to power the dashboard’s parameters, tiles and other base queries.
To learn more about base queries, please go to the announcement here – Introducing Dashboards Base Queries: Enhancing Productivity and Consistency – Microsoft Community Hub
Or read the docs here – https://learn.microsoft.com/en-us/azure/data-explorer/base-query
Azure Data Explorer Web UI team is looking forward for your feedback in KustoWebExpFeedback@service.microsoft.com
You’re also welcome to add more ideas and vote for them here – https://aka.ms/adx.ideas
Read more:
ADX Web Aug updates – ADX Web UI updates – August 2023 – Microsoft Community Hub
Base queries announcement – Introducing Dashboards Base Queries: Enhancing Productivity and Consistency – Microsoft Community Hub
Microsoft Tech Community – Latest Blogs –Read More