Generate Metadata for Database Objects

Define metadata for the database tables selected in the previous step. Metadata helps improve query generation and data understanding by providing meaningful descriptions for tables and columns. You can either manually enter details or use the Generate Metadata for All Tables option for automatic generation.

Generate Metadata for All Tables #

Automatically generates descriptions for all tables and their columns.

Update Table Metadata #

For each table you can enter a description and instructions for querying the table.

Table Description #

Provide a summary of the table’s contents. You can manually enter details or use the Generate Metadata option.

Instructions for Querying Table #

Specify natural language instructions for querying the table.

Example: Group by month each time this table is queried.

Update Column Metadata #

For each column you can enter a description.

Column Name & Data Type #

Displays the list of columns along with their data types.

Column Description #

Provide a summary of each column’s contents, either manually or via the Generate Metadata option.

Download Metadata #

Exports a metadata.csv file containing column metadata, table description and instructions for all tables. Users can edit descriptions in this file offline and upload it to provide refined metadata.

Upload Metadata #

Allows users to upload an updated metadata.csv file with refined metadata.

Save Metadata for All Tables #

Saves the metadata for all tables.

Once metadata is configured, proceed to the next step: Tool Selection, where tools like the Knowledge Base can be configured.