Ability to hide null / empty columns & collapse columns in Query results (both query editor and notebooks) for easy navigation on large result set

[MsSQLGirl]

Is your feature request related to a problem? Please describe. When querying lots of data, it is possible that a lot of the columns are NULL or empty.

Describe the solution or feature you'd like Create a setting to hide and unhide empty columns. This is something that Kusto Explorer can do well. Scenario: To look at really large tables, users like to hide blank columns. And collapse columns which only one value. Instead of showing the column in the grid. It is extracted out as metadata on the top. ColumnName: Value. Gives more space in the grid to look at interesting columns.

Describe alternatives you've considered No really good alternative for this.

Additional context Add any other context or screenshots about the feature request here.

[MsSQLGirl]

• @qifahs Please feel free to add additional details here.

[qifahs]

It would be good to summarize single value columns too in addition to empty columns.

[bkane-msft]

My team uses a lot of Azure Data Studio for oncall incident investigation. The ability to hide null/empty columns would help us a lot, especially when using something like evaluate autocluster().

[bkane-msft]

Oh nevermind. I thought this issue was for Azure Data Explorer ... Still seems helpful here though!

[amiyaaloke]

Empty columns take lot of real estate in query results. Ability to hide null or empty columns will be very helpful.