Azure Data Explorer

  1. Support drop all functions in a db.

    Please provide an easy way to drop all functions in a db.

    this does not work:
    ".drop function <| .show functions"

    The currently proposed workaround from the Kusto Team does not appear user friendly:

    a. Run the following command

    .show functions
    | summarize run_me_with_caution_after_carefully_reviewing = strcat_array(make_list(strcat(".drop function ['", Name, "']")), "\n")

    b. Copy the result and save as a script (text file)
    c. Use Kusto.Cli to run the `script`
    d. [hope your team members don’t get mad at you. or me. If anyone asks – a) I had nothing to do with functions getting unintentionally dropped; b) they can be…

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

    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. Azure data explorer ingesion: json mapping only in single line

    I’m ingesting data to Azure Data Explorer from Logstash and figured out a feature that makes uncomfortable to use.
    If I put ‘enter’ between query, it occurs syntax error.
    (e.g. .If I write [create table sampletable
    ingestion json mapping ‘samplemapping’ (…)], it doesn’t work. If I write with one line, it works with no error)

    If it fixed, it will be very helpful to introduce ADX to customers :)

    2 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. Cross-region follower support

    Our main way of doing resource governance is to rely on follower databases. We have a locked down production cluster which doesn't accept any non-production workload and then if anyone else needs access to the data, we have them set up a follower database. It sounds like ADX has a single-region restriction for those follower databases and this is going to put a pretty major kink in our arch. Please consider adding this feature.

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

    We’ll send you updates on this idea

    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. correlate kusto ingestion failure with status queues

    Currently, kusto ingestion calls don't return success or failure immediately. We need to query the status queue. If we have a lot of updates happening, there needs to be a way to relate success or failure to ingestion request.

    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. Integration with Azure portal dashboard. Create a tile in portal.azure.com that queries a kusto cluster.

    I'd like to be able to create a dashboard on the Azure portal that executes kusto queries against any kusto cluster. Today, you can pin any azure monitor kusto query to the dashboard. I'd like to do the same for my own kusto cluster.

    There is a feature to export to Power BI, but it would be great if there was integration Azure portal as well

    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 →
  7. Ability to view and change data management endpoint SKU from Azure Portal

    Currently it's required to create a support ticket in order to change the data management endpoint SKU when there is a need for scaling the ingestion through event hub to a database table in ADX. The ability to view and change the endpoint scaling from the portal would be a great feature.

    4 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. Permissions by views

    I would be useful to be able to restrict specific users to only be able to access data to a specific view
    (without direct access underlying tables). This could enable use to limit specific users access to time series data for a specific period or specific equipment.

    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 →
  9. Mapping EventData properties during Event Hub ingestion

    When configuring a JSON Ingestion Mappings pre-created on a table, we couldn't map and access Properties which are set by Event Hub service in the EventData.SystemPropertiesCollection structure of each received message. These Properties are:
    • PartitionId
    • SequenceNumber
    • Offset
    • EnqueuedTimeUtc

    But also we could have to map any custom properties that we want to store in the same collection when sending messages to event hub.

    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 →
  10. Plugin support for the desktop application

    It would be great if there were a way to add a plugin to the desktop version of Kusto Explorer.

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

    2 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 →
  12. project wildcard support

    It would be great if we could provide wildcard support for the project statement. This would be helpful in prioritizing certain columns visually (i.e. column 'x' first, column 'y' second) while still accommodating for the dynamic nature of Kusto function output.
    When creating functions in KQL you typically end up with dependencies which cause a version of one function to return more \ different columns than before. Right now, for me to reorder columns I would need to project them all individually - and when versioning functions this can have a huge trickle-down effect that causes a bunch of unnecessary…

    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 →
  13. WithAadUserPromptAuthentication method not available in .NetStandard library

    In Kusto.data Nuget for .NET framework WithAadUserPromptAuthentication method is available in KustoCOnnectionStringBuilder class.

    However this is missing from .NetStandard Nuget library.

    Can this be added?

    Eg:

    KustoConnectionStringBuilder($"https://{serviceName}.kusto.windows.net") .WithAadUserPromptAuthentication(authority);

    4 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 ContainsAnyOfTheFollowing operator

    Just need the following native kusto function:

    Mytable
    | where field1 containsAnyOfTheFollowing (“a”, “b”, “c”)

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

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

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    4 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. Downsampling data over time

    As data ages, storage and query could be further optimized by down sampling the data. There should be a process or method to provide an aggregate query that could run on data older than X time. Example: My database retention is 365 days and i ingest 3 samples per minute. After data is 31 days old i can provide a query that will aggregate by MAX value over 1 minute. After 90 days, another aggregate runs that finds the Max value over 5 minutes. Raw data is of course deleted after aggregate runs.

    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 →
  18. Add syntax for aggregation over partitions

    It would be helpful to have KQL syntax for expressing aggregation over a partition without summarization.

    Something like adding a "by" to an "extend" clause:

    StormEvents
    | project State, EventId, StartTime, DeathsDirect
    | extend TotalDeathsDirectInState = sum(DeathsDirect) by State

    Currently the only way to do this in KQL is by joining to a subquery. The equivalent SQL is like:

    SELECT
    State,
    EventId,
    StartTime,
    DeathsDirect,
    SUM(DeathsDirect) OVER (PARTITION BY State) AS TotalDeathsDirectInState
    FROM StormEvents

    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 →
  19. Copy Permissions from one ADE DB to another

    I have multiple ADE databases within the same cluster, i would like to have the ability to copy permissions from one DB to another using an internal tool instead of doing so manually.

    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. Table Level Security

    Add read and write access at table level

    4 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

Feedback and Knowledge Base