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 Data Warehouse service
Go to the Virtual Warehouses tab, locate the Virtual Warehouse on which you want to enable this feature, and click > Edit.

Go to Configurations > Hue, select hue-safety-valve from the Configuration files drop-down menu, and add the following lines :

[desktop]
[[ai_interface]]
    service='azure'
    model_name='[***DEPLOYMENT-NAME***]'
    base_url="https://[***RESOURCE***].openai.azure.com/"

Click Apply 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.