search

AltimateAI / vscode-dbt-power-user

This extension makes vscode seamlessly work with dbt™: Auto-complete, preview, column lineage, AI docs generation, health checks, cost estimation etc
https://www.altimate.ai
MIT License
468 stars 94 forks source link

Cleaner BigQuery structured fields in Preview #1423

Open FloDevelops opened 2 months ago

FloDevelops commented 2 months ago

Describe the feature

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

image

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?

anandgupta42 commented 2 months ago

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

FloDevelops commented 1 month ago

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

image

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.