Azure Data Explorer dashboards is a powerful tool for visualizing and exploring data. With the new feature, users can now seamlessly switch between multiple data sources within the same dashboard, making it easier to move between different Azure Data Explorer databases, gain insights and make data driven decisions.
How does the data source parameter capability work?
The parameter is defined in the query, and its value is determined by the user via a drop-down list. This means that users can easily switch between data sources without having to create separate queries or dashboards.
Benefits of data source parameters:
Cross region deployments – in regional deployments using data source parameters can help in viewing the same dashboards for different regions.
Multi-tenant use cases – when using multiple clusters for hosting customers, it helps if you can create one dashboard to monitor all cluster and filter the data by a Data-source.
Recently we added support for Plotly graphing library. You can render your data as a Plotly visual and use its power, diversity and advanced properties.
For more details on how to leverage Plotly visuals with Python and even without, you can read this blog post.
IntelliSense in ADX web UI has recently received updates to enhance its functionality and usability. The updates include:
Intuitive ordering of the completion list (alphabetically of course, columns first, followed by functions).
Ctrl + Enter adds new line and a pipe.
Several bug fixes, for example show syntax errors for the selected query only and show functions descriptions.
Additionally, the IntelliSense feature now supports easy access to inline help. For example:
Note that if you close the inline help (using the x at the upper right corner) it will collapse until the next time you expand it.
Did you know?
For a faster, smoother Intellisense experience, you can turn on a setting to automatically trigger a new completion list right after a selection was made in the current one.
Look for Trigger IntelliSense right after previous IntelliSense option selected in Settings à Appearance.
View cluster history
.show queries and .show commands-and-queries are useful commands that allow you to view admin commands and queries that have reached a final state. With the recent addition of a new feature, it's now easier to track the history of queries and commands run on a Kusto cluster.
To access (and then run) the set of KQL statements that will let you view the cluster history, just right click the cluster name in the connection pane, and select ‘View history’. A new query tab will be opened with the relevant statements.