Configuring the SQL AI Assistant in Cloudera Data Warehouse
Learn how to configure the SQL AI Assistant in Cloudera Data Warehouse 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 the approach you are using for passing the token
and your platform:
- Azure
-
[desktop] [[ai_interface]] service='azure' model_name='[***DEPLOYMENT-NAME***]' base_url="https://[***RESOURCE***].openai.azure.com/"
- OpenAI
-
[desktop] [[ai_interface]] service='openai'
- 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.