Display nested columns as key value instead of array in SQL Lab

[brouberol]

Some of our Superset user have voiced that the Cell content modal displaying the content of a nested column in SQL Lab isn't as helpful as could be. It is currently displayed as an array, causing them to having to go back and forth between the actual data and the schema itself.

nested column displayed as an array

I was wondering whether it would be valuable to have the option to display these nested columns as key/value mappings instead, such as this:

Note: this is the result of a small (+15/-0) patch applied on a staging Superset instance, in order to showcase the demo. If there's indeed interest, I'll be more than happy to open a PR to discuss the patch itself.

Thanks!

[yashAmbekar-groww]

Yes this will help alot. Can you fork and push your patch to a branch and share the branch here? Was thinking to patch superset for my org's usecase. If they add this to superset then it would be the ideal case for us.

[brouberol]

The patch can be seen here.

[mkopec87]

@brouberol , I'm also interested in that feature! Please continue with making a PR, let's see what the maintainers think :)

BTW. will your solution work for deeper nesting, that is a nested column under nested column?

[brouberol]

I'll try to take the time to submit this upstream in the near future. As it stands, I"m not sure it supports recursively nested columns. I'm sensing this might require a bit of frontend work as well. I'll investigate when I submit the patch upstream.