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 .
-
Go to , 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.