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
3,676

Using KQL query settings in Power BI

DanyHoter on Dec 20 2023 04:07 AM
When defining a query from Kusto/ADX/KQL database, you can include settings that influence the query behavior. The artic...
2,400

ANNOUNCEMENT: CMK on ADX Leader/Follower Cluster

bwatts670 on Dec 06 2023 07:49 AM
New capability to utilize CMK on an ADX Leader/Follower Cluster.
3,126

Breaking changes November 2023

gabil on Nov 22 2023 11:41 PM
breaking change in "Deprecating the metric "Events Processed (for Event/IoT Hubs)". In this article you'll find the desc...
3,407

Kusto Schema Validation

vplauzon on Nov 21 2023 09:30 AM
You've created your Kusto database a couple of months ago. Different team members came and went, contributing tables, up...
3,206

How many to many relationships affect the number of queries required to refresh matrices and tables

DanyHoter on Nov 16 2023 12:29 PM
Relationships between tables coming from Kusto in direct query mode are created as M:M by default. Changing them 1:M can...
3,630

Kusto NLog connector now supports Azure Data Explorer Free Clusters

asaharn on Oct 14 2023 07:25 AM
In this blog post, we walk you through the latest enhancements in NLog connector for Azure Data Explorer including suppo...
4,834

Integrating Azure Data Explorer with Cosmos DB to analyze data in near real-time

vchintala on Oct 13 2023 09:47 AM
Azure Data Explorer (ADX) is a fully managed, high-performance, big data analytics platform that makes it easy to analyz...
2,808

New outbound dependency for Azure Data Explorer

cosh23 on Oct 09 2023 02:28 AM
Important firewall configuration change for Azure Data Explorer customers using virtual network injection and opting out...
4,573

Filtering and visualizing Kusto data in local time

DanyHoter on Oct 08 2023 11:01 PM
Datetime values in Kusto (aka Azure Data Explorer/ADX/KQL database in Fabric) are assume to be in UTC time. In many case...
3,728

Calculating distinct counts in Power BI with data in Kusto

DanyHoter on Oct 02 2023 07:37 AM
Distinct counts using the dcount KQL function return estimated values. A new setting in Ower BI allows you to control ho...
7,733

How to visualize graphs in Kusto using Plotly and Python

cosh23 on Oct 02 2023 05:52 AM
Do you want to learn how to use graph semantics in Kusto to model and analyse complex relationships between entities, su...
4,883

Getting started with Microsoft Azure Data Explorer Add-On for Splunk

tanmayapanda on Oct 01 2023 06:00 PM
Microsoft Azure Data Explorer Add-On for Splunk allows users to effortlessly ingest data from Splunk to Azure Data Explo...
6,905

Sending Azure Cost Management to Azure Data Explorer/Fabric KQL DB

bwatts670 on Sep 11 2023 05:57 PM
Understanding your Azure Spend is one of the most important things you do as an Azure customer. Azure Cost Management is...
7,069

ADX Web UI updates – August 2023

Michal_Bar on Sep 10 2023 04:23 AM
New Get Data Experience, new visual type for ADX Dashboards and new way to connect to ADX clusters
2,988

How Date and Time values from ADX are reflected in Power BI

DanyHoter on Aug 27 2023 03:51 AM
Date and time values are maintained in different ways in different tools and databases, In this article I explain how th...
2,795

Relationships between ADX tables on two databases or two clusters

DanyHoter on Aug 16 2023 06:43 AM
When using relationships between two ADX tables, we always prefer a join to be used between the two tables What if the t...
3,286

KQL joins in Power BI and not only

DanyHoter on Aug 10 2023 01:00 AM
Power BI classic star schemas do not translate well to ADX and direct query. The reason is the nature of joins between t...
3,401

ADX Web UI updates - July 2023

Michal_Bar on Aug 01 2023 01:40 AM
Visualize query results on the fly - graphically visualize query results instantly and effortlessly by changing chart ty...
15K

AiTM & BEC threat hunting with KQL

Kijo_Girardi on Jul 31 2023 10:23 PM
The evolving phishing threat is relentless and continues to grow each year. Attackers have been changing their tactics, ...
2,968

Near real time reports in PBI + Kusto

DanyHoter on Jul 26 2023 02:18 AM
In some scenarios users want the PBI reports to refresh automatically without user interaction. It can be challenging fo...
2,723

Orchestrating ADX queries using managed Airflow

michaelspector on Jul 24 2023 04:00 AM
Apache Airflow is a widely used task orchestration framework, which gained its popularity due to Python-based programmat...
2,453

New ADX Version Deployment Notification

bwatts670 on Jul 20 2023 06:23 PM
Being a PaaS Service, Azure Data Explorer is providing you with frequent updates, so you have the latest and greatest th...
2,971

Kusto EngineV2 end of Life announcement

gabil on Jun 28 2023 05:21 AM
Migration Notice: Azure Data Explorer EngineV2 to EngineV3
3,410

New generation of cache recommendations for Azure Data Explorer

Guy_Reginiano on Jun 26 2023 07:57 AM
New and improved recommendations to optimize your cache policy 
3,223

Generally Available: Cosmos DB to Azure Data Explorer Synapse Link

vplauzon on Jun 19 2023 09:05 AM
Cosmos DB Data Connection is now generally available!    
3,559

Kusto Emulator on Linux

vplauzon on Jun 06 2023 04:38 PM
4,932

Simplifying data streaming from Event Hubs to ADX

Guy_Reginiano on Jun 05 2023 05:56 AM
Stream data directly from the Event Hubs Instance page into ADX!

Latest Comments

adieldar
in Optimizing Vector Similarity Search on Azure Data Explorer – Performance Update on Sep 28 2024 11:52 PM
Hi @Rajesh-Singh, we didn't do a formal comparison yet. In general, using Kusto you can store the embeddings in your table in your own db, and you have full control of it (w.r.t. retention, cross region and more). We are also adding (IVFFlat) indexing of the vectors to further accelerate the search ...
0 Likes
Rajesh-Singh
in Optimizing Vector Similarity Search on Azure Data Explorer – Performance Update on Sep 22 2024 09:08 PM
@adieldar , great article. I'm tempted to do a POC on ADX based RAG pattern. Do you have comparison of these results with Azure AI Search as well? it would be interesting to see how these two products can complement each other, and which use cases these products fits into.
0 Likes
wernerzirkel
in ADX Continuous Export to Delta Table - Public Preview on Sep 11 2024 07:27 AM
Delta has become a standard format. But as an Azure user, I am little confused about the many options I have to convert my ADX data in delta format now. I could use ADX external tables to export to delta using continous export (> my favourite)use Data Factory pipelines which require a databricks ins...
0 Likes
wernerzirkel
in Introducing Dashboards Base Queries: Enhancing Productivity and Consistency on Jul 04 2024 11:40 PM
I am a little bit disappointed of these base queries. I expected that a base query is executed once and the results can be re-used several times. So the base query would simply pass the result data to multiple tiles. So I created a very complex query, defined a base query and created 30 tiles referr...
1 Likes
MartinIhrke
in The #1 factor in ADX/KQL database performance on Jun 20 2024 07:01 AM
Thanks, Dany. Good read! Did you change the partition policy or is your timestamp column (CreatedAt) identical to the ingestion date (which is the default partition column)?
0 Likes