Azure Data Explorer

  1. Run a query in sliding windows intervals

    Given a logical computation of a query, it is highly useful to run it for few predefined sliding windows.

    This usually requires a lot of query manipulations, and it would be useful to have a built-in option. A built-in solution can take advantage of all possible optimizations/pitfalls which can be avoided.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add notifications in the portal for the upcoming deployments from the Data Explorer team

    The customer is facing cluster error while running queries during the deployment/upgrade/fix/maintenance from the Data explorer team.
    It would be helpful if the Data explorer team add notifications for the upcoming deployments in the portal.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Kusto DOS outage: Allow granular throttling of kusto query requests at App or user level

    In our current Kusto outages, certain apps are found to be querying too much which in turn has increased the Kusto ingestion queue increase to 100k. It would be great to have Kusto some granular controls at app or user level to limit how much querying can be executed.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Create New Management Function to Create Data Connections

    You can script deployment of a Data Explorer cluster using an ARM template. Everything works, except data connections. This is because the validation requires target tables to exists before creating a data connection.

    I suggest a new management function is created that works something like this:

    .create data connection with (name="", kind="EventGrid", storageAccountResourceId="", eventHubResourceId="", consumerGroup="", tableName="", dataFormat="", mappingRuleName="")

    This way I can create data connection in a .csl file along with tables, functions, policies etc.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. Have an desktop client that allows sharing of queries, i.e. integration with data studio

    It would be awesome to have the capability to connect to Azure Data Explorer from Azure Data Studio so I can use one IDE for all my data style analytics.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow cluster() to take function/variable values

    When referencing different clusters - espcially w/ the advent of Dashboards and Parameters - it's cumbersome to require each cluster reference to use a string literal. These could be better handled and a better experience delivered by allowing the input to cluster() to take a function or variable value instead of having to be a literal.

    This request comes from https://github.com/MicrosoftDocs/dataexplorer-docs/issues/359

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Feature Request: Capability to output Ingestion Error/Failed data into blob storage.

    Currently, it is very hard to get the data having issue and fix the wrong part because users cannot view the data even though error messages are shown. Basically, users ingest millions of data from data source like Event Hub/IoT Hub etc... data comes from a variety of devices etc...
    So the ability to easily specify the data is necessary for smooth error handling.

    Sometimes, error messages have internal storage path where the error data are stored. But users cannot get the data/files from there.

    Please consider the ability enhancement.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Provide tenant level connection string

    It would be awesome if there was a Tenant level connection string to show all LA/AI databases that you have access to. Similar to https://ade.loganalytics.io/tenants/<tenant-id>

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. Follow at the table level

    We love the database follower feature but it would be fantastic if we could follow at a table level.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Use VNETs configured DNS servers so Private Endpoints work as expected when installing ADX into VNET.

    When using Private Endpoints for storage or anything else and ADX is deployed into a VNET, please have ADX use the configured DNS servers for the VNET rather than hard coding to Azure DNS. This keep the extra work of maintaining a Azure Private DNS just for ADX when there already is a custom DNS being managed by the customer.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Paste python code as is in KQL

    Currently in order to use the python() plugin you need to "deorate" each line of the python code with quotes and new line character. This is cumbersome and inconvenient. Suggest to support writing/pasting standard python code without any artificial additions when the user types in the context of the Python plugin

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Allow direct ingestion through EventGrid

    We use event grid for flexible event broadcasting to multiple microservices and external components, and Kusto has been extremely helpful for keeping an event log for later triage and monitoring. Today, we have to go through an Event Hub in order to make this work, but allowing a direct pipe from Event Grid to Kusto would make things simpler to set up, cheaper, and more flexible!

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. Operator to support optimized time window join

    Would be great if the pattern documented here: https://docs.microsoft.com/en-us/azure/kusto/query/join-timewindow could be its own operator. I use this pattern semi-frequently, and always have to look up the example on the docs site to implement it correctly, would be handy to have it encapsulated as a supported operator

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Queued ingestion Status Tracking

    Support the queued ingestion Status notification integration. Maybe EventGrid or Webhook. Customer can continue monitor and handle the integration job without the pull status from queue by time interval.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add the ability to control the cluster resource utilization (CPU, Memory) per database or user

    We would like to control the cluster resource utilization (CPU, Memory) per database or user

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  16. [Role] Provide ability to give Viewer Role at Table level

    Currently, Table level can only have admin, ingestor role. I would like to have viewer role at table level as well.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Too many kust queries should not cause ingestion queue buildup

    In our recent Kusto outage, we have seen that too many Kusto queries were able to increase the ingestion queue by 100k. It would be good to have isolation between the querying and ingestion processes inside Kusto infrastructure so that these don't impact each other.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add follow DB management options in Azure Portal

    Add follow DB management options in Azure Portal
    Attach DB to a leader
    Detach a follower DB

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. summarize percentiles() result rounding

    Let’s say I have some intermediate query that results in numeric fields rounded to one decimal digit. Then I want to summarize them with percentiles(). This produces phantom values, not in the original set. Mock example:

    range value from 0.3 to 133 step 0.1
    | summarize percentiles(value, 25, 50)

    Result:

    percentile_value_25 percentile_value_50
    
    33.3099999999999 66.5999999999999

    I understand this is because of the statistical estimation. But formatting the final result nicely becomes a chore, especially if it uses percentiles() multiple times and/or with many percentile points.

    | project value_p25=round(percentile_value_25, 1), value_p50=round(percentile_value_50, 1)

    What I’d like to be able to do is something…

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Allow database settings on follower cluster to be different to the lead cluster.

    Currently when a database is attached to a follower cluster, it inherits the name and cache settings from the lead cluster.

    Please allow the database name to be different, as this can help where multiple lead clusters across different environments have the same name.

    Would be nice to be able to set this in the AttachedDatabaseConfiguration constructor, along with the cache policy.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Azure Data Explorer

Categories

Feedback and Knowledge Base