Improved SQL Exploration: SQL Context Popover & Data Catalog

Published on 30 May 2018 in Version 4 - 3 minutes read - Last modified on 06 March 2021

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.

Navigate by either clicking entities in the list or using the breadcrumbs

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.

We hope that these new improvements will help you explore and manage your data. As always, if you have any questions or feedback, feel free to comment here, on the hue-user list or @gethue!


comments powered by Disqus

More recent stories

26 June 2024
Integrating Trino Editor in Hue: Supporting Data Mesh and SQL Federation
Read More
03 May 2023
Discover the power of Apache Ozone using the Hue File Browser
Read More