Data Descriptions for Database Objects

Generate descriptions for the database tables and columns. This helps improve query generation and data understanding by providing meaningful descriptions for tables and columns. You can either manually enter details or use the Auto-Generate Description for All Tables option for automatic generation.

Auto-Generate Description for All Tables #

Automatically generates descriptions for all tables and their columns.

Table Description #

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

Update Table Description #

Provide a summary of the table’s contents. You can manually enter details or use the Automatically generate descriptions 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 Descriptions #

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 Automatically generate descriptions 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: Knowledge Sources, where you can choose to provide Instructions for advanced data reasoning by integrating business rules from a knowledge base.