Azure Data Explorer

  1. parse_ipv6

    The parse_ipv4() function works well for handling ipv4...but we also deal with a lot of ipv6. It would be very challenging to implement this correctly as in Kusto Query Language in an efficient way.

    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. User annotations of tables, columns, etc.

    Allow non-admin/author to annotate objects in the explorer pane.

    The use case is a consumer of data prepared by somebody else. The consumer has only read/query access. Reality is that schema get convoluted quickly. The names of tables, functions and cols aren't self-explanatory (quite often). Worse, real example, table1.RsrcId and table2.BladeId might mean the same thing. Though, only the consumer of both tables (possibly from different clusters) would care.

    Therefore, allowing users with read-only access to annotate would be instrumental. Said annotations should be share-able.

    1 vote
    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 the ability to alter configuration properties (like SKU, node count) when resuming a cluster

    when resuming an existing cluster via the Azure portal, I would like to be able to update configuration properties, like setting a new number of nodes, and a new SKU.

    Currently, it is required to wait for the cluster resume operation to complete, and only then is it possible to alter such configuration properties

    1 vote
    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. Add the ability to set the number of nodes at cluster creation time

    when creating a cluster via the Azure portal, I would like to be able to set the number of nodes, and not only the SKU.

    Currently, it is required to wait for the cluster creation to complete, and only then is it possible to scale it out.

    1 vote
    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. 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), make_list(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 associated. The…

    1 vote
    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. Dynamically execute a string as query

    The below query will create a string that represents an executable query. I want the ability to then execute that string. This way I can dynamically generate a query based on an existing Schema.

    SomeTable
    | getschema
    | where ColumnName endswith '_duration'
    | summarize Columns = make_list(ColumnName)
    // Make the query
    | project strcat('SomeTable | summarize avg(', array_strcat(Columns, '), avg('), ') by Day = startofday(Event_ReceivedTime)')

    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 →
  7. .show functions gives the detail of function available in database If this can be extended for getting usage metrics like how many time fun

    .show functions gives the detail of function available in database
    If this can be extended for getting usage metrics like how many time function invoked in last 30 days. Might be helpful.

    .show functions usage -d 30

    1 vote
    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. Allow creation of Tables & Data Maps in ARM template

    It doesn't make much sense that ARM template deploy of AzDEx allows for creation of Clusters, Databases, and DataConnections when DataConnections expliclity depend on a Table and DataMap to exist. In fact the error message is simply "Bad Input" with an "Internal Server Error" if somebody mistakenly tries to do this..

    DEx should be able to be fully-configurable via ARM including Tables and Datamaps so the existing capability of creating DataConnections via ARM is able to actually be used.

    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 →
  9. Ability to create user defined functions accepting variable # of arguments

    Some Kusto built-in functions accept a variable number of arguments, like:

    print strcat("foo", "bar")
    print strcat("foo", "bar", "baz")

    Please add the ability to create user-defined functions that accept a variable number of arguments as well.

    1 vote
    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. 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 →
  11. Autoscale form 1 VM on Azure Data Explorer's Data Management cluster

    Autoscale form 1 VM on Azure Data Explorer's Data Management cluster

    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 →
  12. Ignore (cold) cached data

    When perf testing a query, it would be useful to wipe out any cold data that has been temporarily cached on the local disk so that I can get apples-to-apples comparisons between subsequent runs. I can imagine it either being something where I just set a flag to ignore any of the cold cached data or a command that would completely wipe out any of that type of cached data. Note that I would not expect any of this to affect the standard hot cache data which always lives on the disk.

    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 →
  13. allow metadata (to specify Service Tree attribution) at the database level

    Several teams share clusters which makes assigning the streams challenging and they go to the cluster owner/creator vs the actual DB or table owner. We need a way to assign DBs to individual services so we can allow more granular service attribution. I know metadata can be done at a table level but that's too granular. We need it at a DB level as well. This scenario is important for GDPR and data governance as there are teams who are shying away from registering their shared clusters so they do not get all the action items assigned to them

    1 vote
    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. tableifexists or other way to query if a table exists (without access to . control commands)

    There appears to be a "columnifexists" function that allows for queries where a column might not exist. But there doesn't seem to be a similar way to check if a table exists? (without having access to .show tables, etc)

    1 vote
    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 →
  15. Autocomplete on categorical string column values

    Let's say that your table has a column called SomeColumn that only has 10 different possible string values. Then, I think it would be useful to have autocomplete when trying to do a string match:

    SomeTable
    | where SomeColumn == '[Show autocomplete options]

    This would avoid having to do a "distinct" operator to figure out the values and then copy that value into another query.

    1 vote
    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. Follow at the table level

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

    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 →
  17. Support .create-or-alter external table

    .create external table command causes an error if the table already exists. This is inconvenient for automated deployment. Would be nice if -create-or-alter was supported!

    1 vote
    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. Invoke a function from another database

    Currently I can only invoke a function if it is in the same database. I would like to invoke functions in other databases (and ideally in other clusters.) There are two main use cases:
    1) We have some useful helper functions that use the invoke pattern. We have to copy them to all of our databases.
    2) When doing .set-or-append commands, I'm stuck if my query involves a an invoked function on database A but I want the results written to database B.

    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 →
  19. Supply syntax to use Service-specific schemas no general the Top-level diagnostic logs schema

    Can we supply syntax to use the [Service-specific schemas](https://docs.microsoft.com/en-us/azure/azure-monitor/platform/diagnostic-logs-schema#service-specific-schemas-for-resource-diagnostic-logs) template for specific Azure services, not general the [Top-level diagnostic logs schema](https://docs.microsoft.com/en-us/azure/azure-monitor/platform/diagnostic-logs-schema#top-level-diagnostic-logs-schema). I don't want to type each column property with `project operator` all the time. Is it possible?

    1 vote
    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 →
  20. Add a new function to convert a base64 string to a dynamic array of 0-255 values

    Currently there is a function to convert a base64 string to utf8 string i.e. base64_decodestring. However if there is no valid string output, that function fails and returns nothing.

    e.g. print base64_decodestring("igAAAAAAAACDAAAAACAAAA==")

    There are cases where we need a byte representation of a base64 string. Having a function like base64_decodearray that gives a dynamic array of 0-255 values allows us to get that.

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

Azure Data Explorer

Categories

Feedback and Knowledge Base