Configuring the SQL AI Assistant in Cloudera Data Warehouse

Learn how to configure the SQL AI Assistant in Cloudera Data Warehouse to use it in Hue.

  1. Log in to the Data Warehouse service as DWAdmin.
  2. Go to the Virtual Warehouses tab, locate the Virtual Warehouse on which you want to enable this feature, and click > Edit.
  3. Go to Configurations > Hue, select hue-safety-valve from the Configuration files drop-down menu, and add the following lines depending on the approach you are using for passing the token and your platform:
    Azure
    [desktop]
    [[ai_interface]]
        service='azure'
        model_name='[***DEPLOYMENT-NAME***]'
        base_url="https://[***RESOURCE***].openai.azure.com/"
    OpenAI
    [desktop]
    	[[ai_interface]]
    		service='openai'
    Azure
    [desktop]
    [[ai_interface]]
        service='azure'
        model_name='[***DEPLOYMENT-NAME***]'
        base_url="https://[***RESOURCE***].openai.azure.com/"
        token="[***RESOURCE-KEY***]
    AWS
    [aws]
    	[[bedrock_account]]
    		access_key_id='[***ACCESS-KEY***]'
    		secret_access_key='[***SECRET-KEY***]'
    		region='us-east-1'
    [desktop]
    	[[ai_interface]]
    		service='bedrock'
    		model='claude'
    OpenAI
    [desktop]
    	[[ai_interface]]
    		service='openai'
    		token='[***API-KEY***]'
  4. Click Apply Changes.
You see Assistant on the Hue SQL editor.