Azure Data Explorer

  1. Provide short circuit evaluation on "or" and "and" operators

    The logical operator page (https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/logicaloperators) says nothing about whether the operators support short-circuit evaluation (https://en.wikipedia.org/wiki/Short-circuit_evaluation). If it does support it, it would be great to be added to the documentation. If it doesn't support it, it would be great to either support it, or at least add in the documentation that it isn't supported.

    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 →
  2. Provide a way to define a tuple of keys and reuse it in multiple places in a query

    I find myself having a lot of queries with a pattern similar to the following:

    table1 | summarize Sessions = dcount(Session_Id) by Column12, Column5, Column42
    
    | join
    (table2 | summarize ErrorSessions = dcount(Session_Id) by Column12, Column5, Column42)
    on Column12, Column5, Column42
    | sort by Column12, Column5, Column42

    The worst part in repeating the keys again and again, besides readability, is that it makes it harder to maintain such queries, as any time I add or remove a key I have to update all of the locations to keep it consistent.

    What I suggest is to have a way to define…

    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 →
  3. [Share Dashboards] Provide ability to provide access to dashboards to everyone in the org

    I have to individually add emails of each person I want to give the access to. It is very frustating as people keep getting added to the email threads and I need to keep track of it for access

    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 →
  4. Provide a function to get Month name of current Date. To get this we have to write so much logic rather giving tbe format like 'MMM'

    Please provide the option to get the month name or current date, to get this we need to lot logic in Kusto.
    For example to get the following 07 Jul 2020 . There is no format name available in kusto.
    It will be useful when we are working dates.

    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 →
  5. Add support for additional pip-packages for Python plugin

    Add support for additional pip-packages for Python plugin. Would be nice if it's possible to pull packages from pypi.org AND private hosted pip repositories.

    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 →
  6. todatetime() does not comply to ISO8601 when converting milisecs

    ISO8601 states that BOTH , and . can be used as milisec separator
    todatetime only understands "."

    "2020-06-30 08:19:59.775" currently parses ok, but
    "2020-06-30 08:19:59,775" fails.

    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 →
  7. ingest

    Add a way to schedule ingestion (queued ingestion) with a kusto command on external table (i.e. ingesting a huge external table reliably).

    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 →
  8. Make extent replacement idempotent

    When clients lose connection with the Kusto server during .replace extents in table commands they may end up retrying a command which succeeded, resulting in the data in the destination table being deleted instead of transferred. Adding a way for the client to specify something like ingestIfNotExists would resolve that issue. Alternatively, having an option to prevent the command from going through if there is no source data would also prevent the deletion.

    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 →
  9. Provide visibility on the data management VM utilization

    The data management SKU selected is dynamic and scales with load on the cluster. The only visibility we have on the selected SKU is via billing.

    The provided metric 'ingestion utilization %' does not correlate with scale up/scale down events.

    If we could see and monitor the metric that drives autoscale for the DM tier, we could then work to optimize our ingestion.

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

    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 →
  12. 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 :

    {

    "{OriginalFormat}": "l1 cache hit for key {key}"
    

    }
    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…

    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 →
  13. Let me tag a database as favorite

    Let me specify databases in the connection pane as my Favorites and then scope my view to only them. It is exceedingly frustrating to have to scroll through a huge list of databases to find the only two I care about. See attached picture for example.

    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 →
  14. Provide a role for Function Admin

    We need an ability for a principal to only manage functions in our cluster and want it to be assigned an admin role just for that. It should have ability to alter/delete other tables in teh database. Currently the only supported role for this is "Database admin" which gives too many permissions. With Database User this principal can create and alter functions created by itself only and not functions created by other principals in the database, which is what we are looking for. To workaround this we had to add admin for each and every function in our database explicitly…

    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 →
  15. Homepage with Deployed Build Changes

    Last week (Dec 20), we were unfortunately hit by an ADX production change that broke our ingestion processes for quite a few hours. Luckily the change was rolled back.

    It would be quite valuable to have some place that listed the changes that are deployed against ADX whenever that build is released. That way we can see what might have happened.

    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. Ability to use time series and anomaly chart in Azure/Jupyter notebooks

    Currently the anomaly chart works only on Kusto explorer. I would like to add anomaly and forecasting in Azure notebooks.

    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 →
  17. Azure Data Explorer vs. Time Series Insights

    When do you recommend Azure Data Explorer time series capabilities vs. Azure Time Series Insights.

    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 →
  18. Extend string operator =~ to support foreign and accented letters.

    In Kusto:
    print "ÉCOLE" =~ "école" // FALSE
    print "COLE" =~ "cole" // TRUE
    print tolower("École") == "école" // TRUE
    print "SØD" =~"sød" // FALSE
    print tolower("SØD") == "sød" //TRUE

    The tolower() function supports scandinavian letters 'ÆØÅæøå' and the French accented letters. But the string operator =~ does not.

    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 →
  19. Local Query (like dgrep)

    Oftentimes a kusto query will return a time-intensive, large dataset. If I then need to tweak my query, I'll have to execute it in its entirety once again. dgrep avoids this problem with a muti-tiered query system; server-side and local.

    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 →
  20. .show functions gives the detail of function available in database If this can be extended for getting usage metrics like how many time fun

    .show functions gives the detail of function available in database
    If this can be extended for getting usage metrics like how many time function invoked in last 30 days. Might be helpful.

    .show functions usage -d 30

    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 →
  • Don't see your idea?

Azure Data Explorer

Categories

Feedback and Knowledge Base