Forum Widgets
Latest Discussions
Welcome to Azure Data Explorer (Kusto) Space
Welcome to the Azure Data Explorer (Kusto) space @ TechCommunity. Join us to share questions, thoughts or ideas about Kusto and receive answers from the diverse Azure Data Explorer community. Our community is here to assist you with any question or challenge such as creating a new Data Explorer cluster, database or table, ingesting data or performing a complex query. Learn more about Data Explorer (Kusto): Azure Data Explorer Documentation Course – Basics of KQL Query explorer Azure Portal User Voice End to End Lab Azure Data Explorer Blog Investigate your data with Azure Data Explorer (Kusto). Question, comment or request? Post it here. BR, Azure Data Explorer product team17KViews17likes15Comments-- Microsoft Azure Storage Explorer || Private Endpoints on ADLS Gen2 --
I have provided access to my ADLS Gen2 through ACL. My users have at least the ACL r-x on the filesystem and on the subsfolders or files when need access to. From Home Office (through VPN) and using the client (MASE) "Microsoft Azure Storage Explorer" When the Public Ip of the users is whitelisted the client MASE (Microsoft Azure Storage Explorer) can access the ADLS Storage Account. When using Private Endpoints (tried 'dfs' and 'blob') I got the following error :SolvedJamesdldMar 31, 2020Brass Contributor10KViews0likes15CommentsAnnouncing an Azure Data Explorer AMA on January 27!
We are very excited to announce the next monthly Azure Data Explorer 'Ask Microsoft Anything' (AMA)! This will be happening concurrently with an Azure Data Explorer overview webinar. Watch the webinar and ask questions in real-time here. You can https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR17YPl-mgClOptPm_Ig3pnBUMFFCRUxTOVcwWUpVV1hVWFVGMUtIREhHSy4u The AMA will take place on Wednesday, January 27, 2021 from 9:00 a.m. to 10:00 a.m. PT in the Azure AMA space. Add the event to your calendar and view in your time zone https://www.myeventurl.com/Events/Details/187. An AMA is a live online event similar to a “YamJam” on Yammer or an “Ask Me Anything” on Reddit. This AMA gives you the opportunity to connect with members of the product engineering team who will be on hand to answer your questions and listen to feedback.EricStarkerJan 06, 2021Former Employee9.4KViews7likes11CommentsSummarize dynamic array?
Hi, I apologize for my lack of experience, however this is literally my first time using / learning about Azure Data Explorer. I have this data: | project Data1 = Data[0], Data2 = Data[1], Data3 = Data[2] where Data is in the form of an integer array: (something like [9, 12, 24]) I want to summarize the data to produce an output with the most common number for each index, so if Data was: [9, 12, 24] [17, 12, 37] [9, 17, 37] Then the output of the function would be: Data1 9 Data2 12 Data3 37 Is this possible? Thanks!bphillips09Aug 16, 2019Copper Contributor6.5KViews0likes8Commentssplit and regex in Kusco
Hi all, I have a query in Kusto to return Details from Table which returns multiple rows of sentence text: Table | project Details Output: Starting cycle 20349 Starting scheduling for cycle 20350 But I want to split the sentences by spaces and remove the numbers (so I can do aggregation on keywords) The split example in the help is on string literals so I can do this: Table | take 10 | project split(Details, ' ') but I then get an array of values in each row as output: Row 1 [ "Starting", "cycle", "20349" ] Row n... [ "Starting", "scheduling", "for", "cycle", "20350" ] How can I split multiple lines and get a row for each word in Kusto syntax? Thanks!Solvedmarked-dataMar 18, 2019Copper Contributor11KViews0likes6CommentsMissing method WithAadUserPromptAuthentication in Microsoft.Azure.Kusto.Data.NETStandard Nuget
I am using Nuget Microsoft.Azure.Kusto.Data.NETStandard (latest version published yesterday). With the previous version I used to get the following error. Kusto Connection String Builder has some invalid or conflicting properties: specified 'AAD Username password' authentication method has incorrect properties set. ', Please consult Kusto Connection String documentation at https://docs.microsoft.com/en-us/azure/kusto/api/connection-strings/kusto However, now the error changed and gives me further details as below. Kusto Connection String Builder has some invalid or conflicting properties: Specified 'AAD Username password' authentication method has some incorrect properties. Missing: [User ID,Password].. ', Please consult Kusto Connection String documentation at https://docs.microsoft.com/en-us/azure/kusto/api/connection-strings/kusto Once I provided User ID and Password, it succeeded. (Which I don’t want to) I also used KustoConnectionStringBuilder class from Microsoft.Azure.Kusto.Data Nuget (.net framework) allows me to connect with out passing user name and password with the below highlighted method. var kustoConnectionStringBuilder = new KustoConnectionStringBuilder($"https://{serviceName}.kusto.windows.net") .WithAadUserPromptAuthentication(authority); So my question is, Why is this method missing from .NetStandard Nuget?SolvedlakyedFeb 06, 2019Microsoft7.7KViews0likes6CommentsHow to query Log Analytics data into Azure Data Explorer?
Hi All, I need to query my Log Analytics workspace into Azure Data Explorer but i didn't fined any idea about it. Below are my doubts? 1. Do i need to ingest data from Log Analytics to Azure Data Explorer before utilizing it? 2. I didn't find any way to make a connection to Log Analytics into Azure Data Explorer? 3. The only option i saw to ingest data in Azure Data Explorer is through Event Hub. But now my issue is how can i ingest my log analytics data into Azure Data Explorer using event hub? Do i need to write any process to ingest? If anyone have then please share so that I can explore about it. Thanks,AmalayNov 22, 2018Copper Contributor9KViews0likes6CommentsWelcome to the Azure Data Explorer AMA!
Welcome to the Azure Data Explorer Ask Microsoft Anything (AMA)! This live hour gives you the opportunity to ask questions and provide feedback. Please introduce yourself by replying to this thread. Post your questions in a new thread within the Azure AMA space, by clicking on, "Start a New Conversation" at the top of the page.EricStarkerDec 02, 2020Former Employee1.8KViews2likes6CommentsReduce cost on VM for Azure data explorer
I have been looking for some way to control cost of dev subscription which we have been using. When it comes to cost the major one which stands out is virtual machine The service adding virtual machine is Azure data explorer which we have been using.Compute version which is selected by default in D11_v2 series. Is there anyway I can request yo move this VM to a cheaper version like B series since for Development its fine if queries take some time to execute and we won't have much data in dev environment.zainuvkFeb 09, 2020Copper Contributor1.3KViews0likes6CommentsPartial query failure: Low memory condition Kusto
I am getting below Error Message while executing query in Kusto "Partial query failure: Low memory condition (E_LOW_MEMORY_CONDITION). (message: 'bad allocation', details: ''). [0]Kusto.Data.Exceptions.KustoDataStreamException: Query execution has resulted in error (0x80DA0007): Partial query failure: Low memory condition (E_LOW_MEMORY_CONDITION). (message: 'bad allocation', details: '')" How to handle ?sonamjMay 06, 2019Former Employee26KViews0likes5Comments
Resources
Tags
- Azure Data Explorer (Kusto)66 Topics
- Kusto language36 Topics
- AMA16 Topics
- Ingestion8 Topics
- Azure Data Explorer6 Topics
- announcements5 Topics
- Azure Data Explorer AMA5 Topics
- microsoft fabric5 Topics
- Cluster Management4 Topics