30 June 2021
Azure Storage sharing by leveraging SAS tokens so that your users don’t need credentials
Example tutorial on how to use the the Azure storage REST API with Shared Access Signatures. We previously covered a similar methodology for providing access to S3 data without giving out actual credentials via some S3 signed URLs. This time we will explore it on Azure, the Cloud data platform from Microsoft. “Trying to” keep things simple for the end users The main use case for us is still to provide a platform agnostic File Browser for the Hue users to allow self service data querying.…4 minutes read - Version 4.11 / Development
10 June 2021
Hue 4.10 and its new SQL Editor component, REST API, small File Importer and Slack App are out!
Hi Data Explorers, The Hue Team is glad to thanks all the contributors and release Hue 4.10! Here is a summary of the main improvements of 4.10 on top of the previous 4.9 release: SQL Editor Component & API Now build your own SQL Editor in three HTML line by leveraging the SQL Scratchpad component. The first version of the public REST API for executing queries was also published.…2 minutes read - Version 4.10 / Release
29 May 2021
Build your own SQL Editor (BYOE) in 5 minutes via Sql Scratchpad component and public REST API.
Leveraging the new Hue’s SQL Scratchpad Web Component and REST API into your own project. The Hue SQL Editor project has been evolving for more than 10 years and allows you to query any Database or Data Warehouse. Segmenting the overall project into fully decoupled components is one reason it could rapidly evolve and still be alive after so long. The already popular SQL Parser component is now joined by the SQL Scratchpad component.…3 minutes read - Version 4.10 / Development / Query
26 May 2021
Improved Hue Importer -- Select a file, choose a dialect, create a table
If you’ve ever struggled with configuring Hue to allow your users to create new SQL tables from CSV files on their own in the public Cloud, you’ll be happy to learn that this is now much easier. If you're a pro Hue user, then you might be familiar with the Hue Importer. It lets you create tables from a file. Until now, the file had to be available on HDFS or cloud object storage, such as S3 or ABFS.…2 minutes read - Version 4.10 / Development / Query
18 May 2021
Installing Hue Slack App in 3 Simple Steps!
Ever wondered about having a SQL Assistant which can help you to collaborate better with other SQL users in your team? That too in Slack itself!? This Slack Integration for Hue can fit those shoes for assisting you with your SQL queries in your Slack channels. Easy to use and now even easy to install for Slack workspace admins in just 3 simple steps! Kudos to Slack for recently rolling out its App Manifest beta feature for Slack Apps!…2 minutes read - Version 4.10
23 April 2021
Provide your users proper S3 file access without giving them any credential keys
Using AWS S3 Signed URLs to list buckets, keys and manage files. SQL querying opens up your data and helps users take decisions backed by hard facts. However, what if the data they need is not present already in the Data Warehouse? In order to provide a more self service experience, they could bring their own data to query or join, then export and share the query results files etc.…4 minutes read - Version 4.10 / Development
19 April 2021
Distribute your container App as a Package
09 April 2021
Collaborate on your SQL queries and results directly within Slack!
Introducing the Slack integration for Hue SQL Editor The Hue project which is celebrating its 11th anniversary this year is based on these three principles: Query. Explore. Share. The ‘Share’ principle got its last improvement with the introduction of Public Links and Gist Sharing for better collaboration. Following that path, it is time for the next improvement ;) What could be better than improving the collaboration by using one of the best communication platforms present - Slack!…3 minutes read - Version 4.10
05 April 2021
Interactively Querying HBase via SQL - Tech Talk
Grow your user base able to leverage data stored in HBase via SQL queries with Apache Phoenix and the Hue Web SQL Editor. April 1st 2021 (not a joke ;) we did a tech talk (nicely organized by the Apache Phoenix project) on the underlying technology enabling SQL queries on Apache HBase tables. See the slides: Executing Phoenix queries in Hue SQL Editor For people not familiar with HBase, imagine a giant big table specialized in storing and updating in real time any type of records.…2 minutes read - Version 4.10 / Phoenix
09 March 2021
Process & Learnings when upgrading the Webserver Stack - Django Upgrade (1.11 to 3.1)
The Hue project was started around 10 years back. In the meantime some of our technologies were getting old or deprecated, hence we need to upgrade them for the bright future of HUE. So In this, the Django upgrade was one of the most important ones. We were using Django 1.11 before this upgrade, for which extended support was ended in April 2020. Goal Hue running with Django 3.1 (latest) while still being able to compile/run with 1.…4 minutes read - Version 4.10 / Development