Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Azure Data Explorer

  1. Multiline comment in kusto

    Be able to comment out multiple lines using /* */ for example

    14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Enable AllDatabasesAdmin role to create volatile databases

    After the database creator role went away, we no longer have a supported way to create volatile databases. E.g. running this command is not supported under the existing set of roles: '.create database TestDB volatile'. Please enable a different role, saw the AllDatabasesAdmin role, to run this type of control command and be able to create volatile databases.

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    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.

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. Notification for Async Commands Submitted to ADX

    When using async queries in ADX such as purge, ingest-from-query, export, etc., the query returns an operation id. Currently, we need to have an application (Azure Function / Logic App) that actively checks for the status of these submitted operations.

    The request is to have ADX notify when such the submitted async operations are completed instead of active polling from application side. Ideally, ADX can emit the status events to Event Hub / Event Grid which can be subscribed with event listeners (e.g., Azure Function) that takes corresponding actions after the operation on ADX is completed (e.g., update status in…

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add Azure Data Explorer to Azure Stack

    Provide ability to run Azure Data Explorer on Azure Stack

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Need an option to select the datetime format when csv export to an external table

    Currentlhy the format used for datetime values in csv export is “yyyy-MM-dd HH:mm:ss.fffffff“ in UTC. Need an feature to configure that differently like ISO 8601 format “%Y-%m-%dT%H:%M:%s%z” or convert it to local time zone.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow accessing other databases within a RLS let statement

    New RLS functionality has allowed our team to create RLS functions that are data driven; identity to permission associations come from a table.

    However, tables and objects in other databases may not be accessed from within the let statement of the RLS function. In our case, that means we need to copy two tables to each of up to 10+ databases in our two clusters.

    Can the restrictions against the "database" notation be relaxed within the let statement of RLS functions?

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. Expose 'CPU load' in the statistics returned through C# client

    Add the 'CPU Load' heuristic (low/med/high) to the statistics returned to C#’s KustoDataReaderParser or any other class/API. Today this is only visible in the Query Summary in Kusto Explorer

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. [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.

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Follow at the table level

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

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. ADX admin have the capability to grant dashboard permission in addition to dashboard owner

    In many occassion, people know who to contact for ADX, but not knowning who is dashboard owner for requesting access permission. Without this capability, there'll be overhead to try to identify the dashboard owner for requesting access permission

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Add AllDatabasesMonitor role

    I’d like to be able to give a user or app the Monitor role for any database created on a cluster that I own. In the portal, I see that I can give AllDatabasesAdmin or AllDatabasesViewer. Can we please get a similar way to provide Monitor to all databases that get created on the cluster?

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Azure Data Explorer

Categories

Feedback and Knowledge Base