Greetings SQL masters!
In Hue 4.3 we’ve made a bunch of improvements to SQL browsing and discovery. The SQL Context Popover, available throughout Hue from the assist panels, editor etc. has a simplified layout with one-click access to the most important information about your SQL entities. We’ve also introduced a new File Context Popover that allows you to browse and preview files without context switching.
The Table Browser has been refreshed, it’s been simplified and a couple of new feature have been introduced for Navigator and Navigator Optimizer users.
Improved SQL Context Popover
We’ve simplified the layout and removed the top tabs, now the most important information has been merged into one panel. A preview of column samples are now shown in the column list, you can always click a column to see a full sample.
For each entity various actions are available in the footer, to see more details just click “Table Browser” or to show highlight an entity in the assist click “Assist” .
The same SQL preview panel is shown for search results in the top search bar, from there you can use the footer action or just drag the entry into the editor.
New File Context Popover
There’s a new File Context Popover in town! You can access it from the left assist panel or directly from within the editor. Just like the SQL Context Popover you can navigate the tree through the listing or the title breadcrumb. For files it’ll show a preview allowing you to quickly look at a sample of a file contents without leaving your task at hand. For more details about a file or folder just click the “File Browser” link in the footer.
In the editor you can replace an existing path with a new one by clicking “Insert in the editor” from the footer actions.
Table Browser Refresh
In Hue 4.3 we’ve also made various improvements to the Table Browser. The focus has been on simplification with plain language titles and labels. The database, table and columns lists are new and similar to the ones found in the new SQL context popover. The description editor is new with automatic detection of links and we’ve added editable custom key-value pairs from Navigator.
There’s a new relationships tab that’s available when Hue is configured with Navigator Optimizer. Based on statistics from popular joins it shows you related tables and which columns are the most popular ones in the joins.