Cloudera Docs

Configure SQL AI Assistant using the OpenAI platform

This topic describes how to set up SQL AI Assistant and connect to a model on the OpenAI platform.

You must have created an account with the OpenAI platform.

  1. Log in to the CDP Management Console as an Administrator.
  2. Go to Environments and select your environment.
  3. Go to the Data Lake tab and click on the CM URL to open Cloudera Manager.
  4. 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: 
    [desktop]
  [[ai_interface]]
    service='openai'
    You can specify the model_name (optional) and define the model. If no model is defined, the default model (gpt-3.5-turbo-16k) will be used.
  5. Click Save Changes.
You see Assistant on the Hue SQL editor, and the SQL AI Assistant will connect to the specified model on the OpenAI platform.