AI Prompt

The article will help the user understand how we have leveraged OpenAI functionality and Human Assistance to curate descriptions for data objects and business glossary terms.

Human-assisted AI

Human-assisted AI, often called hybrid intelligence or human-in-the-loop AI, is a collaborative approach where human expertise and machine intelligence complement each other to achieve superior results. In this framework, humans provide guidance, feedback, and validation to AI systems, enhancing their capabilities and addressing their limitations.

Prompts to AI

Prompts to AI are instructions or queries provided to artificial intelligence systems to generate specific outputs or responses. These prompts serve as input to AI models, guiding them to produce desired outcomes based on the context and requirements provided.

Problem Statement

OpenAI was integrated, enabling the generation of descriptions for Data Cataloged objects and Business Glossary Terms. Basic metadata information like domain names, categories, tables, and columns was provided to OpenAI. However, inaccuracies were noticed in the descriptions, especially with vague names such as "OE_Table."

Solution

To enhance accuracy, we realized the need to provide OpenAI with more detailed information. Administrators can set up questions in AI Prompt that are visible to stewards, who can then assign these questions to relevant stakeholders for answers. These questions will help gather precise details for OpenAI to create better descriptions. After collecting all answers, they will be fed back into OpenAI to generate more accurate descriptions, aiding in effectively managing data.

Curation by AI Questions

Curation by AI Questions are simple queries that gather specific details about data objects or business terms. These questions provide information that AI systems, like OpenAI, use to generate accurate descriptions.

For example, a question might ask about the purpose of a data table or the category of a business term. Answering these questions improves the quality of the AI-generated descriptions, making data easier to understand and manage. The AI prompt questions repository is available on the AI Prompt Questions page. To view the questions, choose from the following:

  1. Object Type

  2. Description Type

  3. Connector or Global Type

  1. Object Type: Select the object type from the available list of object types,

  • Schema

  • Tables

  • Table Columns

  • Files

  • File Columns

  • Reports

  • Report Columns

  • APIs

  • API Attributes

  • Codes

  • Business Glossary

  1. Description Type:

    1. Data Catalog

    If the Data Catalog Object types are chosen, the available description types are:

    • Business Description

    • Technical Description

b. Business Glossary:

If the Business Glossary is chosen as an object type, the available description types are:

  1. Business Description

  2. Detailed Description

  3. View the Global or Connector-specific questions after selecting the Object Type and Description Type.

Security

  • Authors can view the Prompt questions for all object types and description types.

  • Only Super Admin (with the configuration ovaledge.role.admin) can add/edit/delete prompt questions from the AI Prompt questions page.

Add Questions

  • After selecting the object and description types, questions can be added for all connectors or only for a specific connector.

  • Questions are limited to 1000 characters.

  • A maximum of 100 questions can be added at the Global or connector level.

Edit/Delete Questions

Editing/Deleting Questions allows modifying or removing questions within the AI prompt. This feature refines the prompt process, ensuring questions capture the necessary information for generating descriptions.

For example, if a question is unclear or redundant, edit or delete it to streamline the prompt experience. This feature enables continuous improvement by adjusting questions based on feedback and evolving requirements.

To edit or delete a question, select it and choose "edit question" from the 9 dots menu. A popup window will appear to edit the question. The edit option is disabled when multiple questions are selected.

Multiple questions can be selected and deleted at once. Deleting a question from the repository removes the question and its answers for all objects.


Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA USA

Last updated

Was this helpful?