DENODO_ASSISTANT_GENERATE_FIELDS_NAME¶

The stored procedure DENODO_ASSISTANT_GENERATE_FIELDS_NAME generates a new name for one or more fields calling the configured LLM service. In order for this procedure to work you must have configured the Denodo Assistant.

Syntax

DENODO_ASSISTANT_GENERATE_FIELDS_NAME (
      <database : text>
    , <view : text>
    , <input_fields : array>

)

• database: name of the database.

• view: name of the view you want to obtain its fields.

• input_fields: array fields which you want to generate a new name for.

The procedure returns these fields:

• output: array which contains the response of the LLM service:

• inputFieldName: original name of the field.

• outputFieldInfo: generated name of the field.

• withViewInformationExclusion: boolean that indicates if any of the view’s information had to be excluded to stay within the model token limit before being sent to the configured LLM service. Please note that excluding such details may impact the accuracy or completeness of the response provided.

Privileges Required

To execute this procedure, the user must have the use_large_language_model_role role or be a global administrator.