You can specify user groups you created in the Cloudera Management Console, similar to how you specified them while creating the
Virtual Warehouses.
When you specify user groups while creating the shared Hue instance or Virtual
Warehouses, the subset of users who have access to the Hue instance as well as the
Virtual Warehouse can submit queries through that Virtual Warehouse instance.
If you do not specify user groups while creating a shared Hue instance, then all users
within your organization can access the Hue UI. If you do not specify user groups for a
Virtual Warehouse, all users within your organization can submit queries through that
Virtual Warehouse.
As a best practice, specify user groups while creating Hue and Virtual
Warehouse instances so that specific users have access to specific compute
resources.
Key differences in database management approach for Virtual Warehouse-level Hue
and shared Hue service🔗
All Hue instances linked to a Database Catalog through Virtual Warehouses
within a Cloudera Data Warehouse environment
share a single database. The Hue database is not deleted unless you deactivate the
environment. If you delete a Virtual Warehouse and create a new one, the Hue
instance linked to that Virtual Warehouse continues to display old query history and
saved queries.
Each shared Hue service instance has its own Hue database. Cloudera Data Warehouse does not delete the
Hue database when you delete the shared Hue service instance. The Hue database
exists in the backend until a database administrator manually deletes it. Each Hue
database is named after the shared Hue service name. In case you have deleted a
shared Hue service instance, you can reuse the Hue database by specifying the name
of the Hue instance you deleted. This brings back the query history and saved
queries.
Cloudera Data Warehouse provides you with a
one-time option to copy the Hue database content from the Hue database linked to a
Database Catalog to the shared Hue service database while creating a new shared Hue
service instance. The data between the two databases is not synchronized after the
initial copy event.
