vscode-dbt-power-user
vscode-dbt-power-user copied to clipboard
AltimateAI
Improve Query Results for Json Objects
Describe the feature
It would make Dbt Power User much easier to explore data and develop new models if there were some improvements to Query Results.
-
Truncate large column value Currently large column values span across making it really hard to view all of the columns in a query. It would be useful if large values were truncated.
-
Beautify json objects Because values span a single row, it makes it challenging to read, understand and then write statements to extract keys and values from objects.
Truncating + formatting objects would make using Power User much better. For now, I must explore data in dbt Cloud or Bigquery to get an understanding of the objects.
Describe alternatives you've considered
No response
Who will benefit?
No response
Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
+1 on this. If you want an example of what works well, the Snowsight UI does this pretty well. Also dbt Cloud does it OK. But my beef with dbt Cloud is that you can't expand the column width, so if you have a long column header it is truncated an you have no idea what the full column name is... awful.
Anyhow, I think a good UX is long values are truncated per the suggestion above, then you click on a cell and a window pops out on the right with the formatted JSON or full length long text.
@jeff-skoldberg-gmds and @jlogan3, we have deployed this feature in version 0.44.0. Please review and inform us of any feedback.