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.
501 questions
2 answers
How can I optimize ADX query performance to find last timestamp of a specific timeseries id ?
Hi community, I have a Telemetry table as followed: The partition is applied only on TimeseriesId field and the default on ingest_time I have an use case where I need to find the last ServerTimeStamp of a specific TimeseriesId When I have performed…
asked 2023-11-06T17:33:45.7433333+00:00
Galgani, Stefano
205
Reputation points
edited a comment 2023-12-15T13:10:24.3833333+00:00
Galgani, Stefano
205
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure data explorer dashboard is not loading in iframe
I am trying to embed azure data explorer dashboard in an iframe. For this i followed code samples provided by microsoft. Till yesterday the dashboard were able to load fine but from today instead of loading the dashboard, azure query explorer is getting…
asked 2023-12-01T15:13:02.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 14.000000000000002%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sunil K
30
Reputation points
commented 2023-12-12T14:36:56.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
28,526
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
load data from tempview to table in databricks
Hi Expert, How to load the data from temp_view to table in databricks ---View Creation %sql create or replace view test as select * from table1 now how to load the data from view to table level
asked 2023-12-06T11:37:16.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,406
Reputation points
accepted 2023-12-07T10:06:02.7166667+00:00
Shambhu Rai
1,406
Reputation points
1 answer
Need Help with KQL Query for Software Update Information in Log Analytics
Hello Everyone, I hope this message finds you well. I'm currently working on retrieving software update information from Log Analytics in Azure using Kusto Query Language (KQL). Unfortunately, my lack of experience in KQL is making it challenging for me…
asked 2023-11-28T07:26:41.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 77%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Swahela Mulla
90
Reputation points
commented 2023-12-05T08:01:39.9066667+00:00
Swahela Mulla
90
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…
asked 2023-12-04T18:49:34.9866667+00:00
Kovács, Ferenc
61
Reputation points
answered 2023-12-04T23:11:22.78+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
2 answers
Copy data from azure select server to adls
Hi expert, How to copy data from SQL server db tables to in paraquat format in adls using one copy pipeline
asked 2023-12-02T19:10:06.3566667+00:00
Shambhu Rai
1,406
Reputation points
commented 2023-12-04T18:15:16.1066667+00:00
Shambhu Rai
1,406
Reputation points
0 answers
How to save forecasting result after using series_decompose_forecast in Kusto?
I am generating a time chart in Kusto using the code below, but when I view the data points, only the first 7 data points are shown. I need to use the forecasted data somewhere else, but I am unable to do so due to this issue. How can I save the forecast…
asked 2023-11-27T12:09:27.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 65%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Vishal Vyas
0
Reputation points
commented 2023-12-01T10:41:13.0933333+00:00
Vishal Vyas
0
Reputation points
1 answer
Load files in appending in databricks
Hi Expert, I have 2 files in blob storage . file1.csv, file2.csv how will i load it in a view using appending order using *.csv extension using temp view file_list = dbutils.fs.ls("/mnt/mount/test/file")
asked 2023-11-29T05:48:38.4166667+00:00
Shambhu Rai
1,406
Reputation points
commented 2023-11-30T12:32:49.06+00:00
Shambhu Rai
1,406
Reputation points
1 answer
One of the answers was accepted by the question author.
Seeking Guidance on Materialized Views Update Challenges
Hello Forum Members, Our team relies on materialized views to facilitate joins between our main table and multiple dimension tables. Due to the significant size of the main table, we've implemented 12 materialized views, each corresponding to a different…
asked 2023-11-29T08:15:23.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 11%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Amir Meshkati
61
Reputation points
accepted 2023-11-30T09:00:14.4433333+00:00
Amir Meshkati
61
Reputation points
0 answers
Cosmosdb_sq_request plugin not working for service to service authentication.
Cosmosdb_sq_request plugin not working for service to service authentication. In …
asked 2023-11-07T07:18:53.6833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 86%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
DEVESH KUMAR
0
Reputation points Microsoft Employee
commented 2023-11-28T20:21:17.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
1 answer
MULTIJSON data format missing when creating a Data Explorer data connection in the Azure Portal
When creating a data connection from ADX/Kusto to EventHub, I would like to choose the MULTIJSON data format. If I recall correctly, this option was available in the Azure Portal, but there is only the JSON format now (see screenshot). The docs still…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 90%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
1 answer
how to delete a table in azure data explorer using kql query?
I was trying to delete a table called Heartbeat from Azure Data Explorer DB using a KQL script. The contents of the kql script is: .drop table Heartbeat ifexists On executing the kql script using github workflows, Im getting the following error: The…
asked 2023-11-24T12:40:50.0566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 39%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
PRIYANKA S NAIR
20
Reputation points
commented 2023-11-27T23:25:23.27+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How can we achieve real-time import, processing, and export of streaming data by using ADX?
The streaming data comes from Azure iothub, and I would like to process and export each data from iothub in the form of streaming data by using ADX to other containers, such as ADLS, CosmosDB, etc. Due to ASA's lack of flexibility, I am considering…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 14.000000000000002%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Is recreate_schema supported in CslCommandGenerator.GenerateTableSetOrReplaceCommand(......) . I can see extend_schema is supported.[KustoClientFactory ]
public static string GenerateTableSetOrReplaceCommand(string tableName, string innerQuery, bool isAsync, IEnumerable<string> tags = null, IEnumerable<string> ingestIfNotExistsValues = null, DateTime? creationTime = default, string folderName…
asked 2022-12-05T22:53:22.617+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 53%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sumier Sumier Mustafa
21
Reputation points Microsoft Employee
accepted 2023-11-26T00:18:41.61+00:00
Sumier Sumier Mustafa
21
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
timefromparts in databricks
Hi Expert, Sql server query: create table table12(col varchar(25),col1 nchar(1000)) insert into table12 values('0','620') select TIMEFROMPARTS (620/100, 620%100,0,0,0) ,620 as col1 from table12 Expected output:: 06:20:00 620 How we can get this field in…
asked 2023-11-22T07:30:24.16+00:00
Shambhu Rai
1,406
Reputation points
accepted 2023-11-23T07:41:05.4266667+00:00
Shambhu Rai
1,406
Reputation points
1 answer
Need support on satelite when used ODK to capture time
OLE DB or ODBC error: [DataSource.Error] OData: Cannot convert the literal '2023-11-22T5:56:50.104+03:00' to the expected type 'Edm.DateTimeOffset
asked 2023-11-22T19:56:22.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 36%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Joshua Kamulegeya
0
Reputation points
commented 2023-11-22T20:57:01.67+00:00
Sander van de Velde | MVP
30,711
Reputation points MVP
1 answer
Need Assistance Redirecting O365 Logs to Event Hub (using azure function), then visualize with data explorer
Hello, I've been working on a project involving eventhub, function apps and O365 logs, and I've hit a bit of a roadblock. I'm using the Azure-Sentinel GitHub repository (link:…
asked 2023-11-16T19:02:35.7633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 86%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Riya Aggarwal
25
Reputation points
commented 2023-11-22T10:38:53.01+00:00
MayankBargali-MSFT
69,941
Reputation points
1 answer
Remove 'Z' in datetime column that is not UTC
Hi Team, Good morning! We have an issue which is in an ADX table, we have a column which is not UTC time (for example EST timezone), in the source json file, we remove 'Z' after the datetime value (for exmaple: {'localtime': '2023-10-20T22:22:22.365'}…
asked 2023-11-20T16:24:50.7866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
Jiacheng Zhang
20
Reputation points
commented 2023-11-22T10:20:27.4+00:00
ShaikMaheer-MSFT
38,321
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to ingest dynamic data to ADX?
I am connecting to Azure IoT Hub through Azure Data Explorer (ADX) to get JSON-formatted streaming data. However, this JSON is in a nested format, and the fields of the nested objects are not fixed. How can I flatten and store it in ADX? The JSON data…
1 answer
Pre-copy script in Copy Activity is not available in Azure Data Factory when Sink is ADX Azure Data Explorer
Data is ingested using Copy Activity of Azure Data Factory into Azure Data Explorer table. Need to clear/truncate the data from ADX table before load. But Pre-copy script feature not available when ADX is used as sink in copy Activity.
asked 2023-11-16T11:14:39.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
edited a comment 2023-11-21T17:55:39.38+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee