Adding Query Store Administrator users in Cloudera Data Warehouse
The Query Store Administrators have special privileges that enable them to view and monitor queries from all users, including the ones that were submitted from query interfaces, such as Beeline, Hive Warehouse Connector (HWC), Tableau, and so on.
Make sure that the Virtual Warehouse to which you want to add the Hue Query Store Administrators users is in the running state. If it is in a stopped state, then start it, and wait until it is in the running state.
- Log in to the Cloudera Data Warehouse (CDW) web interface as a DWAdmin.
- Click on the Database Catalog for which you want to add Hue Query Store Administrators users.
On the Database Catalog details page, click and select hue-query-processor.json from
the Configuration files drop-down menu, as shown in the
In the “
authConfig” section, add the list of users to the “
adminUsers” key.For example: "adminUsers": "hive, [***USER-1***], [***USER-2***]"
The Hue service will be unavailable for approximately 5 minutes to make the update.