Azure Data Explorer

  1. Azure Data Explorer setting to display datetime values in local timezone

    Can Azure Data Explorer support displaying datetime values in local timezone with a setting?
    I'm a bit tired of extending all queries by doing time arithmetic myself (e.g. | extend localT = timestamp - 8h) which is not daylight saving proof as well :)

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

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. External tables column mapping gets mixed-up when the underlying file column structure is updated for some files

    When using external tables to map files on a storage account, if one has many files already mapped to an external table, and the file structure changes for new files provided to the same storage account location, such as a new column is added to the new files, then the external table mapping get mixed up. We drop the external table and recreated it, adding the new column (which is not added to the end of the new file structure). When querying the external table, ADX provides the new file data in the correct columns, but shows the previous file…

    16 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. Support for features related to GDPR requirements

    As of today we'd have to develop custom solution over ADX in order to support some of the GDPR requirements (list below). It'd be nice to have following features as native capabilities in ADX.


    1. Data classification - possibility to mark a table or column in a table as GDPR relevant data that way query / ingestion logs can be filtered based on the data category


    2. Stream audit logs (read / append / management) for GDPR relevant tables. These logs can be streamed into Storage Account or Log Analytics similar to the Diagnostic Logs setting


    3. Capture the source of ingestion for…

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

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

    10 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. Make http_request and http_request_post plugins work and supported.

    Calling to external resource to download data through HTTP(S) protocols is an awsome idea, unfortunately the plugins do not work correctly and are not supported yet. Consider to speed up the work on it, please.

    15 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. Allow cluster() to take function/variable values

    When referencing different clusters - espcially w/ the advent of Dashboards and Parameters - it's cumbersome to require each cluster reference to use a string literal. These could be better handled and a better experience delivered by allowing the input to cluster() to take a function or variable value instead of having to be a literal.

    This request comes from https://github.com/MicrosoftDocs/dataexplorer-docs/issues/359

    8 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 →
  8. Use VNETs configured DNS servers so Private Endpoints work as expected when installing ADX into VNET.

    When using Private Endpoints for storage or anything else and ADX is deployed into a VNET, please have ADX use the configured DNS servers for the VNET rather than hard coding to Azure DNS. This keep the extra work of maintaining a Azure Private DNS just for ADX when there already is a custom DNS being managed by the customer.

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

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Rename Azure Data Explorer to Kusto

    Searching the Internet for Azure Data Explorer is hard because the name matches too many othe things. Pleasu just take the old name Kusto to make searching for answers easier

    16 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. Provide support to render timepivot / timeline view

    The Timepivot visualization is one of the best visualizations we have come across when analyzing data across hundreds of different tables. It tells the story of “what happened” in a beautiful manner.

    It helps us generates multiple different views of the “same data” by allowing us to pick multiple levels of slicing options views (in this case I have 10 slice options, so for two levels I can get about 90 different views). In addition, clicking on the cells shows the actual activity in detail.

    Given that Kusto is time-optimized and practically every log has timestamps associated with them, we…

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

    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 →
  12. Dashboard embedding in applications

    Add logic to embed entire dashboard in 3rd party application

    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 →
  13. Export data from one ADX cluster to a second ADX Cluster

    Add ADX as a destination for the .export capability to be able to move data from one cluster to another. This should work both for one time export and for continuous export.

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

    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 →
  15. Add ADX as Trusted Microsoft service on firewall

    Please consider to add ADX as a trusted Microsoft service on Azure Event Hubs' (or any other data source service's) firewall or publish IP address range of ingest service.
    For now, we have to deploy the cluster with VNet in order to restrict access of Event Hubs but it seems unnecessary since the traffic between Azure service is completed inside Azure network.
    This option makes it simple/easier for the users to create secure environment.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Disable current() functions

    We would like to have a the ability to disable the following functions from the query language, preferably using a client request property:

    • currentclusterendpoint()
    • currentdatabase()
    • current
    principal()
    • currentprincipaldetails()
    • currentprincipalismemberof()

    This is important for hiding internal implementation from external users.

    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. [Share Dashboards] Provide Cross Tenant Sharing of ADX Dashboard

    I would like to have the multi-tenancy support on the ADX Dashboard where i can share the Dashboard to another tenant's user which i have shared the database to.

    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 →
  18. 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 →
  19. 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
    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. 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?

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

Azure Data Explorer

Categories

Feedback and Knowledge Base