Azure Data Explorer

  1. 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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Push rows to EventHub

    Enable pushing rows to EventHubs.
    * individual or batched messages

    Example (alerting):
    * IoT data being consumed by ADX
    * An update policy is in place that checks the incoming
    * If the check fails then a notification should be sent to an EventHub
    -> picked up from there by other components

    13 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. bag_unpack should provide an option to overwrite values in existing columns instead of throwing an error

    Today, evaluate bag_unpack throws an error when the column that is being unpacked already exists in the input.

    In the case where people start sending telemetry unpacked, realize they need to pack it for better cogs and better schema management, they are going to run into cases where the column already exists. An option to just overwrite the value in the result instead of throwing an error will be very useful.

    4 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 →
  4. Query builder using Fluent Interface pattern in Kusto SDK

    I think it would be great if you add a query builder to the SDK that uses Fluent Interface for building Kusto queries. Something very similar to how you can query SQL databases using Entity Framework.

    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 →
  5. Translate IP addresses to geo coordinates


    • Given an IP-Address

    • There should be a native KQL function to translate the IP address to a coordinate

    • This will enable the user to enrich telemetry from server/app logs with the corresponding location

    5 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 →
  6. 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

    3 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. Add AAD Account Switcher to Web Explorer

    Add the ability to switch AAD accounts via an account switcher, similar to what is available at portal.azure.com. This is the most frequent request for LinkedIn customers.

    3 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. Allow mapping from Properties, SystemProperties collections on Event Hub data ingestion

    For data ingestion connections which point to Event Hub sources, allow the mapping definitions to access the Properties and SystemProperties collections on the underlying EventData object. Presently, only the Body property is accessible - it is define as the root/$ of the path in mappings.

    5 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 →
  9. 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

    2 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 →
  10. Allow Coloring of Rows

    I had a quick question about row coloring, as I’ve seen this happen for some rows which highlight error / warning. Is there a way for someone to add their own color scheme to a table result based on some column values of the row? Say if a column contains some particular text, mark that row red etc.

    3 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 →
  11. Provide max/min value in a new Windows function

    The max value till the current row.
    row_max ( Term [, Restart] )

    datatable(A:int)[4,5,6,1,3,7,4,8]
    | serialize
    | extend B = rowmax(A)
    | extend C = row
    min(A)

    The result of B is: 4,5,6,6,6,7,7,8
    The result of C is: 4,4,4,1,1,1,1,1

    It is useful for the ip v4 range comparison. Sorted the ip prefixes by the first address and get the max value of its last address for an IP prefix. It will significantly reduce the complexity of the prefix comparison to detect overlap IP prefixes.

    1 vote
    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. Support ADX into Azure ARC data Services

    Support ADX into Azure ARC data Services

    1 vote
    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 →
  13. Support escaping curly brackets in queries, and json field access

    See https://stackoverflow.microsoft.com/questions/192467

    Our Kusto data contains fields similar to C# string interpolation :

    {

    &quot;{OriginalFormat}&quot;: &quot;l1 cache hit for key {key}&quot;
    

    }
    The field is in JSON format.

    I tried to extract the value using different notations, but without success :

    field[(0)] or field[(1)] - returns nothing
    field['{OriginalFormat}'] - this returns an error Parameter 'OriginalFormat' value was not provided

    Then I tried to filter the records using where clause :

    |where customDimensions !contains "l1 cache hit for key {key}"
    which didn't work by returning the error Parameter 'OriginalFormat' value was not provided

    I tried escaping using \ but I couldn't…

    1 vote
    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. Provide out of the box resource governance for Kusto clusters

    Our Kusto cluster is used for production site and tools and needs to have 99.99% availability. However, as our cluster is open to tens of thousands of users across the company for ad-hoc queries, we often suffer from unexpected cluster wide outages due to misbehaved customers. We have tried both cluster-wide query limits as well as customized approaches, however, neither is helping us much. We would like to see Kusto to provide the resource governance solution out of box.

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

    We’ll send you updates on this idea

    planned  ·  5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    2 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 →
  16. 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.

    1 vote
    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. Make sum() and sumif() "nullable"

    Include an option in sum() and sumif() like this: Foo = sum(Bar, nullable). The "nullable" option causes a sum of null values to be null rather than zero. A sum of null and non-null values would sum the non-null values, returning a number. The use case: to detect the total absence of data (all rows null) in an aggregation. This is important for telemetry applications (e.g., error counts) where zero is the "good" value. This feature would allow us to easily distinguish between the total absence of data, and the presence of some measurements whose value is zero. (I have…

    1 vote
    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. 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.

    1 vote
    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 →
  19. 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.

    1 vote
    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. 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

    1 vote
    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 →
← Previous 1 3 4 5
  • Don't see your idea?

Azure Data Explorer

Categories

Feedback and Knowledge Base