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
0 answers
how to add more than one dimension table while creating a materialized view
HI Team, I am trying to create a materialized view with 2 dimension tables, but getting error with the below syntax, .create async materialized-view with (backfill=true, dimensionTables = 'SalesUserTable','ProductTable') SalesSummary on table…
asked 2021-10-07T15:04:59.127+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(275.2, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Bharath Kumar B
21
Reputation points
commented 2021-10-21T20:14:12.85+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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
1 answer
Accessing SQL Server Tables
I can only access a subset of my tables. Structure as follows via Access serve explorer: Data Connections desktop-1d218ks.MemberEntriesDataSet Tables table1 table2 table3 table5 table6 Views . My code snip it using…
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.
501 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,561 questions
asked 2021-09-19T21:10:18.96+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(22.400000000000002, 32%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Ken Wickham
1
Reputation point
commented 2021-10-07T17:31:31.973+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(204.8, 44%, 29%)' 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)
Saurabh Sharma
23,776
Reputation points Microsoft Employee
1 answer
How to cast a column in ADX
I have a Table with two columns, values_1 and values_2, which are float:s. Is there a command in adx to cast these to ints in a simple way or do I need to do: Table | extend values_1 = toint(value_1) | extend values_2 = toint(value_2) to get…
![](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(300.8, 10%, 39%)' 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)
1 answer
One of the answers was accepted by the question author.
Why does Azure Data Explorer Database not displaying everything in the columns?
I have created a new table in Azure Data Explorer Database but something is not working with my events. In PlayFab Data Explorer (advanced) the columns look like this: But in Azure Data Explorer Database the columns for the same 3 events…
asked 2021-09-09T09:00:36.447+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(121.6, 32%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kim Strasser
811
Reputation points
commented 2021-09-14T03:12:48.85+00:00
PRADEEPCHEEKATLA-MSFT
84,051
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Data ingestion is not working in Azure Data Explorer after I created a new data connection
I have created a new data connection in my Azure Data Explorer Cluster. I have chosen the connection type Blob storage and the event type Blob created. In addition, I have chosen Resources creation Automatic. I didn't get an error message when I…
asked 2021-09-01T07:54:42.427+00:00
Kim Strasser
811
Reputation points
commented 2021-09-08T10:06:42.897+00:00
PRADEEPCHEEKATLA-MSFT
84,051
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why does my ADF Lookup fail with an error mentioning the wrong database?
I'm trying to query a function in Azure Data Explorer using ADF. When I try to preview the data, I get the following error: Error details Error code: 11203 Details: Read from Kusto failed with following error: Semantic error: Errors occurred…
asked 2021-08-11T16:36:05.643+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(288, 89%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Molly Watson
96
Reputation points
accepted 2021-09-07T18:05:05.517+00:00
Molly Watson
96
Reputation points
1 answer
Traverse hierarchical JSON object and perform iterative comparison
I have a data table of user sign in logs (SigninLogs) which returns a hierarchical JSON object containing Conditional Access data. This object is represented as an indexed list of child objects which contain details on each CA policy, applied status,…
![](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(131.20000000000002, 91%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
2 answers
Kusto Query Language vs Keyword Query Language
What is difference between Kusto Query Language and Keyword Query Language?
asked 2021-08-11T03:24:35.77+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(249.60000000000002, 56.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ally sin
1
Reputation point
commented 2021-08-16T02:07:33.687+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(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT
43,421
Reputation points Microsoft Vendor
0 answers
Defender for Endpoint Hunting Query E-Mail with Join
Hi There, i try to create a Defender for Endpoint query to find out, who opens a Office Macro Dokument which was received via E-Mail wit external Domain before. The First part of the Query to find out who opens Macro Documents is working see…
asked 2021-07-26T07:24:41.193+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(262.40000000000003, 90%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Patrick Binder
1
Reputation point
commented 2021-08-02T17:39:11.757+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(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,051
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer Command block does not show parameters for parametrized linked service
I have parametrised linked service for Azure Data Explorer. The json looks like this: { "properties": { "type": "AzureDataExplorer", "parameters": { …
asked 2021-07-29T13:40:08.237+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(96, 76%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOY%3C/text%3E%3C/svg%3E)
Oleh Yermokhin
21
Reputation points
accepted 2021-08-02T07:27:18.677+00:00
Oleh Yermokhin
21
Reputation points
1 answer
Identity Column in Azure data explorer
Hi, I want to create table in azure data explorer like below. .create table Test (Id:int, Name: string) I will get the "Name" value from blob source file but for each row i am ingesting into "Test" table in Azure data explorer i…
asked 2021-07-20T07:18:56.53+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(268.8, 17%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kesav
1
Reputation point
commented 2021-07-26T17:46:03.947+00:00
MartinJaffer-MSFT
26,051
Reputation points
1 answer
One of the answers was accepted by the question author.
Need Urgent help! How to insert/Update Data to Azure Sql table from table data in ADX's cluster.
Thanks in Advance, I have requirement like insert/update data in Azure SQL table from the tables in ADX cluster.
asked 2021-07-13T07:34:13.767+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(304, 71%, 39%)' 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)
Sreekanth Kesaram
21
Reputation points
accepted 2021-07-20T14:44:31.337+00:00
Sreekanth Kesaram
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure KQL - expand dynamics column
Hello, I have a dynamic column and I just need expand all results in columns like example below: It's possible convert this json values to single columns like below ?
asked 2021-07-09T23:39:12.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(112.00000000000001, 57.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VolginRnB
256
Reputation points
commented 2021-07-15T11:33:42.093+00:00
BhargaviAnnadevara-MSFT
5,466
Reputation points
2 answers
One of the answers was accepted by the question author.
Kusto mapping of json
I am getting syntax error when running the following mapping command: Failed to create mapping: Syntax error: . Query: '.create table AnswerXLogsV2 ingestion json mapping 'AX_JSON_Mapping' '[ …
asked 2021-07-08T12:30:41.257+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(291.2, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBO%3C/text%3E%3C/svg%3E)
Bigelman, Oren
106
Reputation points
commented 2021-07-14T17:12:34.16+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
0 answers
Kafka-sink to Event Hub or other
Hi. The client wants to sync events being published to Kafka to our Azure environment so we suggested to use Event Hub to stream their events. But apparently that requires them to stream all the events and they don't want that. They want something…
asked 2021-07-06T20:53:21.003+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(297.6, 56.00000000000001%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nathan Carns
196
Reputation points
commented 2021-07-13T17:12:59.427+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
1 answer
How to access Azure SQL Server Database Tables from Grafana Cloud
Hello, I have an existing Azure SQL Server that contains a Database with multiple tables of information from IoT devices. I am actively trying link Grafana to this existing Azure SQL Server using the plugins available for Grafana. There are 3…
asked 2021-07-06T05:41:59.96+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(64, 52%, 16%)' 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)
Alex
1
Reputation point
commented 2021-07-13T17:09:07.037+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
KQL Query - Separate
Hello Guys, Anyone can help me please ? I am running a simple KQL query in Azure Log Analytics Workspace and I would want "breake or separate" the result in "/" For example the query below show me the result…
asked 2021-07-03T04:00:58.063+00:00
VolginRnB
256
Reputation points
commented 2021-07-05T14:08:09.507+00:00
BhargaviAnnadevara-MSFT
5,466
Reputation points
1 answer
One of the answers was accepted by the question author.
Deployment failed with Service: Name cannot exceed 22 characters
created custom deployment with Azure synapse resource gorup ( i had provided unique value vi22012013 ) Deployment failed with Service: Name cannot exceed '22' characters for the autogenerated resource name : asagadataexplvi22012013 ( 23…
asked 2021-07-01T19:05:46.39+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, 68%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Manjula Chintharla
21
Reputation points
accepted 2021-07-05T08:36:59.247+00:00
Manjula Chintharla
21
Reputation points
1 answer
Azure data explorer ingest parquet timeout
I have a Azure data explorer and would like to ingest a 500MB parquet , however timeout .. and actually it takes quite a long time
asked 2021-06-29T10:16:28.31+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(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,321
Reputation points
commented 2021-07-02T10:03:40.89+00:00
PRADEEPCHEEKATLA-MSFT
84,051
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Help with ResourceNotFound error when open image link
This is my image https://storageaccountimage85a4.blob.core.windows.net/storageaccountimage85a4/images/11173.jpg I uploaded this image and when I open the link that is provided by azure for access, I see this error: <Error> …
asked 2021-06-27T16:36:58.57+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(118.4, 50%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
urkqsrk
21
Reputation points
commented 2021-06-29T04:00:35.677+00:00
PRADEEPCHEEKATLA-MSFT
84,051
Reputation points Microsoft Employee