Enabling SQL AI Assistant API via UI

You can enable the SQL AI Assistant API capabilities via Data Explorer UI by adding the required configuration to the Hue safety valve.

Follow these steps to enable the SQL AI Assistant API capabilities in Data Explorer UI.

  1. After successful model deployment, log in to Cloudera Data Warehouse service.
  2. Navigate to the Virtual Warehouses tab and select the desired Virtual Warehouse to enable.
  3. Click Details > Configurations > Data Explorer (Hue).
  4. From the Configuration files dropdown, select hue-safety-valve.
  5. 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
  6. Click Apply Changes.
  7. Restart the service.