Azure Data Explorer

  1. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. Table Level Security

    Add read and write access at table level

    11 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 →
  6. R sdk

    In r studio, we want to get our time series data,

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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Time weighted Avrage

    A time weighted Aggregation are needet because ussaly IOT data are compressed, this mean, if the values are not changing, no new entrys are transmitted.

    A normal avg will get errors.

    Also it will be nice, if this Aggregation is also avaible in make series command.

    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 →
  9. Add Azure Data Explorer to Azure Stack

    Provide ability to run Azure Data Explorer on Azure Stack

    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. Azure data factory v2 : Task to Trigger a Trigger or Collection of Triggers

    It would be great if we can have a task inside the pipeline to trigger a trigger or more than one trigger.

    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. LINQ support / Fluent Query Builder APIs for .NET and Python

    The Kusto SDKs are very good, but it would be even better if instead of handling Kusto queries as strings, we could write them using a fluent query builder library. It would be awesome if Kusto supported LINQ for .NET, meanwhile for Python, a simple query builder DSL should be possible.

    18 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. Row level security

    Add read and write access at row level within a table

    20 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. Duplicate removal during ingestion

    enable configurable capability to remove duplicate rows during ingestion

    12 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. Geo data types and spatial queries

    Natively support geo data types and spatial queries to enable geospatial analytics

    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 →
  15. Add option to ingest from Azure Data Lake Store

    It would be great if we could ingest from Azure Data Lake Store instead of just Azure Blob Storage.

    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 →
  16. Add option to ingest Azure Storage folders

    It would be great if we could ingest a folder containing multiples files in Azure Storage, for example by using wildcards, instead of having to ingest all files individually.

    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 →
  17. Add option to define separator and escape characters for Csv ingest

    It would be great if we could customize the separator and escape characters when ingesting Csv files because sometimes the Csv aren't according to the general rules for Csv.

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

Azure Data Explorer

Categories

Feedback and Knowledge Base