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
832

Azure Schema Registry, Avro format, and ADX - short survey

Guy_Reginiano on May 02 2022 06:59 AM
Are you using Azure Schema Registry (part of Event Hub) and whish to integrate schema-less Avro to ADX? Help us improve ...
910

Use the one-click sample app generator to create code to ingest and query your data

Tzvia Gitlin Troyna on Apr 26 2022 11:22 PM
The one-click sample app generator is a tool that allows you to create a working app to connect to your Cluster & Databa...
752

M dynamic parameters are generally available in Power BI

DanyHoter on Apr 26 2022 04:38 AM
An unusual use of M dynamic parameters to push arbitrary values to a visual on a Power BI report
2,333

F1 telemetry analysis with Azure Data Explorer (ADX)

Anshul_Sharma on Apr 12 2022 09:54 PM
Formula 1 is one of the most fascinating data-driven sport – so competitive that even one tenth second of an advantage c...
1,191

Send data from Node-RED to free Azure Data Explorer (Kusto)

karasmus on Apr 12 2022 02:00 AM
With the new Node-RED to Kusto node, its now easy to send data directly from Node-RED to Azure Data Explorer
1,149

Merging ADX queries in Power BI

DanyHoter on Apr 10 2022 11:53 PM
Using merge in the right way, we can join multiple tables in Power BI and get the best performance. Only the right way i...
940

ARM Deploy Azure Data Explorer DB with Event Hub connection

vplauzon on Apr 05 2022 05:00 AM
We recently published an Azure Quick Template allowing you to deploy an Event Hub, an Azure Data Explorer cluster, datab...
1,876

Performance Optimizations for Applications using Azure Data Explorer

ashokanms on Apr 04 2022 11:26 PM
In many cases Azure Data Explorer’s inbuilt query capabilities can reduce the need to provision traditional memory cachi...
1,678

Multiple databases per data connection (Multi DB data connection)

Guy_Reginiano on Apr 04 2022 04:20 AM
Now, you can dynamically route data to an alternate database
1,009

Sampling the results of a query to be visualize in a line chart

DanyHoter on Apr 03 2022 10:25 AM
A line chart can plot a limited number of points. If we try to plot more, Power BI will sample the data. The article pro...
1,350

Exporting AWS CloudWatch Logs to Azure Data Explorer

DrewFurgiuele on Mar 31 2022 08:25 AM
If you're running AWS workloads and using CloudWatch, check out this real-world example of how you can ingest your logs ...
2,832

Azure Data Explorer: Zero Trust Security with Conditional Access

Anshul_Sharma on Mar 27 2022 07:12 PM
Azure Data Explorer launches support for Azure Active Directory Conditional Access.
1,557

ADX useful links

Guy_Reginiano on Mar 27 2022 05:03 PM
Want to learn more about ADX? Here are some useful links 
1,395

(Preview) Configure ADX table retention, caching and batching policies via one-click

Anshul_Sharma on Mar 21 2022 10:50 PM
Azure Data Explorer (ADX) now allows you to configure table retention, caching and batching policies via one-click Web i...
1,377

End to end Azure Data Explorer pipeline deployment with ARM

vplauzon on Mar 17 2022 06:00 AM
We can now deploy an Azure Data Explorer (ADX)-based solution end-2-end from a single ARM template, no storage account r...
1,676

Now in preview: Materialized Views Over Materialized Views

DrewFurgiuele on Mar 15 2022 11:57 AM
Let's take a look at how we can leverage a materialized view to first deduplicate our records, and then create another a...
1,564

New productivity features in Kusto Explorer

Michal_Bar on Mar 15 2022 02:49 AM
We are pleased to announce a few improvements to Kusto Explorer (Desktop version of Kusto Web Explorer) to help you be m...
2,936

Start for free Azure Data Explorer (Kusto) cluster

Avner Aharoni on Mar 10 2022 02:03 AM
Azure Data Explorer (Kusto) provides new "start for free" personal cluster
1,509

Using Query results cache in Azure Data Explorer (aka Kusto) from Power BI

DanyHoter on Mar 09 2022 09:25 PM
Azure Data Explorer can maintain results of queries in cache and so shorten response times of subsequent queries and als...
1,590

Filtering multiple tables from Kusto by one time slicer in Power BI

DanyHoter on Feb 27 2022 04:32 AM
If you want to filter multiple tables with a single DateTime slicer, you need a time table similar to a calendar used fo...
1,746

Open live Kusto query in Excel

Michal_Bar on Feb 22 2022 04:21 AM
New feature in ADX web explorer allows you to open a live query in an Excel Workbook so that you can refresh it from Exc...
1,182

Extracting values from Kusto JSON columns in Power BI

DanyHoter on Feb 20 2022 12:48 AM
Using the M function Value.NativeQuery you can insert snippets of KQL into the KQL query generated by the Kusto connecto...
1,306

Deleting individual records in a table

slavikn on Feb 15 2022 05:52 AM
This blog post will explain how to delete individual records from a table, by providing a predicate in the form of a KQL...
1,276

Using DateTime columns from Kusto in Power BI - Part 1

DanyHoter on Feb 13 2022 06:34 AM
Power BI does not have many features to handle DateTime columns. In these blogs I'll cover what is available out of the ...
958

Search on Slicer in Power BI with ADX

DanyHoter on Feb 08 2022 02:57 AM
You use ADX (Kusto) data in Direct Query You notice that search in slicers doesn't bring any results Why is that ? Can y...
951

Automated provisioning in Azure Data Explorer

vplauzon on Feb 07 2022 06:00 AM
Learn about the different tools available to facilitate your deployments of Azure Data Explorer. From Infrastructure to ...
3,362

Kibana dashboards and visualizations on top of Azure Data Explorer are now supported with K2Bridge

Guy_Reginiano on Feb 01 2022 03:57 AM
Elasticsearch and Kibana users can now easily migrate to Azure Data Explorer. A new version of K2Bridge (Kibana-Kusto co...
1,209

Use the sample app generator to create code to ingest and query your data

Tzvia Gitlin Troyna on Feb 01 2022 02:25 AM
The sample app generator is a tool that allows you to create a working app to connect to your cluster/database, create a...
1,241

ADX dashboards January 2022 updates

Gabi Lehner on Jan 27 2022 01:01 PM
You have been long asking for more options to control dashboard creation and management and we’ve been listening. We’re ...
1,334

Use KQL scripts to configure databases E2E

Gabi Lehner on Jan 16 2022 12:32 PM
If you're interested in an easy and automated way to configure Azure Data Explorer databases, look no more. We recently ...

Latest Comments

Guy_Reginiano
in How to migrate from Elasticsearch to Azure Data Explorer on May 04 2022 02:23 AM
Thanks, @Born2Code , for sharing the examples!
0 Likes
Guy_Reginiano
in ADX useful links on May 04 2022 02:16 AM
Thanks, @Brad Wilson , for sharing these links! 
1 Likes
Born2Code
in How to migrate from Elasticsearch to Azure Data Explorer on May 02 2022 04:25 PM
Posting the ADX table and json mapping commands used in the pipeline for reference. .create tables people(name:string,age:int,place:string, timestamp:timespan ) .create table people ingestion json mapping 'peoplemapping' '[{"column":"name","path":"$.name"},{"column":"age","path":"$.age"} ,{"column":...
1 Likes
Born2Code
in How to migrate from Elasticsearch to Azure Data Explorer on May 02 2022 04:24 PM
Below is an example of logstash pipeline to read different indices data and ingest to multiple ADX tables depending on index. input { elasticsearch { hosts => ["http://localhost:9200"] index => "people" user => "elastic" password => "pwd" tags => ["people"] } elasticsearch { hosts => ["http://localh...
1 Likes
Brad Wilson
in ADX useful links on Apr 29 2022 06:59 AM
Couple others I have in my collection:Intro to Kusto Queries · mrblackistone/LearningDevOpsAndAzure Wiki (github.com) KustoQueries/Queries.md at master · jorodas/KustoQueries (github.com) tobiasmcvey/kusto-queries: example queries for learning the kusto language (github.com)
0 Likes