USER MANUALS


DENODO_ASSISTANT_GENERATE_FIELDS_DESCRIPTION

The stored procedure DENODO_ASSISTANT_GENERATE_FIELDS_DESCRIPTION generates a description 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_DESCRIPTION (
      <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 with the fields whose description you want to generate.

The procedure returns these fields:

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

  • inputFieldName: name of the field described.

  • outputFieldInfo: generated description 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.

Add feedback