Skip to content

4. Update Descriptions and Tag Semantics

Note

This tutorial is optional if your Data Warehouse already provides table and column descriptions. If descriptions are missing or incomplete, this tutorial shows how to manually edit and update them.

Additionally, manual semantic tagging is not required, as Feature Ideation will automatically infer and fill in missing semantic tags.

Accurate descriptions and semantic tagging of data fields and tables are essential for creating meaningful features and minimizing noise. While traditionally performed informally, FeatureByte has streamlined this process into a structured and efficient workflow.

Our approach maps each data column to a data ontology, enabling the selection of suitable feature engineering techniques. Powered by Feature Ideation, this process uses Generative AI to analyze metadata and recommend semantic tags for columns.

Providing clear data descriptions enhances Feature Ideation's ability to deliver tailored recommendations, suggest relevant data aggregations, transforms, filters, and feature combinations. Although Feature Ideation works without these descriptions, their inclusion improves the quality of its outputs.

Step 1: Update Table Descriptions

  1. From the menu, navigate to the 'Explore' section and open the Table Catalog. If you're on the Table Diagram page, click Table Catalog to return to the Table Catalog. Table Catalog

  2. Verify the following table descriptions:

    Table Description
    GROCERYCUSTOMER Customer details, including their name, address, and date of birth
    GROCERYINVOICE Grocery invoice details, containing the timestamp and the total amount of the invoice
    INVOICEITEMS Details of grocery product items within each invoice, including quantity, total cost, discount applied, and product ID
    GROCERYPRODUCT Product group description for each grocery product

  3. Edit the table's description:

    • Select the table from the Table Catalog.
    • Go to the 'About' tab.
    • Update the description by clicking Table Catalog next to the description field.

    Table Description Table Description Edit

Step 2: Update Column Descriptions

  1. Select a table from the Table Catalog.
  2. Navigate to the 'Columns' tab.
  3. Update the description by clicking Table Catalog next to the description field of the column.

Column Description Edit

Step 3: Tag Semantics

For each table:

  1. Select it from the Table Catalog.
  2. Go to the 'Columns' tab.
  3. Click Run Semantic Type Detection to run semantic tagging.
  4. Review the suggestions provided. Accept, adjust, or leave the column semantically untagged.

Semantic Tagging Suggestions

Note

Columns that remain semantically untagged will automatically be tagged by Feature Ideation.