DENODO_ASSISTANT_GENERATE_VIEW_DESCRIPTION¶

The stored procedure DENODO_ASSISTANT_GENERATE_VIEW_DESCRIPTION generates a description for a view calling the configured LLM service. In order for this procedure to work you must have configured the Denodo Assistant.

Syntax

DENODO_ASSISTANT_GENERATE_VIEW_DESCRIPTION (
      <database : text>
    , <view : text>
    , <descriptionLength : integer>

)

• database: name of the database.

• view: name of the view to describe.

• descriptionLength: (optional) maximum number of words allowed in the description. If null, the procedure will default to 200.

The procedure returns these fields:

• viewInformation: description of the view.

• 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.