A better collaborative Data Warehouse Experience with SQL query sharing via links or gists

Published on 04 March 2020 in Version 4 - 2 minutes read - Last modified on 06 March 2021 - Read in jp

Hi Data Crunchers,

For the past 10 years, Hue's SQL Editor has been targeting the SQL Data Warehouse Experience. It recently got better support for typing SQL queries by showing column keys. The latest improvement is about better collaboration.

Via the document sharing capabilities and query parameterization, Hue allows teams to build their own query bank of knowledge. To complement this, something quicker and easier is now also available: Public link & Gist sharing.

Goal: quickly sharing parameterized saved reports, customer analyses links.

Public links are the same as in Google documents. They only require the recipient to have a Hue login. People can then reuse the queries on their own by executing them to see the results, fork and adapt them.

  • No need to select groups or list of individual users
  • Read, write permissions
  • Linked documents won't show up in your home
  • Can be turned off globally
  • Can be combined with traditional user/group sharing

Here is an example:

Saved queries can be shared directly via the editor or the left document assist. Notice that documents already shared are showing-up with a little person icon:

Editor share menu

Assist share menu

Document preview is also smoother now and indicates owner, permissions and last update time:

Editor share menu popup

Here is the sharing popup with the public link option on the top:

Editor share menu popup

SQL Snippet - Gist

Goal: quickly share SQL snippets, with a direct link to the SQL editor.

Answering a question via a query result? Showing some weird data to a slack channel? Gist are a great quick way to do that.

  • Works with an SQL snippet: one or more statements
  • The link automatically point to the editor and the SQL content
  • The query is displayed in the friendlier presentation mode
  • Slack unfurling will show a mini preview (can be turned off globally)
  • Gists are stored in a Gist directory in your home

Here is an example:

Select a portion of statements to quick share with a Slack channel:

Editor share gist menu

The link to the SQL fragment is automatically generated:

Editor share gist popup

Just paste the link in the Slack channel and users will get a mini preview:

Open gist in Slack

Clicking on the link will open-up the SQL selection:

Open gist

Any feedback or question? Feel free to comment here or on the Forum and quick start SQL querying!

Romain, from the Hue Team


comments powered by Disqus

More recent stories

03 May 2023
Discover the power of Apache Ozone using the Hue File Browser
Read More
23 January 2023
Hue 4.11 and its new dialects and features are out!
Read More