Cleaner BigQuery structured fields in Preview

[portalhacker]

Describe the feature

In the BigQuery UI, structured fields are displayed like regular columns.

However in the dbt-power-user preview these fields are displayed a single less readable object with multiple keys, like:

privacy_info
{"analytics_storage": null, "ads_storage": null, "uses_transient_token": "No"}

Moreover, when we have larger objects the column gets truncated, and we cannot see all values.

Please note this is issue is not about repeated fields (aka arrays) which may require even more thinking and work to manage.

Describe alternatives you've considered

Using a different extension, but without much success yet.

Who will benefit?

Every dbt-power-user working with structured data in BigQuery.

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

[anandgupta42]

@FloDevelops, can you upgrade to the latest version of the extension (0.45.0) and check if the issue still exists?

[portalhacker]

@anandgupta42 I am on the latest version (0.45.3) and this issue is not fixed, or at least not as intented.

For example in this preview I understand I can preview a single object on the side panel, however I cannot properly look at many rows at once, particularly when each record has values of varying lengths.

A better behaviour would be closer to the one in the BigQuery UI.