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 rework.
A proposed solution might look like this:
| project Bar, Baz, Qux, *
Dimitri Blyumin commented
In our case we have several hundreds of columns with the common prefix, most of which are not needed in any particular query. It would be great to be able to:
| project-away CommonPrefix*
Sue Loh commented
project-reorder is helpful to reorder them, and supports (limited) wildcards like * or myprefix_*.
However project doesn't seem to support wildcards, and they'd be useful for selecting columns to keep. :-(