ADX Web UI updates – January 2023
Published Jan 31 2023 10:23 PM 2,068 Views
Microsoft

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:

  1. Amazon S3 support in Ingestion Hub
  2. Data source parameters (Dashboards)
  3. Plotly visuals support
  4. KQL IntelliSense improvements
  5. 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:

  1. Source type: Amazon S3
  2. 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.

  1. Filter extension: filter the file type based on the suffix e,g, .csv, .json etc.

Michal_Bar_0-1675232214693.png

 

 

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.

Michal_Bar_1-1675232214702.png

 

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.

Michal_Bar_2-1675232214717.png

 

 

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:

Michal_Bar_3-1675232214726.png

 

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.

Michal_Bar_4-1675232214726.png

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.

Michal_Bar_5-1675232214728.png

 

 

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:

Co-Authors
Version history
Last update:
‎Jan 31 2023 10:27 PM
Updated by: