Enabling the SQL AI Assistant in CDW

After you configure the SQL AI Assistant on the supported platforms (Azure, AWS, or OpenAI), enable it in Cloudera Data Warehouse (CDW) to use it in Hue.

Log in to the Data Warehouse service as DWAdmin.
Go to the Virtual Warehouses tab, locate the Virtual Warehouse on which you want to enable this feature, and click > Edit.

Go to CONFIGURATIONS > Hue, select hue-safety-valve from the Configuration files drop-down menu, and add the following lines depending on your platform:

(Azure)

[desktop]
[[ai_interface]]
    service='azure'
    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 Apply Changes.

You see

Assistant on the Hue SQL editor.