DataExplorer | Automate Data Exploration and Treatment | Data Visualization library

I am trying to estimate Azure Data Explorer cost by using the suggested tool Azure Data Explorer Cost Estimator.

Entering the data below i get a total amount if $984 (if i add Kusto Markup fees which are only discounted until 17th May but we will on in Production beyond this date).

When i increase the value in the "Data collected (TB) per day" field to 0.02 the total price drops to $837.

I understand, that the reduced price comes from suggesting only 2 Engine-VMs instead of 3 for the first amount of data. My assumption is, that 2 Engine VMs of Type D11 are more powerful than 3 VMs of E2A_v4 VMs.

In this case my plan would be to start with D11 Engine VMs and get more power for less money.

Is my assumption correct and does this plan make sense or is there anything i am missing?

Thanks for any suggestions.

I am in the process of making my first React-Flask app. I'll probably get murdered for my code as a beginner but here goes.

I tried to make a video to show the strange behavior. It only seems to happen when the child component maps an array of values to render the desired output

The parent state is updated immediately which you can see in the console log.

However the child component only updates when something else of the page is interacted with.

Link to youtube video to show the weirdness:

https://youtu.be/ysFdCiWr51E

in terms of code

The child component is made of two layers:

Upper child layer:

My CosmosDB emulator works well when tested locally with a console application.

I want to connect from my Xamarin Android application, be it on the emulator or on a device on the same LAN. If with the emulator I connect to https://10.0.2.2:8081 with the CosmosDB client, in the debug console I see many repeated:

[0:] DocDBTrace Warning: 0 :

[0:] Endpoint not reachable. Refresh cache and retry

If with the emulator, with the browser, I connect to https://10.0.2.2:8081/_explorer/index.html I can access the DataExplorer.

I understood that I have to enable the /AllowNetworkAccess, so I shut down the emulator, deleted the CosmosDBEmulator data folder, and then:

.\Microsoft.Azure.Cosmos.Emulator.exe /GenKeyFile=cosmo.key

and then launched with

.\Microsoft.Azure.Cosmos.Emulator.exe /AllowNetworkAccess /KeyFile=cosmo.key

DataExplorer opens, and I try to create a db, but I receive this error:

So basically with /AllowNetworkAccess I receive an error even with its own web based DataExplorer, used locally.

I tried my app from the Android emulator, using the cosmos.key new key, and I get this error:

Microsoft.Azure.Cosmos.CosmosException: 'Response status code does not indicate success: Unauthorized (401); Substatus: 0; ActivityId: 626ab064-6c6e-445a-883a-8491de96636f; Reason: (Response status code does not indicate success: Unauthorized (401); Substatus: 0; ActivityId: 626ab064-6c6e-445a-883a-8491de96636f; Reason: (Response status code does not indicate success: Unauthorized (401); Substatus: 0; ActivityId: 626ab064-6c6e-445a-883a-8491de96636f; Reason: (Message: {"Errors":["The MAC signature found in the HTTP request is not the same as the computed signature. Server used following string to sign - 'post\ndocs\ndbs/localPlayGround/colls/containerPlayGround\nthu, 05 nov 2020 15:28:15 gmt\n\n'. Learn more: https://aka.ms/cosmosdb-tsg-mac-signature"]} ActivityId: 626ab064-6c6e-445a-883a-8491de96636f, Request URI: /apps/DocDbApp/services/DocDbServer1/partitions/a4cb494d-38c8-11e6-8106-8cdcd42c33be/replicas/1p/, RequestStats: RequestStartTime: 2020-11-05T15:28:15.8263417Z, RequestEndTime: 2020-11-05T15:28:15.8403436Z, Number of regions attempted:1 ResponseTime: 2020-11-05T15:28:15.8403436Z, StoreResult: StorePhysicalAddress: rntbd://192.168.0.6:10253/apps/DocDbApp/services/DocDbServer1/partitions/a4cb494d-38c8-11e6-8106-8cdcd42c33be/replicas/1p/, LSN: 2, GlobalCommittedLsn: -1, PartitionKeyRangeId: , IsValid: True, StatusCode: 401, SubStatusCode: 0, RequestCharge: 0, ItemLSN: -1, SessionToken: -1#2, UsingLocalLSN: True, TransportException: null, ResourceType: Document, OperationType: Query , SDK: Microsoft.Azure.Documents.Common/2.11.0, Please see CosmosDiagnostics, Linux/Unknown cosmos-netstandard-sdk/3.14.0);););'

Any suggestion on what am I doing wrong? CosmosDB Emulator is 2.11.6

Thanks

Azure Application Insights uses the Kusto Query Language (KQL) that is clearly quite powerful, but I cannot seem to get it to aggregate nested data.

The best way to explain this is through an example. My actual situation uses different data, but has the same problem that I will explain here. Using the Azure Data Explorer there is a StormEvents table that has a State property, a StormSummary property, and many more. The StormSummary property is JSON that looks like:

I am trying to retrieve a single row of data based on an XML attribute.

The SQL I have so far is:

I have the following two queries which i am running on the azure kusto online query terminal

(available at this link - https://dataexplorer.azure.com/clusters/help/databases/Samples )

I've been trying to update a query on the DataExplorer that we use on our Gaming SE Site for keeping track of tags without excerpts to include an incremental row number in the results to make reading the returned values easier. There are a number of questions on here that discuss how to do this, such as this one and this one which appear to have worked for those users, but I can't seem to get it work for my situation.

To be clear, I would like something like this:

I have an APIM policy which logs to event hub like this:-

I want to assess the degree of spatial proximity of each point to other equivalent points by looking at the number of others within 400m (5 minute walk).

I have some points on a map. I can draw a simple 400 m buffer around them. I want to determine which buffers overlap and then count the number of overlaps. This number of overlaps should relate back to the original point so I can see which point has the highest number of overlaps and therefore if I were to walk 400 m from that point I could determine how many other points I could get to.

I've asked this question in GIS overflow, but I'm not sure it's going to get answered for ArcGIS and I think I'd prefer to do the work in R.

This is what I'm aiming for https://www.newham.gov.uk/Documents/Environment%20and%20planning/EB01.%20Evidence%20Base%20-%20Cumulative%20Impact%20V2.pdf

To simplify here's some code