Enabling SQL AI Assistant API

Enable the SQL AI Assistant API capabilities through Cloudera Manager by adding the required configuration to the Data Explorer safety valve.

  1. After successful model deployment, log in to Cloudera Manager.
  2. Go to Cloudera Manager > Clusters > Data Explorer (Hue) > Configuration and select the Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini field.
  3. Add the following lines:
    
    [[llm_provider]]
    name='azure'
    model_name='gpt-4o-hue'
    api_version='2024-12-01-preview'
    base_url='https://hue-ai-xxxx.openai.azure.com'
    token='xxxxxxxx'
    assistant_api_enabled=true
                        
  4. Click Apply Changes.
  5. Restart the Data Explorer service.