Configure SQL AI Assistant using the Microsoft Azure OpenAI service

Microsoft Azure allows for dedicated deployments of OpenAI GPT models. You can use Azure’s OpenAI service instead of the publicly hosted OpenAI APIs, as it enables data processing within your Azure Virtual Network (VNet) network. GPT models can also be integrated with the Hue SQL AI Assistant using Azure’s OpenAI service.

Obtain a Microsoft Azure subscription by working with your organization’s IT team and registering for access to the Azure OpenAI service. For more information, see Create and deploy an Azure OpenAI Service resource.

Log in to the CDP Management Console as an Administrator.
Go to Environments and select your environment.
Go to the Data Lake tab and click on the CM URL to open Cloudera Manager.
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='azure'
    model_name='[***DEPLOYMENT-NAME***]'
    base_url="https://[***RESOURCE***].openai.azure.com/"
```
Click Save Changes.

You see

Assistant on the Hue SQL editor, and the SQL AI Assistant will connect to the specified model on the Microsoft Azure OpenAI service.