USER MANUALS

Denodo Assistant Features that Use Large Language Models

Denodo has several features that use a large language model (LLM). Denodo does not have an LLM built-in; it relies on popular third-party services like OpenAI and Amazon Bedrock. Denodo uses the REST API these services provide to send data to them and obtain the desired output. When the enabling these features, the administrator of Denodo has to provide the user account of your organization.

These features are only available with the subscription bundle Enterprise Plus. To find out the bundle you have, open the About dialog of Design Studio. See more about this in the section Denodo Platform - Subscription Bundles.

Prior to using any of these features, enable them in Design Studio, in Server configuration > DENODO ASSISTANT.

Privileges Required to Use These Features

To use the Denodo Assistant features that use a large language model the user must have the use_large_language_model role or be an administrator.

Data Sent

For these features, when a view is involved and only if the user has metadata permission over the view, the following data is sent to the large language model API:

  1. The name of the view.

  2. The name of the view’s database.

  3. For each field, the following information:

    1. The name of the field.

    2. The logical name of the field if it is configured.

    3. The type of the field.

    4. The description of the field.

    5. Information about if the field is a primary key.

    6. Information regarding if the field is nullable.

    7. The name and the description of the tags that are assigned to the field.

    8. If the data usage and the cache is enabled if the user has execute permission over the view, data samples of the view are also included.

  4. The description of the view.

  5. The name and the description of the tags that are assigned to the view.

  6. For each direct association, the same information as for the view.

Warning

The Denodo Assistant will send metadata information to the large language model API. Only if the use sample data is enabled, data of the view is also going to be processed and sent to the large language model API to improve the results. Make sure your organization is aware and agrees on this.

If a view contains too much information, some of the view’s information may need to be excluded before being sent to the configured LLM Service provider to avoid exceeding the token limit supported by the model. Please note that excluding such details may affect the accuracy or completeness of the response provided. In extreme cases this may cause the response process to stop. When these situations occur a suitable notification will be shown.

Features

The Denodo Assistant features that use large language models can help you with the following tasks:

  • Suggest view description. The suggest view description function generates a descriptive text for a given view.

  • Suggest field descriptions. The suggest field descriptions feature generates concise text explanations for fields.

  • Suggest field names. The suggest field names generates appropriate names for data fields.

  • Explain query. The explain query offers comprehensive explanations for VQL queries.

  • Diagnose query. The diagnose query provides a corrected version of the provided query with an explanation of the changes made.

  • Predefined functions. See section large language model functions

  • Automatic generation of queries in the Data Catalog. The assisted query allows to generate a query by explaining it in natural language.

Add feedback