578 questions with Azure Data Explorer tags

Sort by: Updated
Updated Created Answers
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.
578 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.
578 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.
578 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 7,295 Reputation points Microsoft External Staff Moderator
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.
578 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,665 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 15,765 Reputation points Microsoft External Staff Moderator
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.
578 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,385 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,917 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 14,685 Reputation points Microsoft External Staff Moderator
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.
578 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 7,295 Reputation points Microsoft External Staff Moderator
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.
578 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,385 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 25,100 Reputation points Microsoft External Staff Moderator
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.
578 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.
578 questions
SQL Server | Other
asked 2025-01-16T15:42:01.8966667+00:00
Anonymous
edited a comment 2025-01-17T10:27:10.7066667+00:00
Anonymous
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.
578 questions
asked 2023-11-07T16:46:38.0266667+00:00
Akash Gupta 20 Reputation points
commented 2025-01-09T13:45:23.83+00:00
01725609 60 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.
578 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
722 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 7,295 Reputation points Microsoft External Staff Moderator
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.
578 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 25,100 Reputation points Microsoft External Staff Moderator
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.
578 questions
Microsoft Security | Microsoft Purview
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 7,295 Reputation points Microsoft External Staff Moderator
2 answers

Ingestion response takes too long

Hello ADX experts. I have a background worker that are doing calculations in near real-time. The results are then ingested to ADX using the .NET SDK. It's important that the ingestion operation doesn't take too long, or it will accumulate a delay which…

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.
578 questions
asked 2024-11-29T12:23:26.6366667+00:00
Pål Kristian Halle 110 Reputation points
commented 2024-12-03T18:59:33.3+00:00
Ganesh Gurram 7,295 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How to recover data for failed ingestion

Hello ADX experts. I'm using queued ingestion which seems to always be successful (i.e. inserted to queue) regardless of whether the queued data can be merged to the main table. (Please correct me if I'm wrong.) I did a quick test and temporarily renamed…

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.
578 questions
asked 2024-11-29T12:35:49.2333333+00:00
Pål Kristian Halle 110 Reputation points
commented 2024-12-02T15:26:50.2966667+00:00
Pål Kristian Halle 110 Reputation points
1 answer One of the answers was accepted by the question author.

Most cost-effective way to migrate existing data

Hello ADX experts. I have tested ADX for a while now and have decided to try it in production. However, a big uncertainty is the migration process. We are looking to migrate about 50 TB of data from an Azure SQL database. What would be the most…

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.
578 questions
asked 2024-11-29T12:15:08.8866667+00:00
Pål Kristian Halle 110 Reputation points
accepted 2024-12-02T09:45:01.4266667+00:00
Pål Kristian Halle 110 Reputation points
1 answer One of the answers was accepted by the question author.

How to customize the name of file in export command in Azure data explorer

I am exporting data to blob storage using the .export command , i want the the file name to be <TableName>_<today'sDateTime> but i am unable to change the file name in namePrefix property of .export command and cannot find any specific…

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.
578 questions
asked 2023-07-20T10:17:40.9866667+00:00
siddharth bansal 346 Reputation points
accepted 2024-11-26T10:39:05.15+00:00
siddharth bansal 346 Reputation points
1 answer

Missing parameter in Azure Portal deployment of an Azure Data Explorer Cluster resource

I've detected an issue with how the portal is deploying Data Explorer cluster resources. While having the following policy activated: "Public network access on Azure Data Explorer should be disabled - 43bc7be6-5e69-4b0d-a2bb-e815557ca673", 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.
578 questions
asked 2024-11-15T15:18:10.8766667+00:00
REZAI Arash 0 Reputation points
commented 2024-11-19T19:54:41.6333333+00:00
Sander van de Velde | MVP 36,776 Reputation points MVP Volunteer Moderator
2 answers

ADX plugin postgresql_request failed to load System.Security.Cryptography.Algorithms

I have an Azure Data Explorer (ADX) instance in combination with a PostgreSQL Flexible Server (16.4) and want to access the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the official postgres_request…

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.
578 questions
Azure Database for PostgreSQL
asked 2024-11-13T10:24:34.47+00:00
lwerthm 0 Reputation points
commented 2024-11-18T17:40:24.5566667+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
2 answers

How to fix internal server error 500 for kusto db using user managed identity ?

Hi , I am trying to use user assigned managed identity to connect with KUSTO db but getting internal server error 500 . kusto db already given the permissions to my managed identity . I am concern about the app service environment variable is that…

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.
578 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,988 questions
asked 2024-11-07T15:56:52.2233333+00:00
SohamPrasad Girde (Wipro Designit Services, Inc.) 40 Reputation points Microsoft External Staff
commented 2024-11-11T12:03:18.39+00:00
Ganesh Gurram 7,295 Reputation points Microsoft External Staff Moderator