title: A better collaborative Data Warehouse Experience with SQL query sharing via links or gists author: Romain type: post date: 2020-03-04T02:36:35+00:00 url: /blog/2020-03-04-datawarehouse-database-sql-collaboration-and-sharing-with-link-and-gist/ sf_thumbnail_type:
Version 4
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.
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:
Document preview is also smoother now and indicates owner, permissions and last update time:
Here is the sharing popup with the public link option on the top:
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.
Here is an example:
Select a portion of statements to quick share with a Slack channel:
The link to the SQL fragment is automatically generated:
Just paste the link in the Slack channel and users will get a mini preview:
Clicking on the link will open-up the SQL selection:
Any feedback or question? Feel free to comment here or on the Forum and quick start SQL querying!
Romain, from the Hue Team