Configure SQL AI Assistant using the Amazon Bedrock Service

This topic describes how to configure the SQL AI Assistant using the Amazon Bedrock Service.

You must have an AWS account with Bedrock access. For more information on accessing keys, see Amazon Bedrock.

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:
```
[aws]
  [[bedrock_account]]
    access_key_id_script='echo $AWS_BEDROCK_ACCESS_KEY_ID'
    secret_access_key_script='echo $AWS_BEDROCK_SECRET_ACCESS_KEY'
    region='us-east-1'
[desktop]
  [[ai_interface]]
    service='bedrock'
    model='claude'
```
AWS_BEDROCK_ACCESS_KEY_ID and AWS_BEDROCK_SECRET_ACCESS_KEY must be added as encoded values under hue-secret. For more information, see Secure approach for passing a token.
Click Save Changes.

You see

Assistant on the Hue SQL editor, and the SQL AI Assistant will connect to the specified model in the Amazon Bedrock service.