Configuring the Hue SQL AI Assistant

Learn how to configure the Hue SQL AI Assistant.

In this task, you specify the token value in the Hue Advanced Configuration Snippet field in Cloudera Manager. The credentials are saved in a configuration file in the plain text format.

Log in to the CDP Management Console as an Administrator.
Go to Environments and select your environment.
Go to the Data Lake tab and click on the CM URL to open Cloudera Manager.

Go to Clusters > Hue service > Configuration and select add the following lines in the Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini field:

Azure

[desktop]
[[ai_interface]]
	model_name='[***DEPLOYMENT-NAME***]'
	base_url="https://[***RESOURCE***].openai.azure.com/"
	token="[***RESOURCE-KEY***]”

AWS

[aws]
	[[bedrock_account]]
		access_key_id='[***ACCESS-KEY***]'
		secret_access_key='[***SECRET-KEY***]'
		region='us-east-1'
[desktop]
	[[ai_interface]]
		service='bedrock'
		model='claude'

OpenAI

[desktop]
	[[ai_interface]]
		service='openai'
		token='[***API-KEY***]'

Click Save Changes.

You see

Assistant on the Hue SQL editor.