Site icon TheWindowsUpdate.com

ADX Web UI updates – January 2023

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.

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.

 

 

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:

 

For more information read this - https://learn.microsoft.com/en-us/azure/data-explorer/dashboard-parameters#use-the-data-source-parameter

 

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:

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:

Exit mobile version