Happy New Year everyone! 2023 has arrived and it's time for our first monthly update on the latest and greatest in the world of ADX Web UI.
Continue reading to learn more about:
- Amazon S3 support in Ingestion Hub
- Data source parameters (Dashboards)
- Plotly visuals support
- KQL IntelliSense improvements
- View cluster history
Amazon S3 support in Ingestion Hub
Now you can Ingest data from Amazon S3 seamless via the Ingestion Hub in KWE.
The Ingestion flow can be completed with following selection:
- Source type: Amazon S3
- Link to Source: Enter the connection string of a bucket / object. Learn more
Please use the following S3 url format:
https://<bucket_name>.s3.<region_name>.amazonaws.com/<object_name>;AwsCredentials={ACCESS_KEY_ID},{SECRET_ACCESS_KEY}
You can ingest individual S3 objects or up to 10000 files from an S3 bucket.
- Filter extension: filter the file type based on the suffix e,g, .csv, .json etc.
Please give it a try - https://dataexplorer.azure.com/oneclick/ingest?sourceType=amazons3
Data source parameters in ADX dashboards
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.
For more information read this - https://learn.microsoft.com/en-us/azure/data-explorer/dashboard-parameters#use-the-data-source-param...
Plotly visuals support
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 improvements
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.
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 UI December updates - ADX Web Explorer updates – December 2022 - Microsoft Community Hub