Azure Data Explorer

  1. Kusto function iswhitespace() for string type

    Currently, there is no such Kusto function, and we are reduced to expensive operations such as replace whitespace with string.Empty and then check for string.Empty.

    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 →
  2. Enable users to debug more easily

    I got error below. I would like to directly view the data got error to identify what was wrong. So I would request for users to access files on the storage path of 'IngestionSourcePath' in the error message.

    There are a lot of data to ingest but only few data had error. So it would be better for users to check only data having issues, not all input data. It is definitely more efficient.


    'OperationId': xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx,
    'Database': xxxxx,
    'Table': xxxxxx,
    'FailedOn': 2020-08-21T07:39:11.4032288Z,
    'IngestionSourcePath': https://xxxxxxdtakexxxxxpfadx01.blob.core.windows.net/20200821-readyforaggregation/xxxxxxxxxxx.multijson.gz,
    'Details': BadRequestInvalidBlob: Unexpected token in JSON stream: StartArray (Line: 2, Column: 1, Path: ),

    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 →
  3. IPv6 Support

    The Azure Networking team has recently released IPv6 support for Virtual Networks: https://azure.microsoft.com/en-us/updates/ipv6-for-azure-virtual-network-is-now-generally-available-2/

    It would be great if there were support + guidance on how to deploy ADX in an IPv6 virtual network. This may help customers who are already using or migrating to IPv6 in their own networks. Especially when there is already contention in an organization's IPv4 network space.

    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 →
  4. Create WebControl for Dashboards

    Create a web control in the dashboards where you can paste HTML/JS that can render data individually but gets data from adx query like other controls

    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 →
  5. Provide ADX consumption based plans

    Create a "managed" ADX version where you can book a shared instance where you pay based on query time and storage instead of running server + storage. This would be a perfect match for small project or even for putting home automation data into a great database

    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 →
  6. IP KQL Functions

    Would be great to have additional KQL functions for working with IP address.


    1. Check if a string is a valid IPv4 address

    2. Check if a string is a valid IPv6 address

    3. Convert IP Address and Subnet to a CIDR String (see example for IPV4 below, would be great to have something that works for both IPv4 & v6)

    .create-or-alter function with (docstring = "Takes an IPv4 address and IPV4 CIDR block as input, returns CIDR notation string") ipv4cidrstring(ip:string,cidr_block:int) {

    let long_ip = parse_ipv4_mask(ip, cidr_block);
    
    let ip_0 = binary_and(binary_shift_right(long_ip, 24), 255);
    let ip_1 = binary_and(binary_shift_right(long_ip, 16), 255);
    let ip_2
    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 →
  7. Column retention policy

    Feature Suggestion:
    Add support for retention policy in a column level.

    Why?
    As part of our work on keeping privacy and GDPR compliances we are making sure that we are storing only data that we are allow to and only to a specific period.
    I faced a weird situation where I got a an approval to keep all my table’s data for two years period but I had to exclude ONE column as the allow retention period for this column is only 3 months.

    All today solutions are not good enough (remove the column, set the entire table retention for…

    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. Cancelling in-flight queued ingestions

    There can be cases in which i would like to discard messages posted for ingestion, after figuring out that something went wrong, or is no longer relevant.

    this is especially relevant when the size of the queue is really large.

    at the moment, the "best solution" is to drop or rename the target table, and patiently wait for all ingestions to fail (which could take a long while)

    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 →
  9. Merge Tables

    When ingestion historic data it might be that formats changed over time. When all is ingested into the same table it is difficult to delete rows in case of an error. It would be great to be able to check data first and merge it manually or after a specified time into a different table.

    3 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 →
  10. arm

    Create / Alter tables in ARM Templates.

    This would be useful, among other scenarios, to leverage the current data-connection ARM template which requires an existing table.

    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. 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 →
  12. Provide option to change the default settings like Sort By order, Join type

    By default ADX sorting order is descending. The join type is InnerJoinunique. It would be great if we can change this through user configuration. Any one coming from SQL server to ADX, the transition will be easier if we apply similar settings.

    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 →
  13. Expose total/scanned extents in .show commands-and-queries

    We're using the total/scanned extents query stats to help organize our data and adjust queries for better perf. It's great that we can see total and scanned extents and rows in the query stats for individual queries, but it would be more helpful to see it across all queries. Can this be exposed in .show commands-and-queries?

    "inputdatasetstatistics": {

        "extents": {
    
    "total": 1243,
    "scanned": 1243,
    "scanned_min_datetime": "2018-12-21T23:48:35.9882144Z",
    "scanned_max_datetime": "2019-11-19T19:07:38.4628229Z"
    },
    "rows": {
    "total": 10474198499,
    "scanned": 10474198499
    },
    "rowstores": {
    "scanned_rows": 0,
    "scanned_values_size": 0
    }
    },

    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 →
  14. Add Operation Text, Database to .show operations

    It would be useful to be able to see all currently running commands similarly to how we can see .show running queries. I have this query which shows me the currently running operations, but it does not have the level of detail that the .show commands query returns:

    .show operations
    | where StartedOn > ago(1h)
    | sort by LastUpdatedOn desc
    | summarize max(LastUpdatedOn), makelist(State) by RootActivityId, Operation
    | where list
    State !contains "Completed" and list_State !contains "Failed"

    Specifically, it would be useful to see the database context in which the operation was running as well as the command text…

    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 →
  15. Include function call stack trace in query error messages

    Picture this scenario: you are calling a Kusto function but get a syntax error. But where is the syntax error coming from exactly? The error message doesn't say. You inspect the code for the function only to find references to other functions inside, and the way to know which one of those is the culprit is to run them one by one. And then each of those functions might be calling other functions too!
    Wouldn't it be nice if the error message told you the exact function where the error is happening from?

    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 →
  16. Support 0 as number of minimum node of cluster

    We sometimes use this query engine once a day or so. We want to avoid manage start up node. it's fine to it takes to start up and load data time and hope Azure Data Explorer support "0" (Zero) number as minimum cluster node.
    We want to get OPTION for that...

    Similar Services- Azure Machine Learning Services - AmlCompute.

    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 →
  17. Enable functions to return multiple tables

    Functions today can only return one table. It would be really helpful if functions were able to return multiple tables to facilitate parallel queries.

    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 →
  18. Time Discrete view for power bi.

    We use ADX as time series DB and
    a BI dashboarding tool (power bi)

    But BI don't like non Discrete time events, no calculations are possible, and the Bi aggregation are calculated not correctly (group by, avg)

    If we have a time discrete view , every BI tool will work very lovely.

    Comment:
    Make series are nice, but will not work , because it's in the pipelines before power bi, and the query optimizer will fail, an calculating a make series for all our 3 million device's an than lock to the power bi where time and device filter.

    Maybe…

    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 →
  19. RBAC, current principal details and row level security

    Please add the Roles of user to the output of currentprincipaldetails()
    in order to allow usage of these Roles in Row Level Security Policy.

    2 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 →
  20. Support weighted average aggregation function

    I'd like to be able to do something like the following:

    Table
    | summarize wavg(column, weightcolumn) by othercolumn

    Where "wavg" computes a weighted average of the first column using the 2nd column as weights.

    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