Cloudera Docs

Configure SQL AI Assistant using the Cloudera AI Inference service

This topic describes configuring the SQL AI Assistant using the Cloudera AI Inference service.

To know more about installing and setting up the Cloudera AI Inference service, see Prerequisites for setting up the Cloudera AI Inference service.

  1. Upon successful completion of model deployment, log in to the Cloudera Data Warehouse service.
  2. Go to Configurations > Data Explorer (Hue), select hue-safety-valve from the Configuration files drop-down menu, and add the following lines :
  3. Go to the Virtual Warehouses tab, locate the Virtual Warehouse on which you want to enable this feature, and click > Edit. 
  4. [desktop]
[[ai_interface]]
service='caii'
model_name='[***Place MODEL name here***]'
base_url="https://[***RESOURCE***]/v1"
  5. Click Save Changes.
You see Assistant on the Data Explorer SQL editor, where the SQL AI Assistant utlizes the model hosted in Cloudera AI Inference service.