550 questions with Azure Data Explorer tags

Sort by: Updated
Updated Created Answers
0 answers

Azure Data Explorer External Table with Partition

I am trying to create an Azure Data Explorer external table in azure using a parquet file with partitions and somehow ,I am not able to get the URI properly using UI or KQL always getting error or return query count from external table as 0. without…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-02-26T14:33:00.44+00:00
DataEngineer 40 Reputation points
commented 2025-02-28T11:14:35.0033333+00:00
DataEngineer 40 Reputation points
1 answer

IoT Hub ingestion into Azure Data Explorer runs at 100% avg ingestion utilization

My setup consists of several databases in a single Kusto cluster, each having a landing table with ingestion mapping configured from IoT Hubs. The data in the landing table is then split with update policies into specialized tables. I have no ingestion…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2023-12-04T18:49:34.9866667+00:00
Kovács, Ferenc 61 Reputation points
commented 2025-02-28T10:22:45.96+00:00
Kovács, Ferenc 61 Reputation points
1 answer One of the answers was accepted by the question author.

Is it allowed to use an Azure Data Explorer cluster with a "Dev/Test" workload for production database monitoring?

Hello! We've been evaluating the Azure Database Watcher service and have nothing but great things to say. However, we have a question about provisioning the service in production. We understand the benefits and limitations of "free" Azure Data…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-02-26T18:03:04.82+00:00
Wes Kennedy 25 Reputation points
commented 2025-02-26T21:39:57.64+00:00
Sander van de Velde | MVP 35,246 Reputation points MVP
1 answer

Data ingestion from azure function to ADX

hi all, I am trying to get an azure function app going to write the incoming http json payload to ADX table. below are the steps i followed: Create a new DB in ADX and create a corresponding table. create a new function app using node and create a…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-02-24T01:09:01.7133333+00:00
Abhishake Jaiswal 160 Reputation points
commented 2025-02-26T08:20:39.9466667+00:00
J N S S Kasyap 270 Reputation points Microsoft External Staff
1 answer

ADX (KQL) - Unable to query data older than 3 months

I have a situation where I am unable to query historical data (older than 3 months) from our ADX database. My database has a retention period of 3600 days and cache period of 270 days. There are no ingestion failures I ran the following…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-02-12T16:54:46.34+00:00
pjbcoetzer 0 Reputation points
answered 2025-02-12T19:40:00.1366667+00:00
phemanth 14,220 Reputation points Microsoft External Staff
1 answer

Are there any plans to create a docker container for Kustainer / Data Explorer emulator that is compatible with MacOS on arm64?

Hi everybody. As the title says, I would greatly appreciate to use the Kustainer image on my Mac with M1 processor. I can run the linux container but it fails with an exception: /kusto/Kusto.Personal / Kusto.Personal: Exception:…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2024-02-16T14:23:12.6333333+00:00
CC 20 Reputation points
edited a comment 2025-02-12T08:45:58.1766667+00:00
Joakim Järvinen (Brightly) 0 Reputation points
2 answers

Unable to connect to new azure cluster

I am not authorized to connect to my newly-created azure data explorer cluster. My account is owner of the subscription, resource group and cluster, and it has alldatabaseadmin permission on the new cluster's database. Please advise ResourceIAM rolerole…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-02-08T21:20:45.5566667+00:00
jwinnd 0 Reputation points
commented 2025-02-12T01:30:44.2966667+00:00
Chandra Boorla 9,120 Reputation points Microsoft External Staff
1 answer

Is there a way to deploy KQL - Time Series Query to get alerts for anomalies?

We have a KQL query that reads last 365 days of data from custom table (Log analytics workspace) and using Time-series functions it calculates anomalies in it. Now we are looking for deploying this query to get an alert email if there is anomaly. Is it…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2024-02-07T14:35:49.07+00:00
D Mallikarjuna Reddy 96 Reputation points
commented 2025-02-05T19:01:34.0966667+00:00
Vermani, Bhuvnesh 0 Reputation points
1 answer One of the answers was accepted by the question author.

Few Azure Data Explorer Free Clusters

Hello, I would like to create few Azure Data Explorer Free Clusters and use them simultaneously to keep my data for different projects (development), is it even possible? The second question is - is it possible to give some permission to other users to…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-01-23T13:47:24.6066667+00:00
Andrzej 20 Reputation points
accepted 2025-02-05T11:46:47.0033333+00:00
Andrzej 20 Reputation points
3 answers

What authentication steps/settings should I double check if the initial login process hangs while the app says "A popup authentication should come up on your browser next" and then never does?

Dataexplorer has been installed but hangs upon bringing up a window to login. A user/pass are never put in so, we are unable to get any further. I need help looking for settings most likely to be a culprit. Also, this is on a MS 365 E5…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-01-10T13:09:14.94+00:00
Rick Osteen 0 Reputation points
commented 2025-02-04T16:34:18.47+00:00
Ganesh Gurram 4,490 Reputation points Microsoft External Staff
1 answer

I'm using data factory and my explorer seems to be frozen. Behind the scenes I am able to create tables but when I request to drop a table it says that I have two columns with similar names and that I need to use SQL commands to rename these columns.

I have a table InstallBase which I have created successfully using a copy data task in Data Factory. When I go to Explorer I can't see the table. When I then do to drop the table using a drop table SQL command it drops the table but reports that I have…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,294 questions
asked 2025-02-04T11:57:09.39+00:00
Peter Carruthers 0 Reputation points
answered 2025-02-04T15:03:21.4266667+00:00
phemanth 14,220 Reputation points Microsoft External Staff
2 answers

How to connect Azure Data Explorer pool in Synapse to Cosmos DB

Hi, I am trying to connect Data Explorer (Synapse pool) to the Analytical Store in a Cosmos DB container. I was informed on this forum that this is indeed possible and the documentation shows how to do this. Unfortunately when I try to ingest data into…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,213 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,776 questions
asked 2025-01-20T11:04:52.11+00:00
Christopher Wilkinson 0 Reputation points
commented 2025-01-23T21:45:42.3+00:00
Chandra Boorla 9,120 Reputation points Microsoft External Staff
1 answer

How to call ADX search API? I am not able to run it in postman

Hi Team, I want to provide search API to team, so that they can integrate it with there system. but I am not able to run ADX query API in postman. I am not able to understand what I should use to authenticate ADX in postman, how to get auth…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2025-01-20T09:03:37.4533333+00:00
Disha Bodade 80 Reputation points
commented 2025-01-22T09:54:41.6366667+00:00
Ganesh Gurram 4,490 Reputation points Microsoft External Staff
1 answer

How does Azure Data Explorer in Synapse Analytics work as regards Cosmos db

Hi, I am trying different ways to get Cosmos db data into Synapse Analytics in real-time (near real-time is good enough). I have seen mentioned that it is possible to use Azure Data Explorer. Does Data Explorer use the Analytical Store to get the latest…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,213 questions
asked 2025-01-17T09:15:09.86+00:00
Christopher Wilkinson 0 Reputation points
commented 2025-01-21T18:35:52.6833333+00:00
Smaran Thoomu 20,630 Reputation points Microsoft External Staff
2 answers One of the answers was accepted by the question author.

Sharing Azure Data Explorer dashboards externally ?

Hi, is it possible to share ADX Dashboards externally ? Naturally, I can share the dashboards internally - within the organization - per email & manage the permissions, but can I do the same with external viewers ? E.g. shareholders or any person…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2022-05-02T08:52:19.27+00:00
Miroslav V 26 Reputation points
answered 2025-01-21T15:01:06.86+00:00
Gabi Lehner 6 Reputation points Microsoft Employee
0 answers

How to get the partitions data from Azure ADX through SQL Server emulation?

I'm looking for support regarding viewing my partition data in Azure ADX through the jdbc SQLServer emulation. By following this page…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-01-16T15:42:01.8966667+00:00
Shanmuganandha Vadivel Mahesh Kumar, FG-210 0 Reputation points
edited a comment 2025-01-17T10:27:10.7066667+00:00
Shanmuganandha Vadivel Mahesh Kumar, FG-210 0 Reputation points
2 answers

How to deploy Azure Data Explorer Dashboard using Azure DevOps CI/CD pipeline?

I have created an ADX dashboard in dev environment which basically shows visualization of an app insights logs . I want to copy that dashboard and promote it to next environment QAT with data source updated with the QAT app insights. I was trying to…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2023-11-07T16:46:38.0266667+00:00
Akash Gupta 20 Reputation points
commented 2025-01-09T13:45:23.83+00:00
Niels 40 Reputation points
1 answer

Cross-tenant data connection between event hub and ADX

HI Team, how to create Cross-tenant data connection between event hub and ADX using SPN authentication

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
695 questions
asked 2025-01-09T02:42:53.4633333+00:00
Raja Mohamed Masthan Syed Ahamed 0 Reputation points Microsoft Employee
answered 2025-01-09T11:17:35.7+00:00
Ganesh Gurram 4,490 Reputation points Microsoft External Staff
0 answers

Data Explorer scale out issue

We have Standard_D12_v2 First scale out configuration: The cluster got more than 90% CPU and didn't scale to 4 instances, instead it was down. We tested also a Second configuration, custom auto scale rule CPU > 80% Same issue. Cluster never…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
asked 2024-12-10T15:21:25.98+00:00
_Esteban Bett 35 Reputation points
commented 2024-12-13T05:26:44.6033333+00:00
Smaran Thoomu 20,630 Reputation points Microsoft External Staff
1 answer

Unable to update or modify Azure Purview account tags using Terraform

I am attempting to update or modify Azure Purview account tags using Terraform, but I am encountering an error indicating that an Azure policy is blocking the operation. We want to identify the deny policy using a Kusto query or data explorer. Could you…

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
550 questions
Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,424 questions
asked 2024-12-03T05:50:46.4466667+00:00
Nikhil Raj 20 Reputation points
edited a comment 2024-12-10T02:30:26.2766667+00:00
Ganesh Gurram 4,490 Reputation points Microsoft External Staff