cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Data Explorer Blog
Options
892

A Step-by-Step Guide to migrate data from Elasticsearch to Azure Data Explorer(ADX) using Logstash

Bhaskar on Feb 02 2023 10:17 AM
Data migration is the process of transferring data from one source to another. It can be a complex and time-consuming ta...
768

ADX Web UI updates – January 2023

Michal_Bar on Jan 31 2023 10:23 PM
Happy New Year everyone! 2023 has arrived and it's time for our first monthly update on the latest and greatest in the w...
669

Cross highlight when using direct query in PBI

DanyHoter on Jan 25 2023 05:09 AM
The default behavior of Power BI is that every visual can filter any other visual. This is fine when the model is using ...
1,760

Plotly visualizations in Azure Data Explorer

adieldar on Jan 17 2023 05:22 AM
We extend the set of ADX visualizations, supporting advanced interactive visualizations by Plotly graphics library. Plot...
1,566

Observability using ADX

Charitha_Basani on Jan 08 2023 05:58 PM
The customers are looking for cost effective tools for enterprise monitoring initiatives of their tech infrastructure. W...
1,508

Announcing Cosmos DB to Azure Data Explorer Synapse Link (public preview)

vplauzon on Jan 04 2023 04:31 PM
Learn about the new Cosmos DB connection in Azure Data Explorer and how it can help improve your data solutions!
1,839

Getting started with Apache Log4j and Azure Data Explorer

tanmayapanda on Jan 02 2023 03:16 AM
In this blog post, we'll explore how to set up Log4j2-ADX connector to send log data to ADX.
2,229

ADX Web UI updates – December 2022

Michal_Bar on Dec 28 2022 04:12 AM
Welcome to the last monthly update of 2022!
1,279

Find my partner

cosh23 on Dec 20 2022 12:14 PM
News on partners! We are shifting gears and publish an initial list of 20+ diverse partners which have a proven track re...
1,359

Ingest streaming data using Azure Event Hub and Azure Databricks

Timothy_Brown on Dec 20 2022 08:31 AM
Do you have the need to ingest streaming data into ADX from Azure Event Hub and Azure Databricks? In this blog, I walk y...
2,449

Azure Stream Analytics no-code editor for ADX

Guy_Reginiano on Dec 14 2022 07:08 AM
No-code editor to easily create an ASA job - read from Event Hubs, filter/join the data, and write to ADX.
1,459

Ingest preexisting Event Hub events to ADX

Guy_Reginiano on Dec 11 2022 03:59 PM
Event Hub data that existed before the creation of an ADX data connection can now be ingested
1,740

To Star or not to Star, More about data modeling in Power BI using ADX

DanyHoter on Dec 05 2022 04:20 AM
Additional recommendations about best practices when using PBI to access data from ADX
2,962

Multivariate Anomaly Detection in Azure Data Explorer

adieldar on Dec 04 2022 09:49 AM
ADX contains native support for detecting anomalies over multiple time series by using the function series_decompose_ano...
2,040

Timeline visualization - one way of using the powerful Time Pivot chart (Kusto Explorer)

Michal_Bar on Dec 01 2022 03:32 AM
This blog post is written by Chango Valtchev, an avid ADX user, sharing his experience with Time Pivot (aka timeline) ch...
1,671

ADX Web updates – November 2022

Michal_Bar on Nov 30 2022 06:49 AM
Improvements and new capabilities in dashboards and data ingestion service. Read more about conditional formatting and a...
1,148

The importance of using DAX variables / the Kusto/ADX edition

DanyHoter on Nov 30 2022 04:55 AM
Why using variables in DAX measures is especially important when using Direct Query with ADX or any other source
1,800

Building an Azure Service Tag Lookup utility with KQL and a Free Cluster

Gilles_LHerault on Nov 24 2022 09:24 PM
Service Tag KQL Lookup If you are a network professional, dealing with IP addresses is a fact of life when architecting ...
1,728

Migrate seamlessly your ADX cluster to Lsv3-series for reduced costs and better performance

Iris_Kaminer on Nov 24 2022 02:31 AM
Customer quote: “The Lsv3 SKU migrations have greatly helped us lower the cluster costs and improve query performance. C...
1,271

Cluster monitoring with Keep Alive metric

Gabi Lehner on Nov 14 2022 04:29 AM
Cluster monitoring is essential to guarantee your users can always get performant and reliable service. One of the found...
1,670

How to identify queries send to Kusto from a specific Power BI report

DanyHoter on Nov 08 2022 11:10 PM
You and your team create many PBI reports based that Access Kusto/ADX data. The reports are sending many queries and use...
1,650

New Experience in Query to Power BI from Kusto Explorer/ Kusto web explorer

DanyHoter on Nov 08 2022 10:22 PM
We simplified the process of using a query you wrote in KE or KWE in Power BI or Excel. You no longer need to start with...
2,122

ADX Web updates – October 2022

Michal_Bar on Oct 31 2022 12:40 AM
How do you keep up to date with new features and improvements in ADX Web?
2,090

Azure Data Factory to ADX Free Cluster

ShafMahmood on Oct 23 2022 10:29 PM
If you are using Azure Data Factory and need to connect to an Azure Data Explorer Free Cluster, this walkthrough will sh...
2,606

MS Learn module: Create dashboards in Azure Data Explorer

Tzvia Gitlin Troyna on Oct 23 2022 12:32 AM
Create a dashboard from a query in Azure Data Explorer web UI. Add new tiles. Create dashboard parameters, and cross-fil...
2,900

Kusto Trender

cosh23 on Oct 13 2022 12:00 AM
Read this article if you are interested in timeseries visualization for the IIoT.
2,118

Evaluate query performance of Azure Data Explorer

SuryaJ on Oct 11 2022 12:46 AM
Using load testing tools like Grafana K6 and JMeter, we can test Azure Data Explorer REST API for performance on concurr...
1,664

Use Excel to summarize values from Kusto for a list of Ids

DanyHoter on Sep 28 2022 05:22 AM
Give your Excel user an option to provide multiple Ids and query aggregated values for these IDs from Kusto The data can...

Latest Comments

VAISE280
in How to create the output schema from Kusto query on Jan 15 2023 02:38 PM
Using Python plugin, some times would be great to decide the schema within the script and not beforehand.Is there any way to parse a string with the schema?
0 Likes
Siddharth1001
in Enhanced experience for Query in ADX Web Explorer on Jan 11 2023 08:50 PM
How can I reopen a closed tab after the browser has been refreshed ? The undo button is not helping.
0 Likes
maxha
in How to migrate from Elasticsearch to Azure Data Explorer on Jan 09 2023 01:27 PM
Thanks @Born2Code , will try your suggestion! 
0 Likes
Born2Code
in How to migrate from Elasticsearch to Azure Data Explorer on Jan 09 2023 12:13 PM
@maxha If you parallelize the pipeline runs in multiple VMs, you could achieve it even in fewer days. I had to parallelize my data by each index running on different VMs and able to migrate very quickly. If it's only single machine, then yes, it might take more days as you mentioned. Good luck and l...
0 Likes
maxha
in How to migrate from Elasticsearch to Azure Data Explorer on Jan 09 2023 11:32 AM
Thank you for replying @Born2Code This is great info!From your experience you mentioned, where 20-25 M records per hour, is about twice as fast from what we where able to achieve (10m per 1hr 48 min).ADX does located in different region from Logstash - that could also contribute to latency as you me...
0 Likes